Q81. How can you add a chart to a spreadsheet?
a) Use the ‘Insert Chart’ option from the Insert tab
b) Use the ‘Chart Wizard’ from the Data tab
c) Copy and paste a chart from another document
d) Both a and b
Show Answer
Correct Answer: a) Use the ‘Insert Chart’ option from the Insert tab
Explanation: To add a chart, use the ‘Insert Chart’ option from the Insert tab, which allows you to choose the type of chart and customize it based on your data.
Q82. How do you use the ‘SUMIF’ function in a spreadsheet?
a) To sum values based on a specific condition
b) To calculate the average of a range based on a condition
c) To find the maximum value in a range based on a condition
d) To count cells that meet a specific condition
Show Answer
Correct Answer: a) To sum values based on a specific condition
Explanation: The ‘SUMIF’ function sums values in a range based on a specific condition, allowing for conditional summation of data.
Q83. What does the ‘Paste Special’ option allow you to do?
a) Paste only specific elements of the copied data, such as values, formats, or formulas
b) Paste data into a new worksheet
c) Paste data while excluding cell formatting
d) Copy data without formatting
Show Answer
Correct Answer: a) Paste only specific elements of the copied data, such as values, formats, or formulas
Explanation: The ‘Paste Special’ option allows you to paste specific elements of copied data, such as values, formats, or formulas, giving you control over what is pasted.
Q84. How do you create a drop-down list in a cell?
a) Use the ‘Data Validation’ option from the Data tab
b) Use the ‘List’ option from the Insert tab
c) Manually enter a list of options in the cell
d) Use the ‘Format Cells’ dialog box
Show Answer
Correct Answer: a) Use the ‘Data Validation’ option from the Data tab
Explanation: To create a drop-down list, use the ‘Data Validation’ option from the Data tab, which allows you to define a list of options for selection in a cell.
Q85. How do you use the ‘ROUND’ function in a spreadsheet?
a) To round a number to a specified number of digits
b) To find the average of a range of numbers
c) To count the number of cells in a range
d) To sort numbers in ascending order
Show Answer
Correct Answer: a) To round a number to a specified number of digits
Explanation: The ‘ROUND’ function rounds a number to a specified number of digits, allowing for precise control over numeric values in calculations.
Q86. What is the purpose of the ‘HLOOKUP’ function in a spreadsheet?
a) To search for a value in the top row of a table and return a value in the same column from a specified row
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 top row of a table and return a value in the same column from a specified row
Explanation: The ‘HLOOKUP’ function searches for a value in the top row of a table and returns a value from the same column in a specified row.
Q87. How do you use the ‘PMT’ function in a spreadsheet?
a) To calculate the payment for a loan based on constant payments and a constant interest rate
b) To find the total interest paid over the life of a loan
c) To calculate the remaining balance of a loan
d) To determine the loan amount based on monthly payments
Show Answer
Correct Answer: a) To calculate the payment for a loan based on constant payments and a constant interest rate
Explanation: The ‘PMT’ function calculates the payment amount for a loan based on constant payments and a fixed interest rate.
Q88. How can you quickly apply a cell format to multiple cells?
a) Use the ‘Format Painter’ tool from the Home tab
b) Manually apply the format to each cell
c) Use the ‘Copy Format’ option from the Format Cells dialog box
d) Both a and b
Show Answer
Correct Answer: a) Use the ‘Format Painter’ tool from the Home tab
Explanation: The ‘Format Painter’ tool allows you to quickly apply the same cell format to multiple cells by copying the format from one cell to others.
Q89. How do you use the ‘OFFSET’ function in a spreadsheet?
a) To return a reference to a range that is a specified number of rows and columns from a starting cell
b) To calculate the total of a range of cells
c) To sort data in ascending order
d) To find the highest value in a range
Show Answer
Correct Answer: a) To return a reference to a range that is a specified number of rows and columns from a starting cell
Explanation: The ‘OFFSET’ function returns a reference to a range that is a specified number of rows and columns away from a starting cell, useful for dynamic range selection.
Q90. What does the ‘SUBSTITUTE’ function do in a spreadsheet?
a) Replaces occurrences of a specified text within a text string with another text
b) Finds the position of a substring within a text string
c) Counts occurrences of a word within a text
d) Converts text to uppercase
Show Answer
Correct Answer: a) Replaces occurrences of a specified text within a text string with another text
Explanation: The ‘SUBSTITUTE’ function replaces occurrences of specified text within a text string with another text, useful for text modification and correction.