Excel Quiz

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

• True

• False

Which of the following is an absolute cell reference?

• A2

• A:2

• #A2

• $A$2

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

• =F2+F3+F4-53

• =R2*D2

• =5B+6B

• A3+100

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

• worksheet

• field

• cell

• calculation

A group of cells is called a ________.

• cell range

• cell cluster

• column

• row

Where is the fill handle located?

• In the bottom-right corner of the selected cell

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

• At the beginning of any formula or function

• 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 conditional formatting

• It’s using an absolute cell reference

• It’s using the Currency number format

• It’s using a formula

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

• formulas

• number formats

• worksheets

• permissions

Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• It should use quotation marks instead of parentheses

• There is nothing wrong with the formula

• It should use the COUNT function instead

• It should have an equals sign (=) at the beginning

In Excel, Columns are labelled as ___

• A, B, C, etc

• 1,2,3 etc

• A1, A2, etc.

• $A$1, $A$2, etc.