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
  1. MS-EXCEL is based on .........?
  2. How do you display current date only in MS Excel?
  3. To center worksheet titles across a range of cells, you must
  4. Which of the following is a popular DOS based spreadsheet package?
  5. You can select a single range of cells by
  6. You can use drag-and-drop to embed excel worksheet data in a word document
  7. How can you remove borders applied in cells?ACC
  8. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
  9. Which elements of a worksheet can be protected from accidental modification?
  10. How do you delete a column?
  11. We can save and protect the workbook by
  12. You can check the conditions against __________ when applying conditional formatting
  13. When you insert an excel file into a word document. The data are
  14. What does COUNTA () function do?
  15. A __________ is a grid with labeled columns and rows.
  16. A numeric value can be treated as label value if ...... precedes it.
  17. Which of the following Excel screen components can NOT be turned on or off?
  18. The Cancel and Enter buttons appear in the:
  19. You can use the formula palette to
  20. A worksheet can have a maximum of . Number of rows
  21. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  22. When a row of data is to be converted into columns
  23. When integrating word and excel, word is usually the
  24. Text formulas:
  25. To record a sequence of keystrokes and mouse actions to play back later we use:
  26. What is the short cut key to replace a data with another in sheet?
  27. An Excel Workbook is a collection of .......
  28. Which of the cell pointer indicates that you can fill series?
  29. You can set Page Border in Excel from
  30. Which button do you click to add up a series of numbers?