Home

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.


Download Objective type questions of Microsoft Excel PDF

Visit our PDF store

Get all objective type questions of Microsoft Excel MCQ

Also checkout these categories

Rearrangement Set 13 MCQ Phylum - Porifera MCQ Tumors of the prostate MCQ Chemical Process MCQ Calendar MCQ Classification MCQ Accounts Fundamental MCQ World History MCQ Decision Making MCQ Building Materials MCQ Digital Electronics MCQ Average MCQ

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..
You can do it
  1. When you copy a formula
  2. Which of the following is invalid statement?
  3. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  4. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  5. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  6. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  7. When you insert an excel file into a word document. The data are
  8. You can activate a cell by
  9. Which of the following action removes a sheet from workbook?
  10. To create a formula, you first:
  11. Which of the following option is not available in Paste Special dialog box?
  12. In the formula, which symbol specifies the fixed columns or rows?
  13. Which setting you must modify to print a worksheet using letterhead?
  14. Which of the following is not a way to complete a cell entry?
  15. Edit >> Delete command
  16. Which of the following formulas will Excel Not be able to calculate?
  17. Rounding errors can occur
  18. The Paste Special command lets you copy and paste:
  19. To save a workbook, you:
  20. The Delete key of keyboard is assigned to which command in Excel?
  21. You can use drag-and-drop to embed excel worksheet data in a word document
  22. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
  23. Which of the following methods cannot be used to enter data in a cell
  24. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  25. What is represented by the small, black square in the lower-right corner of an active cell or range?
  26. Which is not the function of Edit, Clear command?
  27. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  28. It is acceptable to let long text flow into adjacent cells on a worksheet when
  29. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  30. To edit in an embedded excel worksheet object in a word document