Q71. How can you quickly find and replace specific text in a spreadsheet?
a) By using the ‘Find and Replace’ feature
b) By saving the document
c) By adjusting column width
d) By inserting a new row
Show Answer
Correct Answer: a) By using the ‘Find and Replace’ feature
Explanation: The ‘Find and Replace’ feature allows you to quickly locate specific text or values and replace them with new content, streamlining data editing tasks.
Q72. What does the ‘Paste Special’ option allow you to do?
a) Paste data with specific attributes like values only, formatting, or formulas
b) Copy data from one cell to another
c) Cut data from a selected cell
d) Delete data from a cell
Show Answer
Correct Answer: a) Paste data with specific attributes like values only, formatting, or formulas
Explanation: ‘Paste Special’ lets you paste data with chosen attributes, such as values only or formats, providing more control over what is pasted into cells.
Q73. How do you add a border to a cell?
a) By using the ‘Borders’ option 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 ‘Borders’ option in the formatting toolbar
Explanation: To add a border to a cell, use the ‘Borders’ option in the formatting toolbar, which lets you apply borders around and within cells for better data visibility.
Q74. What is the purpose of the ‘Text to Columns’ feature?
a) To split the contents of a cell into multiple columns based on delimiters
b) To format cells
c) To adjust row height
d) To save the document
Show Answer
Correct Answer: a) To split the contents of a cell into multiple columns based on delimiters
Explanation: The ‘Text to Columns’ feature splits cell contents into multiple columns based on specified delimiters, such as commas or spaces, facilitating data organization.
Q75. How can you apply conditional formatting to highlight cells based on their values?
a) By using ‘Conditional Formatting’ and setting rules based on cell values
b) By saving the document
c) By changing the font size
d) By inserting a new row
Show Answer
Correct Answer: a) By using ‘Conditional Formatting’ and setting rules based on cell values
Explanation: ‘Conditional Formatting’ allows you to set rules that highlight cells based on their values, making it easier to visualize trends and important data points.
Q76. How can you adjust the width of multiple columns at once?
a) By selecting the columns and dragging the boundary of any selected column header
b) By saving the document
c) By changing the cell color
d) By inserting a new row
Show Answer
Correct Answer: a) By selecting the columns and dragging the boundary of any selected column header
Explanation: To adjust the width of multiple columns, select the columns and drag the boundary of any selected column header, which changes the width for all selected columns simultaneously.
Q77. How do you use the ‘Fill Handle’ to copy data or extend a series?
a) By dragging the small square at the bottom-right corner of the selected cell
b) By saving the document
c) By changing the font style
d) By inserting a new row
Show Answer
Correct Answer: a) By dragging the small square at the bottom-right corner of the selected cell
Explanation: The ‘Fill Handle’ is the small square at the bottom-right corner of a cell. Dragging it copies the cell’s data or extends a series across adjacent cells.
Q78. What does the ‘Page Layout’ tab allow you to modify?
a) The appearance and settings for printing the worksheet, such as margins and orientation
b) The cell formatting
c) The row height
d) The formula settings
Show Answer
Correct Answer: a) The appearance and settings for printing the worksheet, such as margins and orientation
Explanation: The ‘Page Layout’ tab lets you adjust printing settings, including margins, orientation, and paper size, to format how the worksheet appears when printed.
Q79. How can you remove gridlines from a worksheet?
a) By unchecking the ‘Gridlines’ option in the ‘View’ tab
b) By saving the document
c) By adjusting column width
d) By inserting a new row
Show Answer
Correct Answer: a) By unchecking the ‘Gridlines’ option in the ‘View’ tab
Explanation: To remove gridlines from a worksheet, uncheck the ‘Gridlines’ option in the ‘View’ tab, which hides the lines that separate cells for a cleaner appearance.
Q80. How can you protect a specific range of cells from being edited?
a) By using the ‘Protect Sheet’ option and setting cell-specific protection
b) By formatting cells
c) By adjusting row height
d) By saving the document
Show Answer
Correct Answer: a) By using the ‘Protect Sheet’ option and setting cell-specific protection
Explanation: The ‘Protect Sheet’ option allows you to specify which cells are protected from editing, ensuring that only designated cells can be modified.