Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Functions And Fill Handle
Test Description: Part of Excel Chapterv3vreview
Instructions: Answer all questions to get your test result.
1) This function returns a number that corresponds to the system date an time.
A
GOAL
B
NOW
C
OR
D
If
2) This Auto Fill Option fills the destination area using the format of the source area only.
A
Fill Without Formatting
B
Fill Formatting Only
C
Copy Cells
D
Select Cells
3) Determines the value of a cell on which the formula depends.
A
What-If analysis
B
Goal seeking
C
If Function
D
NOW Function
4) Fill in the series, Qtr3, Qtr4,Qtr1, _______
A
Qtr1
B
Qtr4
C
Qtr2
D
Quarter2
5) This evaluates the impact of changing values in cells that are reverence by a formula in another cell.
A
Goal Seeking
B
NOW Function
C
What-If analysis
D
If Function
6) 650,645,640,_____,_______
A
635,630
B
655,660
C
620,610
D
645,650
7) This function assigns a value to a cell based on a logical test.
A
If
B
Goal Seeking
C
What-If
D
Now
8) Sunday, Tuesday, _______,_________,__________
A
Monday, Wednesday, Friday
B
Saturday, Sunday, Monday
C
Wednesday, Thursday, Saturday
D
Thursday, Saturday, Monday
9) This fill option copies the format and contents.
A
Copy
B
Keep source formatting
C
Fill Formatting
D
Fill series
10) If you drag the fill handle up or to the left, what will Excel do?
A
Repeat the series
B
Increment the series (go forward )
C
Skip the series
D
Decrement the series (go backwards)
11) To copy cell contents Excel might think is a series, hold this key down
A
Shift
B
CTRL
C
ALT
D
CAPS
12) Jan, Mar, May _______, _________, _________
A
Jul, Sept, Nov
B
June, July, August
C
Jun, Jul, Aug
D
July, September, November
13) ______, Wednesday, Friday, Monday,_________
A
Mon, Wed
B
Tues
C
Tuesday, Tuesday
D
Monday, Wednesday
*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?