Home

How do you rearrange the data in ascending or descending order?

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

You can do it
  1. It is acceptable to let long text flow into adjacent cells on a worksheet when
  2. What is represented by the small, black square in the lower-right corner of an active cell or range?
  3. You can use the format painter multiple times before you turn it off by
  4. How many characters can be typed in a single cell in Excel?
  5. Each excel file is called a workbook because
  6. What are the tabs that appear at the bottom of each workbook called?
  7. You can select a single range of cells by
  8. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet…
  9. Which tool you will use to join some cells and place the content at the middle of joined cell?
  10. To remove the content of selected cells you must issue ______ command
  11. Comments can be added to cells using ......
  12. To copy cell contents using drag and drop press the
  13. Which of the cell pointer indicates you that you can make selection?
  14. What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
  15. What is the correct way to refer the cell A10 on sheet3 from sheet1?
  16. Which Chart can be created in Excel?
  17. Which of the following formulas is not entered correctly?
  18. Which menu option can be used to split windows into two?
  19. How can you show or hide the gridlines in Excel Worksheet?
  20. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  21. Which of the following options is not located in the Page Setup dialog box?
  22. What does COUNTA () function do?
  23. In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
  24. It is acceptable to let long text flow into adjacent cells on a worksheet when
  25. A worksheet can have a maximum of . Number of rows
  26. You can auto fit the width of column by
  27. Concatenation of text can be done using
  28. Which button do you click to add up a series of numbers?
  29. Which of the following is not a worksheet design criterion?
  30. The active cell: