DATABASE FUNDAMENTALS
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.
There is 1 question to complete.