Q81. What does the ‘Split’ feature do in a spreadsheet?
a) Divides the window into multiple panes to view different parts of the worksheet simultaneously
b) Formats cells
c) Adjusts row height
d) Saves the document
Show Answer
Correct Answer: a) Divides the window into multiple panes to view different parts of the worksheet simultaneously
Explanation: The ‘Split’ feature divides the window into separate panes, allowing you to view and work on different sections of the worksheet at the same time.
Q82. How do you apply a data filter to view specific rows based on criteria?
a) By using the ‘Filter’ option in the ‘Data’ tab
b) By saving the document
c) By changing the font style
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Filter’ option in the ‘Data’ tab
Explanation: The ‘Filter’ option in the ‘Data’ tab allows you to apply filters to view specific rows that meet your criteria, making it easier to analyze subsets of data.
Q83. How can you add a comment to a cell?
a) By using the ‘Insert Comment’ option
b) By saving the document
c) By adjusting row height
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Insert Comment’ option
Explanation: To add a comment to a cell, use the ‘Insert Comment’ option, which allows you to provide additional information or notes related to the cell’s content.
Q84. What does the ‘Sort’ feature do in a spreadsheet?
a) Arranges data in ascending or descending order based on selected criteria
b) Formats cells
c) Inserts a new row
d) Saves the document
Show Answer
Correct Answer: a) Arranges data in ascending or descending order based on selected criteria
Explanation: The ‘Sort’ feature organizes data according to specified criteria, such as sorting numbers from smallest to largest or text alphabetically.
Q85. How can you use the ‘Name Box’ in a spreadsheet?
a) To quickly navigate to a specific cell or range by typing the name
b) To format cells
c) To insert a new row
d) To change the cell color
Show Answer
Correct Answer: a) To quickly navigate to a specific cell or range by typing the name
Explanation: The ‘Name Box’ allows you to quickly navigate to a specific cell or range by typing its name or cell reference, streamlining navigation in large spreadsheets.
Q86. What is the purpose of the ‘Cell Styles’ feature?
a) To apply predefined formatting to cells for consistency and clarity
b) To save the document
c) To adjust row height
d) To insert a new row
Show Answer
Correct Answer: a) To apply predefined formatting to cells for consistency and clarity
Explanation: The ‘Cell Styles’ feature provides predefined formatting options that can be applied to cells, ensuring consistent and visually appealing cell formatting.
Q87. How do you create a new worksheet within a workbook?
a) By clicking the ‘Insert Worksheet’ button at the bottom of the workbook
b) By saving the document
c) By adjusting column width
d) By inserting a new row
Show Answer
Correct Answer: a) By clicking the ‘Insert Worksheet’ button at the bottom of the workbook
Explanation: To create a new worksheet within a workbook, click the ‘Insert Worksheet’ button at the bottom of the workbook, which adds a new sheet to the existing set.
Q88. What does the ‘Concatenate’ function do in a spreadsheet?
a) Joins together text from multiple cells into one cell
b) Formats cells
c) Adjusts row height
d) Saves the document
Show Answer
Correct Answer: a) Joins together text from multiple cells into one cell
Explanation: The ‘Concatenate’ function combines text from multiple cells into a single cell, useful for creating full names or combined data from different sources.
Q89. How can you quickly duplicate the contents of a cell to adjacent cells?
a) By using the ‘Fill Handle’ and dragging across adjacent cells
b) By saving the document
c) By adjusting column width
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Fill Handle’ and dragging across adjacent cells
Explanation: The ‘Fill Handle’ allows you to quickly duplicate the contents of a cell by dragging it across adjacent cells, simplifying data entry tasks.
Q90. How can you set a print area in a worksheet?
a) By selecting the desired range and choosing ‘Set Print Area’ from the ‘Page Layout’ tab
b) By saving the document
c) By adjusting row height
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting the desired range and choosing ‘Set Print Area’ from the ‘Page Layout’ tab
Explanation: To set a print area, select the range of cells you want to print and choose ‘Set Print Area’ from the ‘Page Layout’ tab, ensuring only the selected range is printed.