Q91. How can you use the “Hyperlink” feature in Excel?
a) To link to another worksheet, document, or webpage from a cell
b) To create a reference to a cell in a formula
c) To format text as a hyperlink
d) To display a list of links in a cell
Show Answer
Correct Answer: a) To link to another worksheet, document, or webpage from a cell
Explanation: The “Hyperlink” feature allows users to create clickable links in cells that direct to other worksheets, documents, or webpages.
Q92. What does the “Freeze Panes” feature do in Excel?
a) Keeps specific rows or columns visible while scrolling through the rest of the worksheet
b) Locks cells from being edited
c) Prevents cells from being formatted
d) Secures the worksheet with a password
Show Answer
Correct Answer: a) Keeps specific rows or columns visible while scrolling through the rest of the worksheet
Explanation: The “Freeze Panes” feature allows users to keep certain rows or columns visible while scrolling through large datasets, enhancing navigation.
Q93. Which of the following options is used to format a cell for date data?
a) Select “Date” from the Number format options in the Home tab
b) Use the “Text” format and manually enter date formats
c) Apply the “Custom” format and enter date patterns
d) Use the “General” format and type the date
Show Answer
Correct Answer: a) Select “Date” from the Number format options in the Home tab
Explanation: Selecting “Date” from the Number format options formats the cell to display dates in various predefined formats.
Q94. What is the purpose of the “Sort” feature in Excel?
a) To arrange data in a specific order, such as ascending or descending
b) To filter data based on criteria
c) To highlight cells with certain values
d) To create a summary of data
Show Answer
Correct Answer: a) To arrange data in a specific order, such as ascending or descending
Explanation: The “Sort” feature organizes data in a specified order, either ascending or descending, to make data analysis and review easier.
Q95. What is a “Relative Reference” in Excel formulas?
a) A reference that adjusts automatically when copied to another cell
b) A reference that remains constant regardless of where the formula is copied
c) A reference to a specific cell that does not change
d) A reference to a range of cells that automatically updates
Show Answer
Correct Answer: a) A reference that adjusts automatically when copied to another cell
Explanation: A relative reference changes when the formula is copied to different cells, adjusting the reference according to the new location.
Q96. What is an “Absolute Reference” in Excel formulas?
a) A reference that remains constant and does not change when copied to other cells
b) A reference that adjusts automatically when copied
c) A reference to the last cell in a range
d) A reference that updates based on formula results
Show Answer
Correct Answer: a) A reference that remains constant and does not change when copied to other cells
Explanation: An absolute reference is fixed and does not change when the formula is copied to other cells, maintaining a constant reference.
Q97. What does the “Quick Analysis” tool in Excel help with?
a) Provides fast access to various analysis tools like formatting, charts, and totals
b) Creates complex formulas for data analysis
c) Automates data entry tasks
d) Generates reports based on selected data
Show Answer
Correct Answer: a) Provides fast access to various analysis tools like formatting, charts, and totals
Explanation: The “Quick Analysis” tool offers a convenient way to access and apply analysis options such as formatting, charts, and totals to selected data.
Q98. How can you create a drop-down list in a cell using “Data Validation”?
a) Use the “List” option in the Data Validation dialog box
b) Apply the “Drop-Down” format from the “Home” tab
c) Use the “Insert” menu to create a list
d) Create a named range and use it in the cell
Show Answer
Correct Answer: a) Use the “List” option in the Data Validation dialog box
Explanation: The “List” option in the Data Validation dialog box allows users to create a drop-down list in a cell, providing predefined choices for data entry.
Q99. What is the “Goal Seek” feature used for in Excel?
a) To find the input value needed to achieve a desired result in a formula
b) To adjust cell formatting to meet specific criteria
c) To summarize data based on given conditions
d) To generate random numbers for testing
Show Answer
Correct Answer: a) To find the input value needed to achieve a desired result in a formula
Explanation: The “Goal Seek” feature helps users determine the required input value to achieve a specific result from a formula, assisting in problem-solving and planning.
Q100. What is the primary use of the “Data Table” feature in Excel?
a) To perform sensitivity analysis by varying one or two input values and observing results
b) To create a structured table for data management
c) To summarize data using pivot tables
d) To format data as a table with predefined styles
Show Answer
Correct Answer: a) To perform sensitivity analysis by varying one or two input values and observing results
Explanation: The “Data Table” feature is used for sensitivity analysis, allowing users to analyze how changes in input values affect formula results by displaying varying scenarios.