IBM Course 2-Excel Basics

All Formulas in Excel must start with:

• # sign

• @ sign

• + sign

• = sign

Which of the following actions will “select” all cells in a sheet:

• Clicking on a column’s letter (e.g. A, B, C…)

• Selecting the first cell in column A and, while holding Shift, selecting the last cell in column A.

• Clicking on the space between the first row (marked as number 1) and first column (marked as letter A).

• Clicking on row number 1

What is the function “Wrap Text” used for?

• Left-aligning contents of a cell.

• Center-aligning contents of a cell.

• Adding a border around a cell.

• Breaking long content into multiple lines in a cell.

Assume you are copying cell A1 to cell C3. If cell A1 contains the formula =$B1+$C$1, how would this formula change when copied to cell C3?

• =$D3+$E$3

• =$B3+$C$1

• =$D3+$E1

• =$B3+C$1

Which of the following formulas has a syntax error / is incorrect:

• =IFS(A1 = 5, "Excellent", A1 = 4, “Very Good”, “Good”)

• =IF(A1 = 5, “Excellent”, IF(A1 = 4, “Very Good”, “Good”))

• =IFS(A1 = 5, "Excellent", A1 = 4, “Very Good”, A1, “Good”)

• =IF(A1 = 5, “Excellent”, IF(A1 = 4, “Very Good”, IF(A1, “Good”, )))

When a cell is cut and pasted into a new cell, what will be pasted in the destination cell?

• Any content (e.g. text, numbers, formula) of the original cell.

• Any content (e.g. text, numbers, formula) and formatting of the original cell.

• Only text or number content of the original cell.

• Only formatting of the original cell.

• Only conditional formatting rules of the original cell.

How would you select non-contiguous cells?

• Hold Ctrl → left-click on each cell

• Hold Shift → left-click on each cel

• Right-click on each cell

• Hold Alt → left-click on each ce

Which of the following commands doesn't affect the text font?

• Bold

• Underline

• Borders

• Italics

How should the following formula be written: Multiply Cell A1 by 6, and divide that by 4?

• =A1X6/4

• =A1X6%4

• =A1*6/4

• =A1*6%4

Fill Handle will generate content based on the following:

• Mathematical Series

• Alignment Pattern

• Design Pattern

• All of the Above