Fill in the blanks with the correct words:
- To select a complete row, click the row heading.
- To select the entire worksheet, click the Select All button.
- The keyboard shortcut for Cut option is Ctrl + X.
- Press the Ctrl key to select multiple ranges.
- The Flash Fill feature of Excel 2013 recognizes the data fill pattern in a worksheet and fills the remaining series accordingly.
True or False:
- You cannot select a range of cells using a mouse. FALSE
(We can select a range using mouse as well as keyboard) - 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) - The keyboard shortcut for the Paste option is Ctrl + V. TRUE
- Cells can be inserted in a worksheet. TRUE
- 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:
- What is the keyboard shortcut to select an entire column?
Ctrl + Space bar. - Which key will you press to select multiple range of cells?
Ctrl key. - How can you select a complete column using a mouse?
By clicking on the corresponding column heading. - 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. - What is the keyboard shortcut for Redo command?
Ctrl + Y.