Q11. To prevent a formula’s cell reference from changing when copying the formula, you should use:
a) Absolute reference
b) Relative reference
c) Mixed reference
d) Relative addressing
Show Answer
Correct Answer: a) Absolute reference
Explanation: Absolute references, denoted by dollar signs (e.g., $A$1), remain constant when a formula is copied to other cells, ensuring that the cell reference does not change.
Q12. How can you insert a new chart into your spreadsheet?
a) Use the “Insert Chart” button on the toolbar
b) Select the data and choose “Create Chart” from the menu
c) Right-click and select “Add Chart”
d) Use the “Chart Wizard” under the Data menu
Show Answer
Correct Answer: a) Use the “Insert Chart” button on the toolbar
Explanation: The “Insert Chart” button on the toolbar or ribbon provides options to create various types of charts based on selected data.
Q13. To create a chart with data from multiple sheets, you should:
a) Copy data into a single sheet before creating the chart
b) Use the “Chart Tools” to link multiple sheets
c) Use the “Insert Chart” function and select data from different sheets
d) Manually combine the data into one sheet
Show Answer
Correct Answer: c) Use the “Insert Chart” function and select data from different sheets
Explanation: The “Insert Chart” function allows users to select data from multiple sheets when creating a chart, providing flexibility in visualizing data.
Q14. Which of the following can you not directly insert into a spreadsheet?
a) Clip Art
b) Hyperlink
c) SmartArt
d) Video file
Show Answer
Correct Answer: d) Video file
Explanation: While you can insert Clip Art, hyperlinks, and SmartArt into a spreadsheet, inserting video files is not directly supported within the spreadsheet itself.
Q15. What does the “Find and Replace” feature in a spreadsheet do?
a) Finds and changes cell formatting
b) Searches for data and replaces it with new data
c) Finds and replaces formulas in cells
d) Searches for and replaces entire worksheets
Show Answer
Correct Answer: b) Searches for data and replaces it with new data
Explanation: The “Find and Replace” feature allows users to search for specific data within the spreadsheet and replace it with new data as needed.
Q16. Which key combination allows you to quickly save your current workbook?
a) Ctrl + P
b) Ctrl + C
c) Ctrl + S
d) Ctrl + V
Show Answer
Correct Answer: c) Ctrl + S
Explanation: Pressing Ctrl + S is the shortcut for saving the current workbook, ensuring that your changes are stored.
Q17. How do you delete a column in a spreadsheet?
a) Right-click the column header and select “Delete”
b) Use the “Delete” option from the “Edit” menu
c) Click the “Remove Column” button on the toolbar
d) Drag the column header to the trash bin
Show Answer
Correct Answer: a) Right-click the column header and select “Delete”
Explanation: Right-clicking on the column header and selecting “Delete” removes the entire column from the spreadsheet.
Q18. What is the function of the “Freeze Panes” option in Excel?
a) To keep a specific cell visible while scrolling through the spreadsheet
b) To lock the spreadsheet from being edited
c) To keep rows and columns visible while scrolling
d) To stop automatic calculations
Show Answer
Correct Answer: c) To keep rows and columns visible while scrolling
Explanation: The “Freeze Panes” option allows users to keep specific rows or columns visible while scrolling through large spreadsheets, making data easier to manage.
Q19. What happens when you press “Ctrl + Z” in a spreadsheet?
a) It saves the workbook
b) It undoes the last action
c) It prints the current sheet
d) It copies the selected cells
Show Answer
Correct Answer: b) It undoes the last action
Explanation: Pressing “Ctrl + Z” undoes the most recent action, allowing users to revert changes they made.
Q20. Which of the following is NOT a valid chart type in Excel?
a) Pie Chart
b) Line Chart
c) Scatter Plot
d) Table Chart
Show Answer
Correct Answer: d) Table Chart
Explanation: Excel supports various chart types such as Pie Charts, Line Charts, and Scatter Plots, but does not have a “Table Chart” type. Tables are a separate feature.