Home

Which of the following is not true regarding Conditional Formatting?

A. You can add more than one condition to check

B. You can set condition to look for Bold and apply Italics on them

C. You can apply Font, border and pattern formats that meets the specified conditions

D. You can delete any condition from Conditional Formatting dialog box if it is not requried

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

You can do it
  1. While Finding and Replacing some data in Excel, which of the following statement is valid?
  2. Which of the cell pointer indicates you that you can make selection?
  3. When integrating word and excel, word is usually the
  4. To return the remainder after a number is divided by a divisor in EXCEL we use the function?
  5. To edit in an embedded excel worksheet object in a word document
  6. Comments can be added to cells using
  7. Getting data from a cell located in a different sheet is called ......
  8. Which elements of worksheet can be protected from accidental modification
  9. Microsoft Excel is a powerful ...........
  10. The active cell:
  11. Which symbol must all formula begin with?
  12. When a row of data is to be converted into columns
  13. Which elements of a worksheet can be protected from accidental modification?
  14. Data can be arranged in a worksheet in a easy to understand manner using
  15. You can edit a cell by
  16. Status indicators are located on the
  17. When a range is selected, how can you activate the previous cell?
  18. You can use the formula pallette to
  19. To center worksheet titles across a range of cells, you must
  20. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  21. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  22. Which Chart can be created in Excel?
  23. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  24. B7:B9 indicates:
  25. Right clicking something in Excel:
  26. Which tool you will use to join some cells and place the content at the middle of joined cell?
  27. Which of the following is not a valid data type in Excel?
  28. What is represented by the small, black square in the lower-right corner of an active cell or range?
  29. How do you display current date and time in MS Excel?
  30. To copy formatting from one area in a worksheet and apply it to another area you would use: