question In Excel what does the term Consolidation mean

In Excel, what does the function =SUMIFS(A1:A10, B1:B10, "Apples", C1:C10, ">100") do?

A. Adds values in the range A1:A10 based on multiple criteria in columns B and C
B. Counts the number of cells in the range A1:A10 based on a single criterion
C. Finds the average of values in the range A1:A10
D. Multiplies values in the range A1:A10 based on multiple criteria in columns B and C

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

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 "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

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 square root of a number?

A. -
B. =SQRT()
C. -
D. -

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

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

Which Excel function is used to concatenate two or more text strings?

A. =CONCATENATE()
B. -
C. -
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 "Named Range" feature in Excel?

A. Assigning a name to a specific range of cells
B. Changing the name of the entire worksheet
C. Sorting cells based on alphabetical order
D. Creating a table with named cells

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise