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

You can do it
  1. Which setting you must modify to print a worksheet using letterhead?
  2. Which of the following is a correct order of precedence in formula calculation?
  3. If you begin typing an entry into a cell and then realize that you dont want your entry placed into…
  4. Which menu option can be sued to split windows into two
  5. Excel uniquely identifies cells within a worksheet with a cell name
  6. You can copy data or formulas
  7. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
  8. How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?
  9. To delete an embedded objects, first
  10. To remove the content of selected cells you must issue ______ command
  11. To record a sequence of keystrokes and mouse actions to play back later we use:
  12. In the formula, which symbol specifies the fixed columns or rows?
  13. Which of the following is not a valid data type in Excel?
  14. You can use the formula pallette to
  15. How many characters can be typed in a single cell in Excel?
  16. You can move a sheet from one workbook into new book by
  17. Which of the following is not true regarding Conditional Formatting?
  18. The spelling dialog box can be involved by choosing spelling from ________ menu.
  19. Which of the following methods can not be used to edit the contents of a cell?
  20. The command Edit >> Fill Across Worksheet is active only when
  21. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
  22. What is the short cut key to replace a data with another in sheet?
  23. Which of the following is an absolute cell reference?
  24. It is acceptable to let long text flow into adjacent cells on a worksheet when
  25. Which of the following Excel screen components can NOT be turned on or off?
  26. You want to track the progress of the stock market on a daily basis. Which type of chart should you…
  27. Which function is not available in the Consolidate dialog box?
  28. Comments can be added to cells using
  29. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
  30. What do you mean by a Workspace?