Home

Where can you set the shading color for a range of cells in Excel?

A. Choose required color form Patterns tab of Format Cells dialog box

B. Choose required color on Fill Color tool in Formatting toolbar

C. Choose required color on Fill Color tool in Drawing toolbar

D. All of above

You can do it
  1. How many characters can be typed in a single cell in Excel?
  2. Which of the following is not a valid data type in Excel?
  3. How do you display current date and time in MS Excel?
  4. To create a formula, you first:
  5. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
  6. How many worksheets can a workbook have?
  7. Which tool you will use to join some cells and place the content at the middle of joined cell?
  8. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  9. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  10. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  11. Ctrl + D shortcut key in Excel will
  12. Which of the following is not true regarding Conditional Formatting?
  13. Long text can be broken down into many lines within a cell. You can do this through
  14. Which elements of worksheet can be protected from accidental modification
  15. How can you delete a record?
  16. What do you mean by a Workspace?
  17. Which of the cell pointer indicates that you can fill series?
  18. Which of the following is an absolute cell reference?
  19. You can use the format painter multiple times before you turn it off by
  20. The Cancel and Enter buttons appear in the:
  21. We can save and protect the workbook by
  22. Which of following is Not one of Excels what-if function?
  23. Which of the following is not a basic step in creating a worksheet?
  24. How do you select an entire column?
  25. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  26. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  27. A worksheet can have a maximum of . Number of rows
  28. How do you wrap the text in a cell?
  29. While Finding and Replacing some data in Excel, which of the following statement is valid?
  30. It is acceptable to let long text flow into adjacent cells on a worksheet when