Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam 77-882 Topic 10 Question 1 Discussion

Actual exam question for Microsoft's exam
Question #: 1
Topic #: 10
[All Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: B

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.


Comments

Currently there are no comments in this discussion, be the first to comment!


Save Cancel