Q51. What does the ‘Subtotal’ function do?
a) Calculates subtotals for a range based on grouping criteria
b) Adds up all values in a range
c) Finds the maximum value in a range
d) Counts the number of cells with numeric data
Show Answer
Correct Answer: a) Calculates subtotals for a range based on grouping criteria
Explanation: The ‘Subtotal’ function calculates subtotals for a range of cells based on specified grouping criteria, such as summing values by category.
Q52. How can you quickly format cells to show percentages?
a) By using the ‘Percentage’ format option
b) By adjusting column width
c) By inserting a new row
d) By saving the document
Show Answer
Correct Answer: a) By using the ‘Percentage’ format option
Explanation: To format cells to show percentages, use the ‘Percentage’ format option, which converts numeric values into percentage format, displaying them as fractions of 100.
Q53. What is the ‘Find’ feature used for in a spreadsheet?
a) To locate specific text or values within the sheet
b) To format cells
c) To adjust row height
d) To save the document
Show Answer
Correct Answer: a) To locate specific text or values within the sheet
Explanation: The ‘Find’ feature helps locate specific text or values within a spreadsheet, making it easier to navigate and manage large datasets.
Q54. How can you highlight cells that meet certain criteria?
a) By using ‘Conditional Formatting’
b) By saving the document
c) By changing the cell color
d) By inserting a new row
Show Answer
Correct Answer: a) By using ‘Conditional Formatting’
Explanation: ‘Conditional Formatting’ allows you to highlight cells based on specific criteria or rules, such as values above a threshold, for better data visualization.
Q55. How do you remove duplicates from a data range?
a) By using the ‘Remove Duplicates’ feature
b) By saving the document
c) By adjusting cell width
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Remove Duplicates’ feature
Explanation: The ‘Remove Duplicates’ feature helps eliminate duplicate entries from a data range, ensuring that each value is unique within the selected range.
Q56. What does the ‘Insert Function’ feature allow you to do?
a) Add various functions to perform calculations or analysis
b) Change the font style
c) Adjust cell height
d) Save the document
Show Answer
Correct Answer: a) Add various functions to perform calculations or analysis
Explanation: The ‘Insert Function’ feature helps you add functions to your spreadsheet for calculations or data analysis, providing a list of available functions to choose from.
Q57. How do you change the font color in a cell?
a) By using the font 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 font color option in the formatting toolbar
Explanation: To change the font color in a cell, use the font color option in the formatting toolbar, allowing you to select different colors for the text.
Q58. How can you apply a predefined cell style to a cell?
a) By using the ‘Cell Styles’ option
b) By saving the document
c) By adjusting cell width
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Cell Styles’ option
Explanation: The ‘Cell Styles’ option allows you to apply predefined styles to cells, such as headings or input cells, for consistent and quick formatting.
Q59. What is the purpose of the ‘Paste Values’ option?
a) To paste only the values without formatting or formulas
b) To copy data from one cell to another
c) To cut data from a selected cell
d) To delete data from a cell
Show Answer
Correct Answer: a) To paste only the values without formatting or formulas
Explanation: ‘Paste Values’ pastes only the raw values from the clipboard into the selected cells, without carrying over any formatting or formulas.
Q60. How can you change the format of a cell to display time?
a) By using the ‘Number Format’ options and selecting ‘Time’
b) By adjusting row height
c) By inserting a new row
d) By changing the font style
Show Answer
Correct Answer: a) By using the ‘Number Format’ options and selecting ‘Time’
Explanation: To display time in a cell, use the ‘Number Format’ options and select ‘Time,’ which formats the cell to show time values appropriately.