Q21. How do you adjust the height of a row in Excel?
a) Right-click the row number and choose “Row Height”
b) Drag the boundary below the row number
c) Use the “Row Height” option from the “Format” menu
d) Double-click the row number
Show Answer
Correct Answer: b) Drag the boundary below the row number
Explanation: To adjust the height of a row, you can drag the boundary below the row number to resize it manually.
Q22. What does the “Wrap Text” feature do in a cell?
a) Aligns text to the center of the cell
b) Ensures text stays within the cell boundary by displaying it on multiple lines
c) Changes the font color to wrap text
d) Expands the cell width to fit the text
Show Answer
Correct Answer: b) Ensures text stays within the cell boundary by displaying it on multiple lines
Explanation: The “Wrap Text” feature adjusts the cell’s content to fit within the cell’s width by displaying text on multiple lines within the same cell.
Q23. Which function would you use to find the highest value in a range of cells?
a) MIN()
b) MAX()
c) AVERAGE()
d) SUM()
Show Answer
Correct Answer: b) MAX()
Explanation: The MAX() function returns the highest value from a specified range of cells, providing the maximum value within that range.
Q24. To create a new worksheet within an existing workbook, you should:
a) Click the “New Sheet” button next to the existing sheet tabs
b) Use the “Insert Worksheet” option from the “File” menu
c) Right-click on a sheet tab and select “Add New Sheet”
d) Use the “Add” button on the toolbar
Show Answer
Correct Answer: a) Click the “New Sheet” button next to the existing sheet tabs
Explanation: Clicking the “New Sheet” button, typically represented by a “+” sign next to existing sheet tabs, adds a new worksheet to the workbook.
Q25. What does the “Fill Handle” do in Excel?
a) Formats cells with colors
b) Quickly copies data or fills a series across cells
c) Adjusts the font size of text in cells
d) Creates a chart from selected data
Show Answer
Correct Answer: b) Quickly copies data or fills a series across cells
Explanation: The “Fill Handle,” a small square at the bottom-right corner of a selected cell, is used to drag and copy data or fill a series (like numbers or dates) across adjacent cells.
Q26. Which of the following would you use to visually represent the relationship between two variables?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Scatter Plot
Show Answer
Correct Answer: d) Scatter Plot
Explanation: A Scatter Plot is ideal for visualizing the relationship between two variables by plotting data points on a graph with an X and Y axis.
Q27. How can you change the color of a cell’s background in Excel?
a) Use the “Fill Color” option in the Home tab
b) Right-click the cell and select “Format Cells”
c) Use the “Change Color” button on the toolbar
d) Drag and drop color from the color palette
Show Answer
Correct Answer: a) Use the “Fill Color” option in the Home tab
Explanation: The “Fill Color” option in the Home tab allows users to change the background color of a selected cell or range of cells.
Q28. To protect your spreadsheet from unauthorized changes, you should:
a) Use the “Protect Sheet” option
b) Save the file with a password
c) Hide all cells
d) Lock the workbook with a password
Show Answer
Correct Answer: a) Use the “Protect Sheet” option
Explanation: The “Protect Sheet” option enables users to restrict editing capabilities on a specific sheet, preventing unauthorized changes while allowing for other functionalities to remain accessible.
Q29. What does the “Conditional Formatting” feature allow you to do?
a) Format cells based on their content
b) Automatically format new data entries
c) Lock cells to prevent changes
d) Adjust column widths automatically
Show Answer
Correct Answer: a) Format cells based on their content
Explanation: Conditional Formatting allows users to apply different formatting to cells based on specific conditions or criteria, such as changing the cell color if a value exceeds a certain number.
Q30. How can you remove a specific row from a spreadsheet?
a) Select the row and press “Delete”
b) Right-click the row number and choose “Remove”
c) Use the “Clear” option from the “Edit” menu
d) Drag the row number to the trash bin
Show Answer
Correct Answer: a) Select the row and press “Delete”
Explanation: Selecting the row and pressing “Delete” removes the entire row from the spreadsheet, clearing all data within it.