[Solved] When all the numbers between 0 and 100 in a range should be displayed in Red Colour, apply

McqMate

Q.	When all the numbers between 0 and 100 in a range should be displayed in Red Colour, 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 colour on text colour tool
D.	all of above
Answer» B. apply conditional formatting command on format menu

3k

0

Do you find this helpful?

32

View all MCQs in

Office Automation Tools

Discussion

No comments yet

Related MCQs

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
Where can you set the shedding colour for a range of cells in Excel?
What feature will you use to apply motion effects in between a slide exits and another enters?
Text boundary can be displayed or hidden from
A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.
What do you call software that prevents certain Web pages from being displayed?
A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly.
How can you apply exactly the same formatting you did to another text?
Which tab in Font dialog box contains options to apply font effects?
Special category of Number tab in Format Cells dialog box can be used to apply formats like