Q31. What does the ‘MAX’ function return?
a) The highest value from a range of cells
b) The average value from a range of cells
c) The total sum from a range of cells
d) The number of cells with numeric data
Show Answer
Correct Answer: a) The highest value from a range of cells
Explanation: The ‘MAX’ function returns the highest value from a specified range of cells, helping identify the maximum number in the data set.
Q32. How do you add a new worksheet to a spreadsheet?
a) By clicking the ‘+’ icon or ‘New Sheet’ option
b) By saving the document
c) By using ‘Page Setup’
d) By adjusting cell height
Show Answer
Correct Answer: a) By clicking the ‘+’ icon or ‘New Sheet’ option
Explanation: To add a new worksheet, click the ‘+’ icon or select the ‘New Sheet’ option, which creates an additional sheet within the same spreadsheet file.
Q33. How can you delete a worksheet from a spreadsheet?
a) By right-clicking the sheet tab and selecting ‘Delete’
b) By changing the cell content
c) By adjusting the column width
d) By saving the document
Show Answer
Correct Answer: a) By right-clicking the sheet tab and selecting ‘Delete’
Explanation: To delete a worksheet, right-click the sheet tab at the bottom of the window and select ‘Delete,’ removing the sheet from the spreadsheet file.
Q34. What is the purpose of the ‘Freeze Panes’ feature?
a) To keep specific rows or columns visible while scrolling
b) To format cells
c) To insert a chart
d) To save the document
Show Answer
Correct Answer: a) To keep specific rows or columns visible while scrolling
Explanation: The ‘Freeze Panes’ feature allows you to keep specific rows or columns visible while scrolling through the rest of the spreadsheet, enhancing navigation.
Q35. How do you adjust the alignment of text within a cell?
a) By using the alignment options in the toolbar
b) By changing the cell color
c) By saving the document
d) By inserting a new row
Show Answer
Correct Answer: a) By using the alignment options in the toolbar
Explanation: To adjust the alignment of text within a cell, use the alignment options in the toolbar, which allows you to align text left, center, or right, and adjust vertical alignment.
Q36. How can you use the ‘Find and Replace’ feature in a spreadsheet?
a) By searching for specific text or values and replacing them with new data
b) By formatting cells
c) By adjusting row height
d) By saving the document
Show Answer
Correct Answer: a) By searching for specific text or values and replacing them with new data
Explanation: The ‘Find and Replace’ feature allows you to search for specific text or values and replace them with new data throughout the spreadsheet.
Q37. What does the ‘Conditional Formatting’ feature do?
a) Applies formatting to cells based on specific conditions or rules
b) Changes the cell color
c) Adjusts column width
d) Inserts a new row
Show Answer
Correct Answer: a) Applies formatting to cells based on specific conditions or rules
Explanation: ‘Conditional Formatting’ applies formatting to cells based on conditions or rules you set, such as highlighting cells with values above a certain threshold.
Q38. How do you create a chart based on selected data?
a) By selecting ‘Insert’ > ‘Chart’ and choosing the desired chart type
b) By adjusting cell width
c) By saving the document
d) By changing the font style
Show Answer
Correct Answer: a) By selecting ‘Insert’ > ‘Chart’ and choosing the desired chart type
Explanation: To create a chart, select the data you want to include, then go to ‘Insert’ and choose ‘Chart’ to select the type of chart that best represents your data.
Q39. What does the ‘Text to Columns’ feature do?
a) Splits the content of a cell into multiple columns based on a delimiter
b) Merges cells into one column
c) Adjusts cell height
d) Formats text within a cell
Show Answer
Correct Answer: a) Splits the content of a cell into multiple columns based on a delimiter
Explanation: The ‘Text to Columns’ feature splits the content of a single cell into multiple columns based on a specified delimiter, such as commas or spaces.
Q40. How can you apply a border to a cell or range of cells?
a) By using the ‘Borders’ option in the formatting toolbar
b) By saving the document
c) By changing the cell color
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Borders’ option in the formatting toolbar
Explanation: To apply a border, use the ‘Borders’ option in the formatting toolbar, which allows you to add various border styles to a cell or range of cells.