Home

You can select a single range of cells by

A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B. Pressing the Ctrl key while dragging over the desired cells

C. Pressing the Shift key and an arrow key

D. Dragging over the desired cells

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

You can do it
  1. What does COUNTA () function do?
  2. To activate the previous cell in a pre-selected range, press
  3. Which of the following is not true about Find and Replace in Excel
  4. Which of the following format you can decide to apply or not in AutoFormat dialog box?
  5. To copy formatting from one area in a worksheet and apply it to another area you would use:
  6. A worksheet can have a maximum of …. Number of rows
  7. Excel uniquely identifies cells within a worksheet with a cell name
  8. To center worksheet titles across a range of cells, you must
  9. What is the short cut key to highlight the entire column?
  10. Which of the cell pointer indicates that you can fill series?
  11. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  12. Comments can be added to cells using
  13. Which button do you click to add up a series of numbers?
  14. While Finding and Replacing some data in Excel, which of the following statement is valid?
  15. What symbol is used before a number to make it a label?
  16. To remove the content of selected cells you must issue ______ command
  17. The spelling dialog box can be involved by choosing spelling from ________ menu.
  18. In Excel, the Fill Color button on the Formatting toolbar is used for what?
  19. The active cell:
  20. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish…
  21. When you copy a formula
  22. Which of the following is not a basic step in creating a worksheet?
  23. When you want to insert a blank imbedded excel object in a word document you can
  24. In the formula, which symbol specifies the fixed columns or rows?
  25. You can set Page Border in Excel from
  26. How do you rearrange the data in ascending or descending order?
  27. You can auto fit the width of column by
  28. An excel workbook is a collection of
  29. Which of the following series type is not valid for Fill Series dialog box?
  30. Which of the following formulas is not entered correctly?