Home

Which tool you will use to join some cells and place the content at the middle of joined cell?

A. From Format Cells dialog box click on Merge Cells check box

B. From Format Cells dialog box select the Centered alignment

C. From Format Cells dialog box choose Merge and Center check box

D. Click on Merge and Center tool on formatting toolbar

You can do it
  1. Which function is not available in the Consolidate dialog box?
  2. How do you display current date and time in MS Excel?
  3. The spelling dialog box can be involved by choosing spelling from ________ menu.
  4. Right clicking something in Excel:
  5. How many worksheets can a workbook have?
  6. The active cell:
  7. Which of the following is the oldest spreadsheet package?
  8. You can check the conditions against __________ when applying conditional formatting
  9. What is the short cut key to highlight the entire column?
  10. You can use the drag and drop method to
  11. When you insert an excel file into a word document. The data are
  12. You can use the format painter multiple times before you turn it off by
  13. Which setting you must modify to print a worksheet using letterhead?
  14. Which elements of worksheet can be protected from accidental modification
  15. Long text can be broken down into many lines within a cell. You can do this through
  16. When a range is selected, how can you activate the previous cell?
  17. A worksheet can have a maximum of . Number of rows
  18. Comments put in cells are called .....
  19. It is acceptable to let long text flow into adjacent cells on a worksheet when
  20. Excel displays the current cell address in the ........
  21. Which of the following is not a worksheet design criterion?
  22. Excel probably considers the cell entry January 1, 2000 to be a
  23. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
  24. What do you mean by a Workspace?
  25. Which of the following is not the correct method of editing the cell content?
  26. Paste Special allows some operation while you paste to new cell. Which of the following operation is…
  27. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  28. Which of the following is not an example of a value?
  29. What does COUNTA () function do?
  30. If you need to remove only the formatting done in a range (numbers and formula typed there should not…