Excel 2010 Test Questions - 16

76. What tool do you use to check which cells are referenced in formulas that are assigned to the active cell?

A.    Reference Finder

B.     Range Finder

C.     Reference Checker

D.    Address Finder

Answer: B

77. Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?

A.    Layout

B.     Template

C.     Theme

D.    Design

Answer: C

78. Which ribbon contains the command to apply a theme to a worksheet in Excel 2010?

A.    Home

B.     Page Layout

C.     Data

D.    View

Answer: B

79. Where can you find the command to apply a background color to a cell or range of cells in a worksheet?

A.    Home Ribbon

B.     Insert Ribbon

C.     Page Layout Ribbon

D.    View Ribbon

Answer: A

80. Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?

A.    Number

B.     Font

C.     Paragraph

D.    Format Cells

Answer: D

If You Enjoyed This, Take 5 Seconds To Share It

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