question Which Excel feature is used to create a drop down list in a cell

In Excel, what does the function =INDEX(A1:A10, 3) do?

A. Returns the value in the third cell of the range A1:A10
B. Adds the values in the range A1:A10
C. Finds the average of the range A1:A10
D. Rounds the value in cell A1 to the nearest whole number

Which Excel function is used to find the rank of a value within a range?

A. =RANK()
B. =SORT()
C. =INDEX()
D. -

What is the purpose of the "Scenario Manager" feature in Excel?

A. Create and compare different sets of input values to see the resulting outcomes
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

What is the purpose of the "Outline" feature in Excel?

A. Group and organize data by creating an outline structure
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

What is the purpose of the "Data Consolidation" feature in Excel?

A. Combine data from multiple ranges into a single range
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

What is the purpose of the "Text to Columns" feature in Excel?

A. Splitting text into separate columns based on a delimiter
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

What is the purpose of the "Error Checking" feature in Excel?

A. Identify and correct errors in formulas
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

Which Excel function is used to find the position of a specific item within a range?

A. =MATCH()
B. =INDEX()
C. =SEARCH()
D. =LOOKUP()

Which Excel function is used to find the position of an item in a range?

A. -
B. =SEARCH()
C. =FIND()
D. =MATCH()

What is the purpose of the "Data Bars" feature in Excel?

A. Visualize the values in a range with colored bars in each cell
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise