Q91. How can you use the ‘MAX’ function in a spreadsheet?
a) To find the highest value in a range of numbers
b) To find the lowest value in a range of numbers
c) To calculate the average of a range of numbers
d) To count the number of cells in a range
Show Answer
Correct Answer: a) To find the highest value in a range of numbers
Explanation: The ‘MAX’ function finds the highest value in a range of numbers, providing the largest number in the dataset.
Q92. How do you use the ‘AND’ function in a spreadsheet formula?
a) To test multiple conditions and return TRUE only if all conditions are TRUE
b) To test multiple conditions and return TRUE if any condition is TRUE
c) To combine text strings into one cell
d) To find the position of a substring within a text string
Show Answer
Correct Answer: a) To test multiple conditions and return TRUE only if all conditions are TRUE
Explanation: The ‘AND’ function tests multiple conditions and returns TRUE only if all conditions are TRUE, useful for complex logical tests in formulas.
Q93. What is the purpose of the ‘IFERROR’ function in a spreadsheet?
a) To return a specified value if a formula results in an error
b) To find errors in a formula
c) To correct errors in cell values
d) To calculate the difference between two numbers
Show Answer
Correct Answer: a) To return a specified value if a formula results in an error
Explanation: The ‘IFERROR’ function returns a specified value if a formula results in an error, helping to handle and manage errors in calculations.
Q94. How do you use the ‘CELL’ function in a spreadsheet?
a) To get information about the formatting, location, or contents of a cell
b) To calculate the sum of a range of cells
c) To sort data in ascending order
d) To find the lowest value in a range
Show Answer
Correct Answer: a) To get information about the formatting, location, or contents of a cell
Explanation: The ‘CELL’ function provides information about the formatting, location, or contents of a cell, useful for retrieving cell-specific data.
Q95. How can you insert a chart title in a spreadsheet?
a) Click on the chart and use the ‘Chart Elements’ option to add a title
b) Manually type the title into the chart area
c) Use the ‘Insert Title’ option from the Chart Tools menu
d) Both a and b
Show Answer
Correct Answer: a) Click on the chart and use the ‘Chart Elements’ option to add a title
Explanation: To insert a chart title, click on the chart and use the ‘Chart Elements’ option to add and customize the title.
Q96. What is the use of the ‘COUNTIF’ function in a spreadsheet?
a) To count the number of cells that meet a specific condition
b) To find the maximum value in a range
c) To calculate the average of a range of numbers
d) To count the total number of cells in a range
Show Answer
Correct Answer: a) To count the number of cells that meet a specific condition
Explanation: The ‘COUNTIF’ function counts the number of cells that meet a specific condition, useful for conditional counting in datasets.
Q97. How do you use the ‘TEXT’ function in a spreadsheet?
a) To convert a number into text with a specific format
b) To count the number of characters in a text string
c) To find the position of a substring within a text string
d) To concatenate multiple text strings
Show Answer
Correct Answer: a) To convert a number into text with a specific format
Explanation: The ‘TEXT’ function converts a number into text with a specified format, allowing for custom formatting of numeric data as text.
Q98. What is the purpose of the ‘XLOOKUP’ function in a spreadsheet?
a) To search a range or array and return a value based on a matching lookup value
b) To find the highest 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 a range or array and return a value based on a matching lookup value
Explanation: The ‘XLOOKUP’ function searches a range or array and returns a value based on a matching lookup value, providing a versatile alternative to ‘VLOOKUP’ and ‘HLOOKUP.’
Q99. How do you use the ‘NORMDIST’ function in a spreadsheet?
a) To calculate the normal distribution probability for a given mean and standard deviation
b) To find the median of a range of numbers
c) To calculate the variance of a dataset
d) To determine the total number of cells in a range
Show Answer
Correct Answer: a) To calculate the normal distribution probability for a given mean and standard deviation
Explanation: The ‘NORMDIST’ function calculates the normal distribution probability for a given mean and standard deviation, useful for statistical analysis.
Q100. What does the ‘DAYS’ function do in a spreadsheet?
a) Calculates the number of days between two dates
b) Displays the current date
c) Calculates the number of workdays between two dates
d) Converts a date to a serial number
Show Answer
Correct Answer: a) Calculates the number of days between two dates
Explanation: The ‘DAYS’ function calculates the number of days between two dates, facilitating date difference calculations in spreadsheets.