1. How do you select an entire column in Excel?
- A) Click on the column header
- B) Press Ctrl + Shift + Arrow Key
- C) Press Shift + Spacebar
- D) Right-click on a cell and choose “Select Column”
Answer: A) Click on the column header
2. Which of the following actions will insert a new row above the selected row?
- A) Press Ctrl + Shift + +
- B) Right-click on the row number and select “Insert”
- C) Press Ctrl + R
- D) Click the “Insert” button on the Home tab
Answer: B) Right-click on the row number and select “Insert”
3. What happens when you double-click the boundary line between column headers in Excel?
- A) The column is hidden
- B) The column is resized to fit the longest cell content
- C) The column is deleted
- D) The cell formatting is reset
Answer: B) The column is resized to fit the longest cell content
4. How can you adjust the width of multiple columns at once?
- A) Drag the boundary line of one column header while holding Shift
- B) Double-click the boundary line of one column header while holding Ctrl
- C) Select the columns and drag any boundary line between column headers
- D) Use the Format option in the Home tab to set the width for multiple columns
Answer: C) Select the columns and drag any boundary line between column headers
5. To merge two or more cells into a single cell, you should use which feature?
- A) Format Cells
- B) Merge & Center
- C) Split Cells
- D) Autofit
Answer: B) Merge & Center
6. How can you quickly navigate to the first cell of a worksheet?
- A) Press Ctrl + Home
- B) Press Ctrl + End
- C) Click the “Go To” button on the Home tab
- D) Press Home
Answer: A) Press Ctrl + Home