Excel Quiz (function and basic tools)

Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5?

• =C1+C2

• =$C1+$C2

• =D2+D3

• =E6+E7

A worksheet ____ is a collection of two or more selected worksheets.

• index

• roster

• group

• cluster

Returns the number of characters you specify from the right side of a string.

• CHAR

• LEN

• RIGHT

• RSTRING

The best formula to calculate Profits for January is:

• =SUM(B2:B3)

• =B2-B3

• =B4-(B2+B3)

• =A4-(A2+A3)

"AAA" is an example of a ____ in Excel.

• cell reference

• column heading

• name box

• row heading

What is the purpose of the Filter feature in Excel?

• To sort the data

• To delete data

• To display only the data that meets certain criteria

• To add rows

function is used to count the number of numerical values in a range?

• COUNT()

• COUNTBLANK()

• COUNTIF()

• COUNTA()

How do you change the background color of a cell in Excel?

• Press Ctrl + B

• Use the “Fill Color” button in the ribbon

• Right-click and select “Background Color”

• Use the “Font Color” button

How do you merge two or more cells in Excel?

• Use the SUM function

• Click Merge & Center in the Home tab

• Use Ctrl + M

• Right-click and select Merge

What does the Freeze Panes feature do?

• Changes the font style

• Locks specific rows and columns in place

• Hides the Ribbon

• Deletes unwanted data