1. Which of the following shortcuts is used to create a new workbook in Excel?
- A) Ctrl + N
- B) Ctrl + O
- C) Ctrl + S
- D) Ctrl + P
Answer: A) Ctrl + N
2. What does the “Freeze Panes” feature in Excel do?
- A) Locks rows and columns to keep them visible while scrolling
- B) Protects the worksheet from changes
- C) Hides rows and columns
- D) Copies the worksheet to another location
Answer: A) Locks rows and columns to keep them visible while scrolling
3. In Excel, how can you rename a worksheet tab?
- A) Double-click the tab name
- B) Right-click the tab and select “Rename”
- C) Press F2 while the tab is selected
- D) All of the above
Answer: D) All of the above
4. Which of the following functions is used to sum a range of cells in Excel?
- A) =AVERAGE()
- B) =SUM()
- C) =COUNT()
- D) =MAX()
Answer: B) =SUM()
5. How can you protect a worksheet from being modified by others?
- A) Use the “Protect Sheet” feature in the Review tab
- B) Save the workbook as read-only
- C) Hide the worksheet
- D) Delete the worksheet
Answer: A) Use the “Protect Sheet” feature in the Review tab
6. What is the purpose of the “VLOOKUP” function in Excel?
- A) To search for a value in the leftmost column and return a value in the same row from a specified column
- B) To calculate the average of a range of cells
- C) To count the number of cells that contain numbers
- D) To find the highest value in a range
Answer: A) To search for a value in the leftmost column and return a value in the same row from a specified col