Excel 2010 Test Questions - 22

111. What feature of Excel 2010 keeps a portion of a worksheet visible while the other portion scrolls?

A.    Zoom

B.     Select

C.     Freeze Panes

D.    Rotate

Answer: C

112. What command do you use to increase or decrease the size of a selected cell or range of cells to fill the Excel Window area for better visibility?

A.    Magnify Area

B.     Enlarge Selected Area

C.     Amplify Range

D.    Zoom to Selection

Answer: D

113. What command will tile Excel 2010 windows and all other open program windows so that they appear side by side on the screen?

A.    Zoom to Selection

B.     New Window

C.     Arrange All

D.    Freeze Panes

Answer: C

114. Which command creates a new view of the current document in a separate window?

A.    Zoom to Selection

B.     New Window

C.     Arrange All

D.    Freeze Panes

Answer: B

115. Which command separates a worksheet window into four individual panes?

A.    Arrange All

B.     Freeze Panes

C.     New Window

D.    Split

Answer: D

If You Enjoyed This, Take 5 Seconds To Share It

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