Excel 2010 Test Questions - 21

106. After you paste an item into a cell in a worksheet, what menu appears?

A.    AutoCorrect Options

B.     Paste Options

C.     Quick Access Menu

D.    Shortcut Menu

Answer: B

107. What is the process of using the mouse to move or copy cells called?

A.    Click and paste

B.     Drag and move

C.     Dragging

D.    Drag and drop

Answer: D

108. What message does Excel display to indicate a cell reference error?

A.    #REF!

B.     ERROR!

C.     #CELL!

D.    #NAME?

Answer: A

109. What type of formula cell reference instructs Excel 2010 to keep the cell reference constant in the formula as it copies it to the destination area?

A.    Relative

B.     Mixed

C.     Absolute

D.    Unconditional

Answer: C

110. Which function do you use along with logical operators such as AND, OR, and NOT to make decisions based upon a condition?

A.    Clean

B.     If

C.     Stipulation

D.    What-If

Answer: B

If You Enjoyed This, Take 5 Seconds To Share It

• Facebook
• Twitter
• Google+
• StumbleUpon
• Digg
• Delicious
• LinkedIn
• Reddit
• Technorati