Q61. How can you use the ‘SUBTOTAL’ function in a spreadsheet?
a) To perform calculations on filtered data
b) To count the total number of cells in a range
c) To calculate the sum of a range of cells
d) To find the maximum value in a range
Show Answer
Correct Answer: a) To perform calculations on filtered data
Explanation: The ‘SUBTOTAL’ function performs calculations like SUM, AVERAGE, COUNT, etc., on filtered data, providing results based on visible cells only.
Q62. What is the purpose of the ‘FIND’ function in a spreadsheet?
a) To locate the position of a substring within a text string
b) To replace text in a cell
c) To count occurrences of a word
d) To format cells with specific text
Show Answer
Correct Answer: a) To locate the position of a substring within a text string
Explanation: The ‘FIND’ function locates the position of a substring within a text string, useful for text manipulation and searching within a cell.
Q63. How can you apply conditional formatting to a cell?
a) Use the ‘Conditional Formatting’ option from the Home tab
b) Use the ‘Format Cells’ dialog box
c) Manually change the cell’s format based on its value
d) Both a and b
Show Answer
Correct Answer: a) Use the ‘Conditional Formatting’ option from the Home tab
Explanation: Conditional formatting is applied using the ‘Conditional Formatting’ option from the Home tab, allowing you to set formatting rules based on cell values or conditions.
Q64. How do you use the ‘LEFT’ function in a spreadsheet?
a) To extract a specified number of characters from the beginning of a text string
b) To find the position of a character in a text string
c) To count characters in a text string
d) To replace text within a string
Show Answer
Correct Answer: a) To extract a specified number of characters from the beginning of a text string
Explanation: The ‘LEFT’ function extracts a specified number of characters from the beginning of a text string, useful for text manipulation and data extraction.
Q65. What is the function of the ‘COUNTA’ function in a spreadsheet?
a) To count the number of non-empty cells in a range
b) To count cells with numeric data only
c) To count the number of blank cells
d) To count cells containing specific text
Show Answer
Correct Answer: a) To count the number of non-empty cells in a range
Explanation: The ‘COUNTA’ function counts the number of non-empty cells in a range, including cells with text, numbers, and other data.
Q66. How can you protect a worksheet from editing?
a) Use the ‘Protect Sheet’ option from the Review tab
b) Use the ‘Lock Cells’ feature
c) Password-protect the entire workbook
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: You can protect a worksheet from editing using the ‘Protect Sheet’ option from the Review tab and by locking specific cells within the sheet.
Q67. How do you use the ‘TRIM’ function in a spreadsheet?
a) To remove extra spaces from a text string
b) To count the number of spaces in a text string
c) To find and replace spaces in text
d) To add spaces between words
Show Answer
Correct Answer: a) To remove extra spaces from a text string
Explanation: The ‘TRIM’ function removes extra spaces from the beginning and end of a text string and reduces multiple spaces between words to a single space.
Q68. What is the function of the ‘DATEVALUE’ function in a spreadsheet?
a) To convert a date in text format into a serial number
b) To display the current date
c) To calculate the number of days between two dates
d) To format a cell as a date
Show Answer
Correct Answer: a) To convert a date in text format into a serial number
Explanation: The ‘DATEVALUE’ function converts a date in text format into a serial number that can be used in date calculations.
Q69. How can you freeze panes in a spreadsheet?
a) Use the ‘Freeze Panes’ option from the View tab
b) Use the ‘Split’ feature from the View tab
c) Manually adjust cell positions
d) Both a and b
Show Answer
Correct Answer: a) Use the ‘Freeze Panes’ option from the View tab
Explanation: To freeze panes, use the ‘Freeze Panes’ option from the View tab, which keeps specific rows or columns visible while scrolling through the sheet.
Q70. How do you insert a new row in a spreadsheet?
a) Right-click on a row number and select ‘Insert’
b) Use the ‘Insert’ option from the Home tab
c) Use the ‘Insert Row’ option from the Data menu
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: To insert a new row, right-click on a row number and select ‘Insert,’ or use the ‘Insert’ option from the Home tab to add a new row.