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
OR
B
NOW
C
GOAL
D
If
2) This Auto Fill Option fills the destination area using the format of the source area only.
A
Fill Formatting Only
B
Copy Cells
C
Fill Without Formatting
D
Select Cells
3) Determines the value of a cell on which the formula depends.
A
NOW Function
B
Goal seeking
C
If Function
D
What-If analysis
4) Fill in the series, Qtr3, Qtr4,Qtr1, _______
A
Qtr1
B
Qtr2
C
Quarter2
D
Qtr4
5) This evaluates the impact of changing values in cells that are reverence by a formula in another cell.
A
If Function
B
Goal Seeking
C
NOW Function
D
What-If analysis
6) 650,645,640,_____,_______
A
620,610
B
655,660
C
635,630
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
Thursday, Saturday, Monday
B
Wednesday, Thursday, Saturday
C
Monday, Wednesday, Friday
D
Saturday, Sunday, Monday
9) This fill option copies the format and contents.
A
Fill series
B
Fill Formatting
C
Keep source formatting
D
Copy
10) If you drag the fill handle up or to the left, what will Excel do?
A
Skip the series
B
Repeat the series
C
Decrement the series (go backwards)
D
Increment the series (go forward )
11) To copy cell contents Excel might think is a series, hold this key down
A
Shift
B
CAPS
C
ALT
D
CTRL
12) Jan, Mar, May _______, _________, _________
A
June, July, August
B
Jun, Jul, Aug
C
July, September, November
D
Jul, Sept, Nov
13) ______, Wednesday, Friday, Monday,_________
A
Tuesday, Tuesday
B
Monday, Wednesday
C
Mon, Wed
D
Tues
*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?