Q41. What does the ‘Merge Cells’ feature do?
a) Combines multiple cells into a single cell
b) Splits a cell into multiple cells
c) Changes the font size
d) Adjusts cell height
Show Answer
Correct Answer: a) Combines multiple cells into a single cell
Explanation: The ‘Merge Cells’ feature combines multiple selected cells into a single cell, useful for creating headings or combining data.
Q42. How do you format a cell to display currency?
a) By using the ‘Number Format’ options and selecting ‘Currency’
b) By adjusting cell 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 ‘Currency’
Explanation: To format a cell to display currency, use the ‘Number Format’ options and select ‘Currency,’ which adds currency symbols and formats numbers accordingly.
Q43. How can you adjust the orientation of the text in a cell?
a) By using the text orientation options in the formatting toolbar
b) By saving the document
c) By adjusting cell height
d) By inserting a new row
Show Answer
Correct Answer: a) By using the text orientation options in the formatting toolbar
Explanation: To adjust text orientation, use the text orientation options in the formatting toolbar, allowing you to rotate text to vertical or diagonal.
Q44. What is the purpose of using ‘Cell References’ in formulas?
a) To refer to the value in a specific cell or range of cells
b) To format cells
c) To adjust row height
d) To save the document
Show Answer
Correct Answer: a) To refer to the value in a specific cell or range of cells
Explanation: ‘Cell References’ in formulas refer to the value in specific cells or ranges, allowing formulas to use dynamic data from those cells.
Q45. What does the ‘Protect Sheet’ feature do?
a) Prevents unauthorized changes to the content of a sheet
b) Formats cells
c) Inserts a chart
d) Adjusts column width
Show Answer
Correct Answer: a) Prevents unauthorized changes to the content of a sheet
Explanation: The ‘Protect Sheet’ feature restricts editing and protects the content of a sheet from unauthorized changes, enhancing data security.
Q46. How can you quickly navigate to a specific cell in a large spreadsheet?
a) By using the ‘Go To’ feature
b) By scrolling manually
c) By saving the document
d) By using ‘Page Setup’
Show Answer
Correct Answer: a) By using the ‘Go To’ feature
Explanation: The ‘Go To’ feature allows you to quickly navigate to a specific cell by entering the cell reference, saving time in large spreadsheets.
Q47. What is the ‘Freeze Panes’ option used for?
a) To keep specific rows or columns visible while scrolling through the rest of the sheet
b) To format cells
c) To insert a new row
d) To save the document
Show Answer
Correct Answer: a) To keep specific rows or columns visible while scrolling through the rest of the sheet
Explanation: ‘Freeze Panes’ keeps specified rows or columns visible as you scroll through other parts of the spreadsheet, facilitating easier data review.
Q48. How can you remove formatting from a cell?
a) By using the ‘Clear Formats’ option
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 ‘Clear Formats’ option
Explanation: To remove formatting from a cell, use the ‘Clear Formats’ option, which resets the cell to its default formatting while preserving its content.
Q49. How do you apply a filter to a data range?
a) By selecting ‘Data’ > ‘Filter’
b) By adjusting column width
c) By saving the document
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting ‘Data’ > ‘Filter’
Explanation: To apply a filter, select ‘Data’ and then ‘Filter,’ which allows you to filter data based on specific criteria, making it easier to analyze subsets of data.
Q50. How can you create a hyperlink in a cell?
a) By using the ‘Insert Hyperlink’ option
b) By changing the font size
c) By adjusting cell height
d) By saving the document
Show Answer
Correct Answer: a) By using the ‘Insert Hyperlink’ option
Explanation: To create a hyperlink, use the ‘Insert Hyperlink’ option, which allows you to link to another cell, document, or web page from within the spreadsheet.