Editing and Formatting Data Using Google
Sheets(Worksheet)
Multiple Choice Questions (3)
- **Q1:** How do you select an entire row in Google Sheets?
- a) Click on any cell in the row
- b) Click on the row number
- c) Click on the column letter
- d) Press Ctrl + A
- **Q2:** What is the purpose of the "Autofill" feature in Google Sheets?
- a) To insert new rows automatically
- b) To copy a formula to adjacent cells
- c) To delete a row or column
- d) To undo the last action
- **Q3:** Which keyboard shortcut is used to undo the last action in Google Sheets?
- a) Ctrl + Z
- b) Ctrl + Y
- c) Ctrl + X
- d) Ctrl + C
2. True or False (3)**
- **Q1:** You can move data in Google Sheets by dragging the selected cells to a new
location._________
- **Q2:** The "Redo" function in Google Sheets reverses the last undone action.________
- **Q3:** You cannot insert a new column in Google Sheets once the sheet is full of data.
_________
### **3. Output Based Questions (3)**
- **Q1:** What will happen if you select a range of cells and press Ctrl + C, followed by Ctrl +
V on another part of the sheet?
**Answer:**
- **Q2:** If you have the values 1, 2, 3 in cells A1, A2, A3 and use the Autofill handle to drag
down to A10, what will be the values in cells A4 to A10?
- **Q3:** After deleting row 5 from a sheet, what will happen to the data originally in rows 6,
7, and beyond?
---
### **4. Error Finding Questions (3)**
- **Q1:** A user tries to move data by dragging cells but accidentally copies the data instead.
What could be the mistake?
**Answer:
- **Q2:** A student inserts a new row, but the data below does not shift down. What could be
the issue?
- **Q3:** A user is unable to delete a column because the "Delete column" option is greyed
out. What might be wrong?