1. How can you start editing the content of a cell?
- A) Double-click the cell
- B) Press F2
- C) Select the cell and type
- D) Right-click the cell and choose “Edit”
Answer: A) Double-click the cell or B) Press F2
2. What happens when you press Enter after typing data into a cell?
- A) The data is saved and the selection moves down one cell
- B) The data is saved and the selection moves right one cell
- C) The cell enters edit mode
- D) The data is cleared
Answer: A) The data is saved and the selection moves down one cell
3. How can you quickly copy data from one cell to another?
- A) Drag the Fill Handle from the original cell to the target cell
- B) Press Ctrl + C to copy and Ctrl + V to paste
- C) Use the Copy and Paste options from the Home tab
- D) All of the above
Answer: D) All of the above
4. How do you undo the last action in Excel?
- A) Press Ctrl + Z
- B) Press Ctrl + Y
- C) Press Esc
- D) Right-click and select “Undo”
Answer: A) Press Ctrl + Z
5. What does pressing Ctrl + X do in Excel?
- A) Cuts the selected data
- B) Copies the selected data
- C) Pastes the copied data
- D) Deletes the selected data
Answer: A) Cuts the selected data
6. How can you paste data without formatting in Excel?
- A) Use Paste Special and select “Values”
- B) Use the Format Painter
- C) Use the Clear Formats option
- D) Paste the data and then use the “Clear All” option
Answer: A) Use Paste Special and select “Values”
7. To enter the same data into multiple cells at once, you should:
- A) Select all the cells and type the data, then press Ctrl + Enter
- B) Type the data into the first cell, then use the Fill Handle
- C) Use Copy and Paste for each cell
- D) Type the data into each cell individually
Answer: A) Select all the cells and type the data, then press Ctrl + Enter
8. What is the purpose of the “Find and Replace” feature in Excel?
- A) To search for specific data and replace it with new data
- B) To copy data from one cell to another
- C) To sort data in a range
- D) To delete data in a range
Answer: A) To search for specific data and replace it with new data
9. How can you enter the current date into a cell?
- A) Press Ctrl + ; (semicolon)
- B) Press Ctrl + Shift + D
- C) Type =TODAY() and press Enter
- D) Use the Insert Date option from the Home tab
Answer: A) Press Ctrl + ; (semicolon) or C) Type =TODAY() and press Enter
10. To automatically fill a series of dates or numbers, you should use:
- A) AutoFill Handle
- B) Fill Series Command
- C) Flash Fill
- D) Data Validation
Answer: A) AutoFill Handle