Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Ch. 3 Excel Test
Test Description: Review games for Ch. 3 Excel MOS question test in Moodle.
Instructions: Answer all questions to get your test result.
1) A cell reference of $A$2 is a ____ cell reference.
A
absolute
B
relative
C
invalid
D
mixed
2) A cell reference of A20 is a ____ cell reference.
A
mixed
B
relative
C
absolute
D
invalid
3) Which of the following is NOT a valid format symbol?
A
dollar sign
B
semi-colon
C
comma
D
percent sign
4) If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.
A
decrement, increment
B
increment, decrement
C
copy, cut
D
cut, copy
5) 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
Deductions
B
F5
C
#REF!
D
No deductions
6) When assigned to a cell, the ___ function returns a number that corresponds to the system date and time beginning with December 31, 1899.
A
DATETIME
B
NOW
C
CURRENT
D
SYSDATE
7) The ___ function is useful when you want to assign a value to a cell based on a logical test.
A
OR
B
AND
C
IF
D
NOW
8) The fill handle can be used to do which of the following?
A
copy a range of cells
B
create a series of numbers or dates
C
all of these
D
copy a cell
9) Excel converts all the formulas from ____.
A
uppercase to lowercase
B
absolute to relative
C
relative to absolute
D
lowercase to uppercase
10) In addition to creating a series of values, dragging the fill handle instructs Excel to ___ the format of a cell to a range.
A
cut
B
copy
C
delete
D
move
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?