Excel Quiz

The intersection of a row and a column is called a ________.

• worksheet

• sum

• cell

• chart

A group of cells is called a ________.

• multicell

• cell range

• chart

• cell cluster

Where is the fill handle located?

• at the beginning of any formula or function

• on the right side of the Home tab on the Ribbon

• in the bottom-right corner of the selected cell

• in Backstage view

In this image, why does the value in cell G1 look slightly different from the value in the formula bar?

• It's using an absolute cell reference.

• It's using the Currency number format.

• It's using conditional formatting.

• It's using a formula.

You can click the tabs at the bottom of a workbook to switch between ________.

• formulas

• number formats

• permissions

• worksheets

True or False: You can view a formula by double-clicking the cell that contains the formula.

• True

• False

• Not sure

• All options

Which of the following is an absolute cell reference?

• $A$2

• #A2

• A:2

• A2

Which of the formulas below are valid? Select all that apply.

• =5B+6B

• A3+100

• =R2*D2

• =F2+F3+F4-53

What value would Excel return for this formula? =(82-32)/5+8*2

• 36

• 91.6

• 26

• 7.69

What feature did we use to quickly apply the formatting shown in this image?