question What is the purpose of the PivotTable feature in Excel

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

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 does the term "Cell Reference" mean in Microsoft Excel?

A. The address of a cell, such as A1 or B2
B. The content of a cell
C. A reference to an external workbook
D. The width and height of a cell

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

In Excel, which function is used to sum a range of cells?

A. =SUM()
B. =AVERAGE()
C. =COUNT()
D. =MAX()

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

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

Which Excel function is used to calculate the internal rate of return (IRR) of an investment?

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

Which function in Excel is used to find the highest value in a range of cells?

A. =MIN()
B. =AVERAGE()
C. =MAX()
D. =SUM()

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

What is the purpose of the "Merge & Center" option in Excel?

A. Combine selected cells into one and center the content
B. Change cell colors
C. Split cells into individual cells
D. Create a table with merged cells

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise