# MS Excel Workbook And Formulas! Trivia Quiz

20 Questions | Total Attempts: 298  Settings  .

• 1.
The location of a cell in a worksheet indicated by the column and a row.
• A.

Formula

• B.

Operator

• C.

• 2.
In the example C5, the "C" represents the cells.
• A.

Column

• B.

Row

• C.

Absolute reference

• 3.
A row is
• A.

A vertical range of cells referred to by a number.

• B.

A horizontal range of cells referred to by a number.

• C.

A vertical range of cells referred to by a letter.

• 4.
A sheet tab is located at the bottom of the worksheet window and is used to display the...
• A.

Active cell

• B.

Formula bar

• C.

Worksheet name

• 5.
This is a built-in formula that enables you to perform common calculations in a workbook.
• A.

Function

• B.

Value

• C.

Sort

• 6.
All formulas begin with this symbol.
• A.

* (asterisk)

• B.

\ (forward slash)

• C.

= (equal sign)

• 7.
In the formula =SUM(A10:A15), which part is the cell reference?
• A.

=

• B.

(A10:A15)

• C.

SUM

• 8.
What is an absolute cell reference?
• A.

The cell reference automatically changes when the formula is copied down a column or across a row.

• B.

The cell uses the A1 reference style.

• C.

The cell reference is fixed or locked.

• 9.
What cell reference refers to a range of cells in column D, rows 4 through 9?
• A.

(D4:D9)

• B.

(D4,D9)

• C.

(D4+D9)

• 10.
If you copy the formula =C4*\$D\$9 from C4 to C5, what will the formula be in cell C5?
• A.

=C5*\$D\$9

• B.

=C4*\$D\$9

• C.

=C5*D9

• 11.
If you enter a formula and #### shows in the cell, what does that mean?
• A.

The formula is missing the math operator.

• B.

The column width is not wide enough to display the results.

• C.

You entered an invalid cell reference.

• 12.
If you entered in the formula =SUME(C3:C7) and you noticed you spelled "SUM" wrong, you have to delete the formula and start again.
• A.

True

• B.

False

• 13.
The symbol for multiplication is a(n)...
• A.

\$

• B.

\

• C.

*

• 14.
The symbol for division is...
• A.

\$

• B.

\

• C.

*

• 15.
When entering data across a row, you should use the TAB key to move the cursor to the next cell.
• A.

True

• B.

False

• 16.
The only way to view a formula you entered in a cell is to look at the formula bar.
• A.

True

• B.

False

• 17.
To easily add a header or footer to your worksheet you should be in page layout view.
• A.

True

• B.

False

• 18.
In the cell reference \$F9, the column is fixed, but the row will change when copied.
• A.

True

• B.

False

• 19.
The shortcut to show formulas in your worksheet is...
• A.

Ctrl + ~

• B.

Ctrl + F5

• C.

Ctrl + \$

• 20.
When you open up a new workbook it comes with how many ready to use worksheets?
• A.

1

• B.

3

• C.

5

Related Topics Back to top