Excel 2010 Test Questions - 19

91. What is the quick keyboard command for converting a worksheet to formulas version so that all worksheet formulas may be see on screen or printed?

A.    Ctrl + ‘ (accent mark)

B.     Ctrl + “ (quotation)

C.     Alt + ‘ (accent mark)

D.    Shift + “ (quotation)

Answer: A

92. Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?

A.    Font

B.     Orientation

C.     Wrap Text

D.    Merge & Center

Answer: B

93. What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?

A.    Styles

B.     Alignment

C.     Editing

D.    Font

Answer: A

94. Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?

A.    Format as Table

B.     Cell Style

C.     Format Cells

D.    Form

Answer: B

95. Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

A.    Cell Styles

B.     Form

C.     Sort & Filter

D.    Format

Answer: D

If You Enjoyed This, Take 5 Seconds To Share It

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