Podcast
Questions and Answers
What is the procedure to select a range of cells in a worksheet?
What is the procedure to select a range of cells in a worksheet?
- Drag from the first cell to the last cell, and then press the Shift key
- Click the first cell, hold down the Ctrl key, and then click the last cell
- Click the first cell, hold down the Shift key, and then click the last cell (correct)
- Click the first cell, hold down the Alt key, and then click the last cell
How do you deselect a range of cells?
How do you deselect a range of cells?
- Press any arrow key or click any cell in the worksheet (correct)
- Press the F1 key
- Hold down the Shift key and click the first cell
- Hold down the Ctrl key and click the last cell
What is the shortcut to select nonadjacent cells or ranges?
What is the shortcut to select nonadjacent cells or ranges?
- Hold down the Shift key
- Hold down the Alt key
- Press the F2 key
- Hold down the Ctrl key (correct)
How do you select a single row or column?
How do you select a single row or column?
What is the purpose of pressing the Esc key during editing?
What is the purpose of pressing the Esc key during editing?
What is the procedure to select multiple adjacent rows or columns?
What is the procedure to select multiple adjacent rows or columns?
How can you undo an action in Excel?
How can you undo an action in Excel?
How do you select multiple nonadjacent rows or columns?
How do you select multiple nonadjacent rows or columns?
What is the function of the Clipboard group on the Home tab?
What is the function of the Clipboard group on the Home tab?
How do you move a cell to a new location?
How do you move a cell to a new location?
What is the purpose of the Font group on the Home tab?
What is the purpose of the Font group on the Home tab?
What is the result of pressing the Backspace key while editing?
What is the result of pressing the Backspace key while editing?
How can you change the font size of a cell?
How can you change the font size of a cell?
What is the purpose of the Number group on the Home tab?
What is the purpose of the Number group on the Home tab?
What is the purpose of pressing the Enter key after editing?
What is the purpose of pressing the Enter key after editing?
How do you copy a cell?
How do you copy a cell?
How can you remove all borders from a selected cell?
How can you remove all borders from a selected cell?
What is the shortcut key to redo an action in Excel?
What is the shortcut key to redo an action in Excel?
What is the primary function of the Alignment group in the Home tab of the Ribbon?
What is the primary function of the Alignment group in the Home tab of the Ribbon?
What is the effect of clicking the Centre button in the Alignment group?
What is the effect of clicking the Centre button in the Alignment group?
What is the purpose of indenting data in a cell?
What is the purpose of indenting data in a cell?
How do you indent data in a cell?
How do you indent data in a cell?
What is the effect of clicking the Align Right button in the Alignment group?
What is the effect of clicking the Align Right button in the Alignment group?
What is the function of the Top Align button in the Alignment group?
What is the function of the Top Align button in the Alignment group?
What is the purpose of rotating data in a cell?
What is the purpose of rotating data in a cell?
How do you restore the data to its default orientation after rotating it?
How do you restore the data to its default orientation after rotating it?
What happens to the row height when you wrap data within a cell?
What happens to the row height when you wrap data within a cell?
What is the result of merging cells with data in more than one cell?
What is the result of merging cells with data in more than one cell?
Where is the Orientation button located?
Where is the Orientation button located?
What is the purpose of wrapping data within a cell?
What is the purpose of wrapping data within a cell?