question In Excel what does the function TEXT A1 MMMM do

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 "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 find the average of cells that meet multiple criteria?

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

In Excel, what does the term "Data Bars" refer to in conditional formatting?

A. Color gradients that represent the values in a range of cells
B. Bars displayed in a chart
C. Cell borders with specified colors
D. Font colors based on specified conditions

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

A. Filter PivotTable or PivotChart data by specific date ranges
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 internal rate of return (IRR) of an investment?

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

In Excel, what does the term "Consolidation" mean?

A. Combining data from multiple ranges into a single range
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