question What is the purpose of the Outline feature in Excel

Which Excel function is used to find the average of cells that meet multiple criteria?

A. =AVERAGE()
B. =AVERAGEIF()
C. =AVERAGEIFS()
D. -

What is the purpose of the "Fill Handle" in Excel?

A. Quickly fill cells with a series or copy cell contents
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Adjusting column widths

In Excel, what does the function =SUBTOTAL(109, A1:A10) do?

A. Calculates the sum of values in the range A1:A10, excluding hidden rows
B. Counts the number of visible cells in the range A1:A10
C. Finds the average of visible cells in the range A1:A10
D. Multiplies visible cells in the range A1:A10

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

A. Data Validation
B. Data Sorting
C. Data Filtering
D. Data Consolidation

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

A. Identify and correct errors in formulas or functions
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 "Get & Transform" feature in Excel?

A. Import, transform, and combine data from various sources
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

Which Excel function is used to return the current date and time?

A. 45296.041864
B. 45296
C. =DATE()
D. =TIME()

In Excel, what does the term "Circular Reference" mean?

A. A situation where a formula refers to its own cell
B. Summarizing data using charts
C. Merging cells in a table
D. Filtering data based on specific criteria

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

A. Filter PivotTable or PivotChart data visually
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

Which Excel function is used to calculate the net present value (NPV) of an investment?

A. -
B. =NPV()
C. =IRR()
D. =PV()

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise