Q61. What does the ‘Subtotal’ function calculate in a range of data?
a) Calculates subtotals based on a grouping criteria
b) Adds all the values in the range
c) Finds the maximum value in the range
d) Counts the number of cells with numeric data
Show Answer
Correct Answer: a) Calculates subtotals based on a grouping criteria
Explanation: The ‘Subtotal’ function calculates subtotals for data within a specified range based on grouping criteria, such as summing data by category.
Q62. How do you copy the formatting from one cell to another?
a) By using the ‘Format Painter’ tool
b) By saving the document
c) By changing the cell content
d) By adjusting row height
Show Answer
Correct Answer: a) By using the ‘Format Painter’ tool
Explanation: The ‘Format Painter’ tool copies the formatting from one cell and applies it to another, helping maintain consistent formatting across cells.
Q63. How can you protect specific cells in a worksheet?
a) By using the ‘Protect Sheet’ feature and setting cell-specific protection
b) By formatting cells
c) By adjusting row height
d) By saving the document
Show Answer
Correct Answer: a) By using the ‘Protect Sheet’ feature and setting cell-specific protection
Explanation: The ‘Protect Sheet’ feature allows you to protect specific cells within a worksheet from changes while keeping other cells editable.
Q64. How can you quickly navigate between different worksheets in a workbook?
a) By clicking on the sheet tabs at the bottom of the workbook
b) By saving the document
c) By adjusting cell width
d) By inserting a new row
Show Answer
Correct Answer: a) By clicking on the sheet tabs at the bottom of the workbook
Explanation: To quickly navigate between different worksheets, click on the sheet tabs at the bottom of the workbook, which display all available sheets.
Q65. What does the ‘Data Validation’ feature do?
a) Restricts the type of data that can be entered into a cell
b) Formats cells
c) Adjusts column width
d) Saves the document
Show Answer
Correct Answer: a) Restricts the type of data that can be entered into a cell
Explanation: ‘Data Validation’ restricts the type of data that can be entered into a cell, ensuring that only valid data is entered according to specified criteria.
Q66. What is the primary use of the ‘AutoSum’ feature in spreadsheets?
a) To quickly calculate the sum of a range of cells
b) To format cells
c) To insert a chart
d) To save the document
Show Answer
Correct Answer: a) To quickly calculate the sum of a range of cells
Explanation: The ‘AutoSum’ feature quickly adds up the values in a selected range of cells, providing a fast way to compute totals without manually entering a formula.
Q67. How do you create a chart from a range of data?
a) By selecting the data range and choosing ‘Insert Chart’
b) By saving the document
c) By adjusting cell width
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting the data range and choosing ‘Insert Chart’
Explanation: To create a chart, select the data range and choose ‘Insert Chart,’ which generates a visual representation of the data based on the selected range.
Q68. What is the function of the ‘Freeze Panes’ option in a spreadsheet?
a) Keeps specific rows or columns visible while scrolling through the sheet
b) Formats cells
c) Inserts a new row
d) Adjusts column width
Show Answer
Correct Answer: a) Keeps specific rows or columns visible while scrolling through the sheet
Explanation: The ‘Freeze Panes’ option allows you to keep certain rows or columns visible while you scroll through other parts of the sheet, making it easier to review data.
Q69. How can you change the background color of a cell?
a) By using the ‘Fill Color’ option in the formatting toolbar
b) By saving the document
c) By adjusting row height
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Fill Color’ option in the formatting toolbar
Explanation: The ‘Fill Color’ option in the formatting toolbar lets you change the background color of a cell, which helps highlight or categorize data visually.
Q70. What does the ‘Sort’ feature do in a spreadsheet?
a) Organizes 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) Organizes data in ascending or descending order based on selected criteria
Explanation: The ‘Sort’ feature arranges data in ascending or descending order according to the selected criteria, facilitating data analysis and organization.