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

Compounds with Functional Groups Containing MCQ Analogy MCQ Concrete Technology and Design MCQ Computer Fundamental MCQ Ecology MCQ Solution MCQ Reproductive System MCQ Payroll MCQ Profit and Loss MCQ Machine Input Mi-set 2 MCQ Problems on Ages MCQ ionic Equilibrium MCQ

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

Submit
Load More..
You can do it
  1. How many worksheets can a workbook have?
  2. Where can you set the shading color for a range of cells in Excel?
  3. What will be the output if you format the cell containing 5436.8 as #,##0.00'?
  4. Which of the following is the latest version of Excel
  5. Data can be arranged in a worksheet in a easy to understand manner using
  6. A numeric value can be treated as label value if ...... precedes it.
  7. To copy cell contents using drag and drop press the
  8. Which of the following is an absolute cell reference?
  9. Which of the following methods cannot be used to enter data in a cell
  10. You can check the conditions against __________ when applying conditional formatting
  11. Which symbol must all formula begin with?
  12. Which of the following formulas will Excel Not be able to calculate?
  13. To create a formula, you can use:
  14. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  15. When integrating word and excel, word is usually the
  16. Which of the cell pointer indicate that you can move the content to other cell?
  17. Which of the following is not a term of MS-Excel?
  18. Excel displays the current cell address in the ........
  19. Which of the following is the oldest spreadsheet package?
  20. When you link data maintained in an excel workbook to a word document
  21. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  22. How can you find specific information in a list?
  23. Which of the following Excel screen components can NOT be turned on or off?
  24. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  25. Which of the following is not information you can specify using the solver?
  26. We can save and protect the workbook by
  27. Which of the following is a correct order of precedence in formula calculation?
  28. Which of the following is not a valid data type in Excel?
  29. Right clicking something in Excel:
  30. To record a sequence of keystrokes and mouse actions to play back later we use: