Functions And Fill Handle Question Preview (ID: 27867)


Part Of Excel Chapterv3vreview. TEACHERS: click here for quick copy question ID numbers.

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

650,645,640,_____,_______
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 ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 27867 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register