Question

How many auto-formatting styles are available in MS Excel 2007 to give a spreadsheet a professional look ?

• A. 17
• B. 34
• C. 7
• D. 119

Hint:

Excel 2007 offers 17 auto-formatting styles.

Answer 1

The Correct Option is A

Step 1: Understand the question:
We must give the number of auto-formatting styles in MS Excel 2007. These styles give a worksheet a professional look.

Step 2: Recall the fact:
Excel 2007 has 17 built-in auto-formatting styles. A user can apply one to a selected range to set the fonts, borders and shading in a single step.

Step 3: Match with the options:
Option (A) 17 is the correct count.

Step 4: Why the other options are wrong:
Option (B) 34 is not the number of styles. It is double the correct count.
Option (C) 7 is too small. It does not match the number of styles in the package.
Option (D) 119 has no basis. It is not the number of styles in Excel 2007.

Final Answer:
17 auto-formatting styles. Option (A).