question In Excel what does the term Absolute Cell Reference mean

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 "Scenario Manager" feature in Excel?

A. Create and manage different scenarios for what-if analysis
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filtering data based on specific criteria

What is the purpose of the "Quick Analysis" feature in Excel?

A. Provides a quick analysis of selected data with various formatting and visualization options
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 "GetPivotData" function in Excel?

A. Retrieve data from a PivotTable based on specific criteria
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 future value (FV) of an investment?

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

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

What is the purpose of the "Data Validation" criteria "Whole number" in Excel?

A. Allows only whole numbers to be entered in a cell
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()

In Excel, what does the term "Workbook" refer to?

A. A collection of worksheets
B. A single sheet within a workbook
C. A formula used for calculations
D. The entire Excel application

In Excel, what does the term "Cell Range" mean?

A. A group of adjacent cells
B. The address of a cell, such as A1 or B2
C. The content of a cell
D. A reference to an external workbook

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise