Q21. How do you apply a predefined style to a cell?
a) Use the ‘Cell Styles’ option from the Home tab
b) Manually format the cell using the toolbar
c) Apply a custom color scheme
d) Use the ‘Fill Color’ button
Show Answer
Correct Answer: a) Use the ‘Cell Styles’ option from the Home tab
Explanation: The ‘Cell Styles’ option from the Home tab allows you to apply predefined styles to a cell, including fonts, colors, and borders.
Q22. What does the ‘AutoSum’ function do?
a) Automatically calculates the total of a selected range
b) Automatically fills in missing data
c) Automatically sorts data in ascending order
d) Automatically formats cells based on data
Show Answer
Correct Answer: a) Automatically calculates the total of a selected range
Explanation: The ‘AutoSum’ function automatically calculates the total of a selected range of numbers, providing a quick way to sum up values.
Q23. What is the purpose of the ‘Filter’ feature in a spreadsheet?
a) To display only specific data that meets certain criteria
b) To sort data in ascending order
c) To remove duplicate entries
d) To format cells with conditional formatting
Show Answer
Correct Answer: a) To display only specific data that meets certain criteria
Explanation: The ‘Filter’ feature allows you to display only specific data that meets certain criteria, making it easier to view and analyze subsets of data.
Q24. How can you merge cells in a spreadsheet?
a) Select the cells, right-click, and choose ‘Merge Cells’
b) Use the ‘Merge & Center’ option from the Home tab
c) Drag the cells to combine them
d) Use the ‘Group’ option from the Data menu
Show Answer
Correct Answer: b) Use the ‘Merge & Center’ option from the Home tab
Explanation: To merge cells, select the cells and use the ‘Merge & Center’ option from the Home tab, which combines selected cells into a single cell.
Q25. How do you insert a chart into a spreadsheet?
a) Use the ‘Insert Chart’ option from the Insert tab
b) Copy and paste a chart from another document
c) Draw the chart manually using shapes
d) Use the ‘Add Chart’ option from the View tab
Show Answer
Correct Answer: a) Use the ‘Insert Chart’ option from the Insert tab
Explanation: To insert a chart, use the ‘Insert Chart’ option from the Insert tab, which provides various chart types to visualize data.
Q26. How can you quickly adjust the height of multiple rows?
a) Select the rows, right-click, and choose ‘Row Height’
b) Drag the boundary of one row and all selected rows will adjust
c) Use the ‘Resize Rows’ option from the Format menu
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: To quickly adjust the height of multiple rows, select the rows, right-click and choose ‘Row Height,’ or drag the boundary of one row to adjust all selected rows.
Q27. What function would you use to find the average value in a range of cells?
a) AVERAGE
b) SUM
c) MAX
d) MIN
Show Answer
Correct Answer: a) AVERAGE
Explanation: The ‘AVERAGE’ function calculates the average value of a range of cells by summing the values and dividing by the number of cells.
Q28. How do you apply conditional formatting to a cell?
a) Use the ‘Conditional Formatting’ option from the Home tab
b) Manually format the cell based on conditions
c) Use the ‘Format Cells’ dialog box
d) Apply a predefined cell style
Show Answer
Correct Answer: a) Use the ‘Conditional Formatting’ option from the Home tab
Explanation: To apply conditional formatting, use the ‘Conditional Formatting’ option from the Home tab, which allows you to format cells based on specific conditions.
Q29. How can you quickly copy formatting from one cell to another?
a) Use the ‘Format Painter’ tool
b) Use the ‘Copy Formatting’ option from the Format menu
c) Manually apply the same formatting
d) Use the ‘Paste Special’ option
Show Answer
Correct Answer: a) Use the ‘Format Painter’ tool
Explanation: The ‘Format Painter’ tool allows you to quickly copy formatting from one cell and apply it to another cell, making it easy to maintain consistent formatting.
Q30. What is the function of the ‘VLOOKUP’ function in a spreadsheet?
a) Searches for a value in the first column of a table and returns a value in the same row from a specified column
b) Counts the number of cells that contain a specific value
c) Adds up values in a specified range
d) Finds the maximum value in a range of cells
Show Answer
Correct Answer: a) Searches for a value in the first column of a table and returns a value in the same row from a specified column
Explanation: The ‘VLOOKUP’ function searches for a value in the first column of a table and returns a value from the same row in a specified column, useful for looking up data.