Ch. 3 Excel Test

Match it! Select the correct answer from the pull down...Good luck!

If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.

A cell reference of $A$2 is a ____ cell reference.

If you assign the value 42 to cell E5, the value 11 to cell F5, and cell G5 contains the function =IF(E5>4*F5,"Deductions","No deductions"), then cell G5 displays the message, ___.

When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.

A cell reference of A20 is a ____ cell reference.

Which of the following is NOT a valid format symbol?

The fill handle can be used to do which of the following?