Alan works as a Sales Manager for MVP Technologies. He is creating a sales report in Microsoft Excel
2010. In the report, he needs to enter the names of sales executives in one column and the sales
target (in dollars) achieved by them in the next column as shown in the image below:
He wants to ensure that the color of a cell changes automatically to orange when the sales figure
entered in the cell is more than $10,000. Which of the following actions will he take to accomplish the task?
A.
Use the AutoCorrect feature.
B.
Use the conditional formatting feature.
C.
Use the AutoFormat feature.
D.
Use a style.
Explanation:
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.
