Home>> MS Excel MCQs >> When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
A. Use =if() function to format the required numbers red
B. Apply Conditional Formatting command on Format menu

C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
D. All of above

ANSWER: B) 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.

MS Excel MCQs

Read More MS Excel MCQs

MS Office MCQs, Computer Fundamental MCQs, Computer MCQs , MS Office, MS Excel, MCQ on Internet

MS Excel MCQs

Microsoft Excel is a spreadsheet program that allows you to create and edit accounts and ledgers. It is a part of the Microsoft Office suite. MS Excel MCQs are a great way to test your knowledge of this program. There are many websites that offer free MS Excel MCQs, and they can be a great resource for studying for exams or simply brush up on your skills.

MS Excel MCQs PDF

We will share MCQs of MS Excel on mcqzpro.com. MCQs on MS Excel pdf will help you find best knowledge about MS Office.

More MCQs