Q71. What does the “Data Validation” feature allow you to do?
a) Restrict the type of data or values that can be entered into a cell
b) Create charts based on selected data
c) Sort data in ascending or descending order
d) Automatically fill cells with data
Show Answer
Correct Answer: a) Restrict the type of data or values that can be entered into a cell
Explanation: Data Validation restricts user input to specific data types or values, helping to ensure data integrity and consistency.
Q72. What is the use of the “Find and Replace” feature in Excel?
a) To search for specific data and replace it with new data
b) To find errors in formulas
c) To locate and remove duplicates
d) To format cells based on specific criteria
Show Answer
Correct Answer: a) To search for specific data and replace it with new data
Explanation: The “Find and Replace” feature allows users to search for specific data and replace it with new data, streamlining data modification tasks.
Q73. How can you change the default font size for a workbook in Excel?
a) Use the “Font” settings in the “Home” tab
b) Modify the default template in Excel
c) Change the font size in the “Page Layout” tab
d) Adjust settings in the “File” menu under “Options”
Show Answer
Correct Answer: d) Adjust settings in the “File” menu under “Options”
Explanation: Changing the default font size for a workbook can be done by adjusting settings in the “File” menu under “Options,” where default workbook appearance settings are managed.
Q74. What is the “Paste Special” option used for?
a) To control how data is pasted, such as pasting only values or formats
b) To paste data with specific formatting only
c) To copy data from one sheet to another
d) To apply a special format to copied data
Show Answer
Correct Answer: a) To control how data is pasted, such as pasting only values or formats
Explanation: The “Paste Special” option provides various choices for pasting data with specific attributes, such as values only, formats, or formulas.
Q75. How can you create a chart from a range of data in Excel?
a) Select the data and use the “Insert Chart” option from the “Insert” tab
b) Right-click the data range and choose “Create Chart”
c) Use the “Chart Wizard” from the “Data” menu
d) Drag the data into the chart area
Show Answer
Correct Answer: a) Select the data and use the “Insert Chart” option from the “Insert” tab
Explanation: Selecting the data and choosing the “Insert Chart” option from the “Insert” tab allows users to create various types of charts to visualize data.
Q76. What does the “SERIES” option in a chart dialog box allow you to do?
a) Define data series for the chart
b) Add multiple chart types to a single chart
c) Series data in ascending order
d) Insert new data points into the chart
Show Answer
Correct Answer: a) Define data series for the chart
Explanation: The “SERIES” option in the chart dialog box allows users to define and configure the data series that will be represented in the chart.
Q77. What is the “Name Manager” used for in Excel?
a) To define and manage named ranges and formulas
b) To manage workbook security settings
c) To create new worksheets
d) To format named ranges with specific styles
Show Answer
Correct Answer: a) To define and manage named ranges and formulas
Explanation: The “Name Manager” helps users define, edit, and manage named ranges and formulas, providing a way to organize and reference data more effectively.
Q78. What does the “Cell Styles” feature in Excel allow you to do?
a) Apply predefined styles to cells for consistent formatting
b) Create custom styles for cells
c) Modify the style of entire rows or columns
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: The “Cell Styles” feature provides predefined styles for consistent formatting and allows users to create and apply custom styles to cells.
Q79. How do you adjust the width of a column in Excel?
a) Drag the boundary of the column header
b) Use the “Column Width” option from the “Format” menu
c) Right-click the column header and select “Resize”
d) Use the “AutoFit” option in the “Home” tab
Show Answer
Correct Answer: a) Drag the boundary of the column header
Explanation: Dragging the boundary of the column header adjusts the column width interactively, providing a quick way to resize columns.
Q80. What does the “Subtotal” function in Excel do?
a) Calculates subtotals for grouped data
b) Adds a total row to a table
c) Summarizes data using multiple criteria
d) Computes the difference between totals
Show Answer
Correct Answer: a) Calculates subtotals for grouped data
Explanation: The “Subtotal” function provides subtotals for groups of data within a range, helping to summarize and analyze data at different levels.