Q81. What is the purpose of the “Data Consolidation” feature in Excel?
a) To combine data from multiple ranges or worksheets into a single summary
b) To sort and filter data based on specific criteria
c) To create a pivot table from multiple datasets
d) To consolidate duplicate data into a single entry
Show Answer
Correct Answer: a) To combine data from multiple ranges or worksheets into a single summary
Explanation: The “Data Consolidation” feature aggregates data from multiple ranges or worksheets into a single summary, useful for combining related datasets.
Q82. How do you use the “VLOOKUP” function in Excel?
a) To search for a value in the first column of a range and return a value from a specified column
b) To find the highest value in a range
c) To search for a value in the last row of a range
d) To calculate the vertical sum of data in a range
Show Answer
Correct Answer: a) To search for a value in the first column of a range and return a value from a specified column
Explanation: The VLOOKUP function searches for a value in the first column of a range and retrieves a value from a specified column in the same row.
Q83. What does the “Find” feature in Excel allow you to do?
a) Locate specific data within a worksheet
b) Replace specific data with new values
c) Format cells with particular criteria
d) Calculate and summarize data
Show Answer
Correct Answer: a) Locate specific data within a worksheet
Explanation: The “Find” feature helps users locate specific data within a worksheet, making it easier to navigate and manage large datasets.
Q84. Which function would you use to return the current date in Excel?
a) TODAY()
b) DATE()
c) NOW()
d) CURRENTDATE()
Show Answer
Correct Answer: a) TODAY()
Explanation: The TODAY() function returns the current date based on the system date, useful for time-stamping or date calculations.
Q85. How can you apply conditional formatting to highlight cells based on a value?
a) Use the “Conditional Formatting” option in the Home tab
b) Right-click the cell and select “Format Cells”
c) Use the “Cell Styles” option from the “Home” tab
d) Use the “Data Validation” feature
Show Answer
Correct Answer: a) Use the “Conditional Formatting” option in the Home tab
Explanation: Conditional Formatting in the Home tab allows users to apply formatting rules to highlight cells based on specific conditions or values.
Q86. What does the “Text to Columns” feature do in Excel?
a) Splits the contents of a cell into multiple columns based on a delimiter
b) Merges multiple columns into one column
c) Converts text into a numeric value
d) Aligns text in cells across columns
Show Answer
Correct Answer: a) Splits the contents of a cell into multiple columns based on a delimiter
Explanation: The “Text to Columns” feature separates text in a cell into multiple columns based on delimiters or fixed widths, useful for data extraction and organization.
Q87. How do you display formulas in Excel instead of their results?
a) Press Ctrl + ` (grave accent)
b) Use the “Show Formulas” option in the “Formulas” tab
c) Right-click the cell and select “Show Formulas”
d) Use the “Formula Auditing” tool
Show Answer
Correct Answer: a) Press Ctrl + (grave accent) **Explanation:** Pressing Ctrl + (grave accent) toggles the display of formulas in the worksheet instead of their calculated results, useful for auditing formulas.
Q88. What is the use of the “IFERROR” function in Excel?
a) To handle errors in formulas by returning a specified value if an error occurs
b) To find errors in the formula syntax
c) To check if a formula returns an error
d) To correct errors in a range of cells
Show Answer
Correct Answer: a) To handle errors in formulas by returning a specified value if an error occurs
Explanation: The IFERROR function allows users to specify an alternative value to return if a formula results in an error, improving error handling in formulas.
Q89. How do you create a named range in Excel?
a) Select the range and type a name in the Name Box
b) Use the “Create Named Range” option in the “Formulas” tab
c) Right-click the range and select “Define Name”
d) Use the “Name Manager” to create a new name
Show Answer
Correct Answer: a) Select the range and type a name in the Name Box
Explanation: Typing a name into the Name Box and pressing Enter creates a named range for the selected cells, making it easier to reference specific data.
Q90. What does the “Chart Title” feature in Excel allow you to do?
a) Add a title to the chart to describe its content
b) Change the color of chart elements
c) Resize the chart area
d) Adjust the axis labels
Show Answer
Correct Answer: a) Add a title to the chart to describe its content
Explanation: The “Chart Title” feature allows users to add a descriptive title to the chart, providing context and clarity for the data presented.