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

You can do it
  1. Long text can be broken down into many lines within a cell. You can do this through
  2. How can you show or hide the gridlines in Excel Worksheet?
  3. Which of the cell pointer indicates that you can fill series?
  4. The command Edit >> Fill Across Worksheet is active only when
  5. Which button do you click to add up a series of numbers?
  6. Which area in an excel window allows entering values and formulas
  7. Comments put in cells are called
  8. When a row of data is to be converted into columns
  9. What is the short cut key to replace a data with another in sheet?
  10. When you copy a formula
  11. Which of the following is not true regarding Conditional Formatting?
  12. You can convert existing excel worksheet data an charts to an HTML document by using
  13. A circular reference is
  14. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  15. You can use the formula palette to
  16. Multiple calculations can be made in a single formula using .......
  17. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
  18. To copy cell contents using drag and drop press the
  19. Which of the following is not the correct method of editing the cell content?
  20. Which of the following is not an example of a value?
  21. When a label is too long to fit within a worksheet cell, you typically must
  22. To center worksheet titles across a range of cells, you must
  23. Right clicking something in Excel:
  24. A numeric value can be treated as a label value if it precedes with
  25. An excel workbook is a collection of
  26. You can use the format painter multiple times before you turn it off by
  27. Which of the following formulas will Excel Not be able to calculate?
  28. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  29. When you link data maintained in an excel workbook to a word document
  30. What symbol is used before a number to make it a label?