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 do you wrap the text in a cell?
  2. When integrating word and excel, word is usually the
  3. When a row of data is to be converted into columns
  4. Which area in an excel window allows entering values and formulas
  5. You can select a single range of cells by
  6. Comments can be added to cells using
  7. Comments put in cells are called .....
  8. Getting data from a cell located in a different sheet is called ......
  9. Which of the following option is not available in Paste Special dialog box?
  10. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha,…
  11. Concatenation of text can be done using
  12. Which of the following is not a valid data type in Excel?
  13. What are the tabs that appear at the bottom of each workbook called?
  14. Multiple calculations can be made in a single formula using
  15. Which Chart can be created in Excel?
  16. Comments put in cells are called
  17. Which area in an Excel window allows entering values and formulas?
  18. Which menu option can be used to split windows into two?
  19. Which of the following you can paste selectively using Paste Special command?
  20. To activate the previous cell in a pre-selected range, press
  21. How do you display current date and time in MS Excel?
  22. An Excel Workbook is a collection of .......
  23. Which of the following is an absolute cell reference?
  24. We can save and protect the workbook by
  25. If you need to remove only the formatting done in a range (numbers and formula typed there should not…
  26. You can activate a cell by
  27. Which function is not available in the Consolidate dialog box?
  28. Which of the following is not a basic step in creating a worksheet?
  29. The Chart wizard term data categories refers to;
  30. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?