USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What can you apply to a range of cells to show a condition (such as cells with a value greater than 50) has been met?
|
|
Fill Color
|
|
|
Conditional Formatting
|
|
|
Sparkline Chart
|
|
|
Formulas
|
Explanation:
Detailed explanation-1: -Apply conditional formatting so cells with a value greater than the average are formatted using a yellow fill with dark yellow text. On the Home tab, in the Styles group, click the Conditional Formatting button. Point to Top/Bottom Rules, and click Above Average.
Detailed explanation-2: -On the Excel Ribbon’s Home tab, click Conditional Formatting, to format the values greater than a specific one, select Highlight Cells Rules and then choose the option Greater Than.
There is 1 question to complete.