Q71. How do you use the ‘VLOOKUP’ function in a spreadsheet?
a) To search for a value in the first column of a table and return a value in the same row from a specified column
b) To find the lowest value in a range
c) To calculate the total of a range of numbers
d) To sort data in ascending order
Show Answer
Correct Answer: a) To search for a value in the first column of a table and return a value in the same row from a specified column
Explanation: The ‘VLOOKUP’ function searches for a value in the first column of a table and returns a value from a specified column in the same row.
Q72. What does the ‘FILL HANDLE’ do in a spreadsheet?
a) Allows you to drag and fill a series of cells with data or formulas
b) Formats cells with data
c) Creates a chart from selected data
d) Deletes data from cells
Show Answer
Correct Answer: a) Allows you to drag and fill a series of cells with data or formulas
Explanation: The ‘FILL HANDLE’ allows you to drag and fill a series of cells with data or formulas, facilitating quick data entry and pattern creation.
Q73. How can you format numbers as percentages in a spreadsheet?
a) Use the ‘Percentage’ format from the Number Format options
b) Manually add percentage symbols to each cell
c) Use the ‘Text’ format and enter percentages as text
d) Use the ‘Currency’ format
Show Answer
Correct Answer: a) Use the ‘Percentage’ format from the Number Format options
Explanation: To format numbers as percentages, use the ‘Percentage’ format from the Number Format options, which automatically adjusts the number to a percentage.
Q74. How do you use the ‘NOW’ function in a spreadsheet?
a) To display the current date and time
b) To display the current date only
c) To calculate the difference between two dates
d) To find the most recent date in a range
Show Answer
Correct Answer: a) To display the current date and time
Explanation: The ‘NOW’ function displays the current date and time, updating automatically whenever the spreadsheet is recalculated.
Q75. How can you add borders to cells in a spreadsheet?
a) Use the ‘Borders’ option from the Format Cells dialog box
b) Use the ‘Cell Borders’ option from the Home tab
c) Manually draw borders on the cells
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: You can add borders to cells using the ‘Borders’ option from the Format Cells dialog box or the ‘Cell Borders’ option from the Home tab.
Q76. 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 substring within a text string
c) To count the number of 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.
Q77. What is the function of the ‘AVERAGE’ function in a spreadsheet?
a) To calculate the mean of a range of numbers
b) To find the highest value in a range
c) To count the number of cells in a range
d) To sum up a range of cells
Show Answer
Correct Answer: a) To calculate the mean of a range of numbers
Explanation: The ‘AVERAGE’ function calculates the mean (average) of a range of numbers, providing the central value in a dataset.
Q78. How do you use the ‘RIGHT’ function in a spreadsheet?
a) To extract a specified number of characters from the end of a text string
b) To find the position of a character in a text string
c) To count occurrences of a character 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 end of a text string
Explanation: The ‘RIGHT’ function extracts a specified number of characters from the end of a text string, useful for text manipulation and data extraction.
Q79. What is the function of the ‘CONCATENATE’ function?
a) To join two or more text strings into one string
b) To split a text string into separate cells
c) To count the number of text strings in a range
d) To replace text in a cell
Show Answer
Correct Answer: a) To join two or more text strings into one string
Explanation: The ‘CONCATENATE’ function joins two or more text strings into one string, useful for combining text from multiple cells into one cell.
Q80. How do you use the ‘INDEX’ function in a spreadsheet?
a) To return a value from a specific cell within a range based on row and column numbers
b) To search for a value within a range
c) To calculate the total of a range of cells
d) To sort data in ascending order
Show Answer
Correct Answer: a) To return a value from a specific cell within a range based on row and column numbers
Explanation: The ‘INDEX’ function returns a value from a specific cell within a range, determined by row and column numbers, facilitating precise data retrieval.