Q51. To highlight cells that contain a value greater than 100, you would use:
a) Conditional Formatting
b) Find and Replace
c) Data Validation
d) Filter
Show Answer
Correct Answer: a) Conditional Formatting
Explanation: Conditional Formatting allows users to apply specific formatting to cells that meet certain criteria, such as highlighting cells with values greater than 100.
Q52. How can you quickly select an entire column in Excel?
a) Click the column header
b) Press Ctrl + A
c) Drag across the column cells
d) Right-click and choose “Select Column”
Show Answer
Correct Answer: a) Click the column header
Explanation: Clicking the column header selects the entire column, allowing for easy formatting or data manipulation.
Q53. What is the purpose of the “Subtotal” feature in Excel?
a) To summarize data by creating subtotals within groups of data
b) To calculate the total sum of a range
c) To create a total row in a table
d) To group data into subcategories
Show Answer
Correct Answer: a) To summarize data by creating subtotals within groups of data
Explanation: The “Subtotal” feature calculates and displays subtotals for different groups within a dataset, providing a summary of data at various levels.
Q54. What does the “Page Layout” tab in Excel allow you to adjust?
a) Printing options, including margins, orientation, and size
b) Data sorting and filtering options
c) Cell formatting and styles
d) Formula calculations
Show Answer
Correct Answer: a) Printing options, including margins, orientation, and size
Explanation: The “Page Layout” tab provides options for adjusting printing settings, such as margins, page orientation, and paper size, to control how the spreadsheet is printed.
Q55. How can you quickly add a new worksheet to an existing workbook?
a) Click the “+” icon next to the sheet tabs
b) Use the “Add Worksheet” button in the “File” menu
c) Right-click a sheet tab and select “Insert Sheet”
d) Press Ctrl + N
Show Answer
Correct Answer: a) Click the “+” icon next to the sheet tabs
Explanation: Clicking the “+” icon next to the existing sheet tabs adds a new worksheet to the workbook, allowing for easy expansion of the workbook.
Q56. What does the “Group” feature do in Excel?
a) Groups rows or columns together for easier management and analysis
b) Merges multiple cells into a single cell
c) Combines different sheets into a single workbook
d) Sorts data in a group format
Show Answer
Correct Answer: a) Groups rows or columns together for easier management and analysis
Explanation: The “Group” feature allows users to group rows or columns, making it easier to manage and analyze large datasets by collapsing or expanding grouped sections.
Q57. How do you apply a filter to a column in Excel?
a) Click the filter icon in the column header
b) Use the “Filter” option in the “Data” tab
c) Right-click the column and select “Apply Filter”
d) Drag the column to the “Filter” area
Show Answer
Correct Answer: b) Use the “Filter” option in the “Data” tab
Explanation: The “Filter” option in the “Data” tab allows users to apply filters to columns, making it possible to display only the rows that meet specific criteria.
Q58. Which of the following functions calculates the total number of cells that contain data in a range?
a) COUNT()
b) COUNTA()
c) SUM()
d) AVERAGE()
Show Answer
Correct Answer: b) COUNTA()
Explanation: The COUNTA() function counts the number of cells that contain any type of data (text, numbers, etc.) in a specified range.
Q59. What does the “Protect Workbook” feature do?
a) Protects the entire workbook from being edited
b) Hides specific worksheets in the workbook
c) Locks individual cells from editing
d) Encrypts the workbook with a password
Show Answer
Correct Answer: a) Protects the entire workbook from being edited
Explanation: The “Protect Workbook” feature restricts editing across the entire workbook, helping to prevent unauthorized modifications.
Q60. What is the “Transpose” feature used for in Excel?
a) To switch rows and columns in a selected range
b) To change the orientation of the page
c) To move data from one cell to another
d) To format data in a vertical layout
Show Answer
Correct Answer: a) To switch rows and columns in a selected range
Explanation: The “Transpose” feature allows users to switch the orientation of data from rows to columns or vice versa, useful for rearranging data layouts.