What is the correct answer?


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

Correct Answer :

B. Apply Conditional Formatting command on Format menu

Related Questions

Multiple calculations can be made in a single formula using ....... The Cancel and Enter buttons appear in the: In Excel, the Fill Color button on the Formatting toolbar is used for… Which function is not available in the Consolidate dialog box? We can save and protect the workbook by Which tool you will use to join some cells and place the content at the… Which setting you must modify to print a worksheet using letterhead? Which of the following is not a valid data type in Excel? To hold row and column titles in place so that they do not scroll when… Which of the following is a correct order of precedence in formula calculation? How can you show or hide the gridlines in Excel Worksheet? You can auto fit the width of column by Where can you change automatic or manual calculation mode in Excel? Excel worksheet cells work very similarly to what common element of the… Comments put in cells are called ..... What do you call the chart that shows the proportions of how one or more… You can select a single range of cells by Multiple calculations can be made in a single formula using Which of the following Excel screen components can NOT be turned on or… You want to set such that when you type Baishakh and drag the fill handle,… Each excel file is a workbook that contains different sheets. Which of… When you copy a formula What are the tabs that appear at the bottom of each workbook called? When a row of data is to be converted into columns An excel workbook is a collection of Which of the following formulas will Excel Not be able to calculate? The numbers in our worksheet look like this: You want them to look like… You can use the formula pallette to Concatenation of text can be done using How can you update the values of formula cells if Auto Calculate mode…