Q11. How can you insert a new column into a spreadsheet?
a) Select a column, right-click, and choose ‘Insert’
b) Use the ‘Insert’ option from the toolbar
c) Drag the column boundary to add a new column
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: To insert a new column, you can select a column, right-click and choose ‘Insert,’ or use the ‘Insert’ option from the toolbar.
Q12. What does the ‘SUM’ function do in a spreadsheet?
a) Adds up a range of numbers
b) Counts the number of cells with numeric data
c) Finds the average of a range of numbers
d) Calculates the maximum value in a range
Show Answer
Correct Answer: a) Adds up a range of numbers
Explanation: The ‘SUM’ function adds up all the numbers in a specified range of cells, providing the total sum of those values.
Q13. How do you sort data in a spreadsheet?
a) Use the ‘Sort’ option from the Data menu
b) Manually arrange the data by dragging
c) Use the ‘Filter’ feature
d) Use the ‘AutoFill’ feature
Show Answer
Correct Answer: a) Use the ‘Sort’ option from the Data menu
Explanation: To sort data, use the ‘Sort’ option from the Data menu, which allows you to arrange data in ascending or descending order based on specified criteria.
Q14. What does the ‘Paste Special’ option allow you to do?
a) Paste data with specific formatting or operations
b) Paste data into multiple cells at once
c) Paste data and replace existing content
d) Paste data with formulas only
Show Answer
Correct Answer: a) Paste data with specific formatting or operations
Explanation: The ‘Paste Special’ option allows you to paste data with specific formatting or operations, such as pasting only values, formats, or formulas.
Q15. How do you adjust the width of a column in a spreadsheet?
a) Drag the boundary of the column header
b) Use the ‘Column Width’ option from the Format menu
c) Double-click the column boundary for auto-fit
d) All of the above
Show Answer
Correct Answer: d) All of the above
Explanation: You can adjust the width of a column by dragging the boundary of the column header, using the ‘Column Width’ option from the Format menu, or double-clicking the column boundary for auto-fit.
Q16. How can you change the background color of a cell?
a) Use the ‘Fill Color’ button in the toolbar
b) Use the ‘Background’ option from the Format menu
c) Apply a color theme to the cell
d) Use the ‘Cell Styles’ feature
Show Answer
Correct Answer: a) Use the ‘Fill Color’ button in the toolbar
Explanation: To change the background color of a cell, use the ‘Fill Color’ button in the toolbar, which allows you to select and apply a color to the cell’s background.
Q17. What is the purpose of the ‘Chart’ feature in a spreadsheet?
a) To visualize data through graphical representations
b) To sort data in alphabetical order
c) To format cells with different styles
d) To insert images into the spreadsheet
Show Answer
Correct Answer: a) To visualize data through graphical representations
Explanation: The ‘Chart’ feature allows you to visualize data through graphical representations such as bar charts, pie charts, and line charts, making it easier to analyze and interpret data.
Q18. How do you insert a new row into a spreadsheet?
a) Select a row, right-click, and choose ‘Insert’
b) Use the ‘Insert’ option from the toolbar
c) Drag the row boundary to add a new row
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: To insert a new row, you can select a row, right-click and choose ‘Insert,’ or use the ‘Insert’ option from the toolbar.
Q19. What is the function of the ‘COUNT’ function in a spreadsheet?
a) Counts the number of cells that contain numeric data
b) Adds up all the values in a range
c) Finds the average of a set of numbers
d) Counts the number of cells with text data
Show Answer
Correct Answer: a) Counts the number of cells that contain numeric data
Explanation: The ‘COUNT’ function counts the number of cells that contain numeric data within a specified range.
Q20. How can you protect a spreadsheet from being edited?
a) Use the ‘Protect Sheet’ feature in the Review tab
b) Save the file as a read-only document
c) Set a password for the file
d) Both a and c
Show Answer
Correct Answer: d) Both a and c
Explanation: To protect a spreadsheet from being edited, you can use the ‘Protect Sheet’ feature in the Review tab or set a password for the file to restrict access.