Excel 2010 Test Questions 28

141. What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?

A.    Margins

B.     Print titles

C.     Header & Footer

D.    Page Setup

Answer: C

142. What is the name of the dialog box that contains the commands to center a worksheet on the page both vertically and horizontally?

A.    Page Setup

B.     Format Cells

C.     Print Setup

D.    Format Styles

Answer: A

143. How would a user hide a row or column from view without permanently deleting the information?

A.    Choose the Disappear command on the Shortcut menu

B.     Choose the Hide command on the Quick Access Toolbar

C.     Choose the Show/Hide command on the Home Ribbon

D.    Choose the Hide command on the Shortcut menu

Answer:  D

144. How is an exact copy of a worksheet created within the same workbook?

A.    While pointing to the sheet tab, choose Copy from the Shortcut Menu

B.     Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu

C.     While pointing to the Select All button, choose Move or Copy from the Shortcut Menu

D.    Choose Move or Copy from the Quick Access Toolbar

Answer: B

145. Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

A.    Find & Select

B.     Format Cell

C.     Sort & Filter

D.    Organize

Answer: C

If You Enjoyed This, Take 5 Seconds To Share It

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