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

You can do it yup
  1. When the formula bar is active, you can see
  2. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  3. Which of the following is not a valid data type in excel
  4. Which of the following is not the correct method of editing the cell content?
  5. The Delete key of keyboard is assigned to which command in Excel?
  6. A typical worksheet has …. Number of columns
  7. Comments put in cells are called
  8. Which of the following methods can not be used to edit the contents of a cell?
  9. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click…
  10. Which of the following is the latest version of Excel
  11. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  12. Which of the following is invalid statement?
  13. A __________ is a grid with labeled columns and rows.
  14. It is acceptable to let long text flow into adjacent cells on a worksheet when
  15. Getting data from a cell located in a different sheet is called ......
  16. Which would you choose to create a bar diagram?
  17. Tab scrolling button
  18. Concatenation of text can be done using
  19. Which of the following Excel screen components can NOT be turned on or off?
  20. Which is not the function of Edit, Clear command?
  21. To remove the content of selected cells you must issue ______ command
  22. Which of the following is not a term of MS-Excel?
  23. When you insert an excel file into a word document. The data are
  24. Which is used to perform what if analysis?
  25. Which of the following is not an example of a value?
  26. Long text can be broken down into many lines within a cell. You can do this through
  27. The auto calculate feature
  28. Which of the following is not true about Find and Replace in Excel
  29. Which command will you choose to convert a column of data into row?
  30. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?