Editing a Worksheet

Fill in the blanks with the correct words:

1. To select a complete row, click the row heading.
2. To select the entire worksheet, click the Select All button.
3. The keyboard shortcut for Cut option is Ctrl + X.
4. Press the Ctrl key to select multiple ranges.
5. The Flash Fill feature of Excel 2013 recognizes the data fill pattern in a worksheet and fills the remaining series accordingly.

True or False:

1. You cannot select a range of cells using a mouse. FALSE
   (We can select a range using mouse as well as keyboard)
2. You can copy data from one location to another using only Copy and Paste option of the HOME tab. FALSE
   (We can also right-click and select Copy option)
3. The keyboard shortcut for the Paste option is Ctrl + V. TRUE
4. Cells can be inserted in a worksheet. TRUE
5. You can set the row height manually. TRUE

Choose the correct option:

• To activate the extended mode, press:
  a) F6
  b) F7
  c) F8
  d) None of these
• The Go To command is available on ________ tab.
  a) HOME
  b) INSERT
  c) REVIEW
  d) None of these
• The keyboard shortcut to select an entire worksheet is:
  a) Ctrl + A
  b) Shift + A
  c) Alt + A
  d) None of these
• Which of the following lists are already stored in custom lists?
  a) Weekdays
  b) Month names
  c) Both (a) and (b)
  d) None of these
• Which of the following command groups are available on the HOME tab?
  a) Cells
  b) Editing
  c) Both (a) and (b)
  d) None of these

Answer the following:

1. What is the keyboard shortcut to select an entire column?
   Ctrl + Space bar.
2. Which key will you press to select multiple range of cells?
   Ctrl key.
3. How can you select a complete column using a mouse?
   By clicking on the corresponding column heading.
4. What is the difference between Undo and Redo commands?
   Undo command is used to cancel the last action.
   Redo command is used to cancel the Undo action.
5. What is the keyboard shortcut for Redo command?
   Ctrl + Y.