Q41. How do you add a comment to a cell in Excel?
a) Right-click the cell and select “Insert Comment”
b) Use the “Comment” button on the toolbar
c) Press Ctrl + M
d) Use the “Review” tab and select “New Comment”
Show Answer
Correct Answer: a) Right-click the cell and select “Insert Comment”
Explanation: Right-clicking on a cell and selecting “Insert Comment” allows you to add a note or comment to that cell, which can be used for additional information or clarification.
Q42. What does the “Goal Seek” feature do in Excel?
a) Finds the input value needed to achieve a specific result in a formula
b) Calculates the average of a set of data
c) Identifies errors in formulas
d) Creates a new worksheet based on a template
Show Answer
Correct Answer: a) Finds the input value needed to achieve a specific result in a formula
Explanation: The “Goal Seek” feature allows users to determine the necessary input value for a formula to reach a desired result, useful for solving equations and optimization problems.
Q43. What is the primary function of the “Pivot Table” feature in Excel?
a) To summarize and analyze large amounts of data by organizing it into a table format
b) To sort data in ascending or descending order
c) To create graphical representations of data
d) To format cells with specific styles
Show Answer
Correct Answer: a) To summarize and analyze large amounts of data by organizing it into a table format
Explanation: Pivot Tables are used to summarize, analyze, and present large datasets in a table format, allowing users to rearrange and aggregate data dynamically.
Q44. What does the “TEXT” function in Excel do?
a) Converts numeric values to text format
b) Formats text based on specified criteria
c) Concatenates multiple text strings
d) Searches for specific text within a range
Show Answer
Correct Answer: a) Converts numeric values to text format
Explanation: The TEXT function converts numeric values into text format according to a specified format, useful for formatting numbers as dates, currencies, or other textual representations.
Q45. Which of the following functions calculates the number of cells that contain numeric values in a range?
a) COUNTA()
b) COUNT()
c) SUM()
d) AVERAGE()
Show Answer
Correct Answer: b) COUNT()
Explanation: The COUNT() function counts the number of cells containing numeric values within a specified range, excluding text and empty cells.
Q46. How can you quickly format a cell with a number as currency in Excel?
a) Use the “Currency” format option from the Number format dropdown in the Home tab
b) Right-click the cell and select “Format Cells” then choose “Currency”
c) Press Ctrl + Shift + $
d) Both a and b
Show Answer
Correct Answer: d) Both a and b
Explanation: Both selecting the “Currency” format from the Number format dropdown and using the “Format Cells” dialog allow users to format numbers as currency. The Ctrl + Shift + $ shortcut also applies currency formatting.
Q47. What does the “Name Box” in Excel display?
a) The name of the currently selected worksheet
b) The address of the active cell
c) The name of the workbook
d) The title of the chart
Show Answer
Correct Answer: b) The address of the active cell
Explanation: The Name Box displays the address of the currently active cell or range of cells, allowing users to quickly see the cell reference.
Q48. What does the “Remove Duplicates” feature do in Excel?
a) Deletes duplicate rows or values from a selected range
b) Removes formatting from duplicated cells
c) Clears cells with duplicate formulas
d) Highlights duplicate entries in a range
Show Answer
Correct Answer: a) Deletes duplicate rows or values from a selected range
Explanation: The “Remove Duplicates” feature identifies and deletes duplicate rows or values within a specified range, helping to clean and streamline data.
Q49. How do you create a drop-down list in a cell?
a) Use the “Data Validation” feature and select “List”
b) Enter a list of values manually
c) Use the “Drop-Down List” button in the toolbar
d) Create a table and select “Drop-Down”
Show Answer
Correct Answer: a) Use the “Data Validation” feature and select “List”
Explanation: The “Data Validation” feature with the “List” option allows users to create a drop-down list in a cell, providing a predefined set of options to choose from.
Q50. What is the function of the “Find” feature in Excel?
a) To search for specific data within a worksheet
b) To replace data with new values
c) To format cells based on criteria
d) To create a new worksheet
Show Answer
Correct Answer: a) To search for specific data within a worksheet
Explanation: The “Find” feature searches for specific text or values within a worksheet, making it easier to locate data quickly.