Google News
logo
Microsoft Excel - Quiz(MCQ)
When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A)
Apply Conditional Formatting command on Format menu
B)
Use =if() function to format the required numbers red
C)
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D)
All of the above

Correct Answer : Option (A) :   Apply Conditional Formatting command on Format menu


Explanation : A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.

Advertisement