Q91. How do you insert a chart into a worksheet?
a) By selecting the data range and using the ‘Insert Chart’ option
b) By saving the document
c) By adjusting column width
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting the data range and using the ‘Insert Chart’ option
Explanation: To insert a chart, select the data range you want to visualize and use the ‘Insert Chart’ option, which creates a graphical representation of the data.
Q92. What does the ‘Merge Cells’ option do?
a) Combines multiple selected cells into one larger cell
b) Formats cells
c) Adjusts row height
d) Saves the document
Show Answer
Correct Answer: a) Combines multiple selected cells into one larger cell
Explanation: The ‘Merge Cells’ option combines several selected cells into a single larger cell, useful for creating headings or organizing data in a table format.
Q93. How can you apply a specific style to cells for better readability?
a) By using the ‘Cell Styles’ option to apply predefined styles
b) By saving the document
c) By changing the font size
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Cell Styles’ option to apply predefined styles
Explanation: The ‘Cell Styles’ option offers predefined styles that enhance cell readability and organization, making it easier to format cells consistently.
Q94. How do you change the orientation of printed pages?
a) By selecting ‘Portrait’ or ‘Landscape’ in the ‘Page Layout’ tab
b) By saving the document
c) By adjusting column width
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting ‘Portrait’ or ‘Landscape’ in the ‘Page Layout’ tab
Explanation: To change the orientation of printed pages, select ‘Portrait’ or ‘Landscape’ in the ‘Page Layout’ tab, adjusting how the worksheet is oriented on the printed page.
Q95. What does the ‘Text to Columns’ feature accomplish?
a) Splits the contents of a cell into multiple columns based on delimiters
b) Formats cells
c) Adjusts row height
d) Saves the document
Show Answer
Correct Answer: a) Splits the contents of a cell into multiple columns based on delimiters
Explanation: The ‘Text to Columns’ feature separates the content of a cell into multiple columns according to specified delimiters, which helps in organizing and analyzing data.
Q96. How can you quickly apply a specific format to multiple cells?
a) By using the ‘Format Painter’ tool
b) By saving the document
c) By adjusting row height
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Format Painter’ tool
Explanation: The ‘Format Painter’ tool copies the formatting from one cell and applies it to other selected cells, ensuring consistent formatting across multiple cells.
Q97. How do you remove a filter from a range of data?
a) By using the ‘Clear Filter’ option in the ‘Data’ tab
b) By saving the document
c) By changing the font style
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Clear Filter’ option in the ‘Data’ tab
Explanation: To remove a filter, use the ‘Clear Filter’ option in the ‘Data’ tab, which resets the filtered view and displays all data in the range.
Q98. How can you insert a hyperlink into a cell?
a) By using the ‘Insert Hyperlink’ option and specifying the URL or location
b) By saving the document
c) By adjusting row height
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Insert Hyperlink’ option and specifying the URL or location
Explanation: The ‘Insert Hyperlink’ option allows you to create clickable links within a cell, which can direct to a URL or another location within the worksheet.
Q99. What is the use of the ‘Formula Auditing’ tools?
a) To trace and evaluate formulas to ensure they work correctly
b) To format cells
c) To adjust column width
d) To save the document
Show Answer
Correct Answer: a) To trace and evaluate formulas to ensure they work correctly
Explanation: ‘Formula Auditing’ tools help trace and evaluate formulas, allowing you to detect errors and ensure that calculations are correct.
Q100. How do you hide or unhide rows or columns in a worksheet?
a) By selecting the rows or columns, right-clicking, and choosing ‘Hide’ or ‘Unhide’
b) By saving the document
c) By adjusting row height
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting the rows or columns, right-clicking, and choosing ‘Hide’ or ‘Unhide’
Explanation: To hide or unhide rows or columns, select them, right-click, and choose ‘Hide’ or ‘Unhide’ from the context menu, which allows you to control the visibility of data.