Functions And Fill Handle: Question Preview (ID: 27867)

Below is a preview of the questions contained within the game titled FUNCTIONS AND FILL HANDLE: Part Of Excel Chapterv3vreview .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.

If you drag the fill handle up or to the left, what will Excel do?
a) Decrement the series (go backwards) b) Increment the series (go forward ) c) Skip the series d) Repeat the series
This fill option copies the format and contents.
a) Fill series b) Copy c) Fill Formatting d) Keep source formatting
Sunday, Tuesday, _______,_________,__________
a) Thursday, Saturday, Monday b) Wednesday, Thursday, Saturday c) Saturday, Sunday, Monday d) Monday, Wednesday, Friday
a) 635,630 b) 645,650 c) 620,610 d) 655,660
This function assigns a value to a cell based on a logical test.
a) If b) Now c) Goal Seeking d) What-If
This evaluates the impact of changing values in cells that are reverence by a formula in another cell.
a) What-If analysis b) NOW Function c) If Function d) Goal Seeking
Fill in the series, Qtr3, Qtr4,Qtr1, _______
a) Qtr2 b) Quarter2 c) Qtr1 d) Qtr4
Determines the value of a cell on which the formula depends.
a) Goal seeking b) NOW Function c) If Function d) What-If analysis
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
This function returns a number that corresponds to the system date an time.
a) NOW b) If c) GOAL d) OR
To copy cell contents Excel might think is a series, hold this key down
a) CTRL b) Shift c) ALT d) CAPS
Jan, Mar, May _______, _________, _________
a) Jul, Sept, Nov b) June, July, August c) Jun, Jul, Aug d) July, September, November
______, Wednesday, Friday, Monday,_________
a) Monday, Wednesday b) Tuesday, Tuesday c) Mon, Wed d) Tues
Play Games with the Questions above at
To play games using the questions from the data set above, visit and enter game ID number: 27867 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register