Operating System

Sunday, April 5, 2015

Excel 2010 Test Questions - 5

Leave a Comment
21. In Excel 2010, what is the name of the command that relocates a cell’s data and its format, then clears the data from the original cell and resets the original cell's format to default?

A.    Repeat
B.     Move
C.     Cut
D.    Copy

Answer: B

22. What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?

A.    Fill handle
B.     Filler
C.     Copy handle
D.    Copy box

Answer: A

23. When copying values in Excel 2010, which feature automatically adjusts cell references for the new copy location?

A.    Absolute reference
B.     Certain reference
C.     Variable reference
D.    Relative reference

Answer: D

24. Which command on the Home Tab displays the total of the selected cells directly after the selected cells?

A.    Sum
B.     Add
C.     Total
D.    Calculate

Answer: A

25. What is the name of the on-screen command that appears in a worksheet when you copy one range to another range?

A.    Copy options
B.     Auto fill options
C.     Reference options
D.    Cell options


Answer: B
If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment