# Ch. 3 Excel Test: Question Preview (ID: 14845)

### Below is a preview of the questions contained within the game titled CH. 3 EXCEL TEST: Review Games For Ch. 3 Excel MOS Question Test In Moodle. To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

A cell reference of \$A\$2 is a ____ cell reference.
a) absolute
b) invalid
c) relative
d) mixed

A cell reference of A20 is a ____ cell reference.
a) relative
b) absolute
c) invalid
d) mixed

Which of the following is NOT a valid format symbol?
a) semi-colon
b) dollar sign
c) comma
d) percent sign

If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.
a) decrement, increment
b) cut, copy
c) increment, decrement
d) copy, cut

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, ___.
a) No deductions
b) #REF!
c) F5
d) Deductions

When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
a) NOW
b) CURRENT
c) DATETIME
d) SYSDATE

The ___ function is useful when you want to assign a value to a cell based on a logical test.
a) IF
b) OR
c) AND
d) NOW

The fill handle can be used to do which of the following?
a) all of these
b) create a series of numbers or dates
c) copy a cell
d) copy a range of cells

Excel converts all the formulas from ____.
a) lowercase to uppercase
b) uppercase to lowercase
c) absolute to relative
d) relative to absolute

In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.
a) copy
b) cut
c) move
d) delete

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from the data set above, visit ReviewGameZone.com and enter game ID number: 14845 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS