Microsoft Exam 77-882 Topic 10 Question 1 Discussion

According to the question, the cell color should automatically change to orange when sales figure is more than $10,000. In order to accomplish the task, you should use the conditional formatting feature of Excel.

In Excel, conditional formats are format settings that are applied by Excel only when contents of a cell meet the specified criteria. The conditional formatting feature of Excel provides the facility to implement conditional formats. It allows users to automatically apply formatting on cells depending on the values of cells or the values of formulas in the cells.

Your worksheet will be formatted automatically as shown in the image below:

Answer, C is incorrect. The AutoFormat feature is applied on a range of cells to change the formatting of the cells according to the pre-designed format.

Answer, D is incorrect. A style is a group of predefined formatting features, for e.g. font, font size, font color, alignment, etc. The group of formatting features, which creates a style, is stored by using a particular name. By creating a style, different formats can be applied in a single step. It is useful to maintain consistent formatting in a workbook. However, it does not support formatting based on conditions.

Answer, A is incorrect. The AutoCorrect feature is used to correct misspelled words automatically as they are typed.