question In Excel what does the term Data Bars refer to in conditional formatting

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

What is the purpose of the "Flash Fill" feature in Excel?

A. Automatically fill cells based on patterns recognized by Excel
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

In Excel, what does the function =TEXT(A1, "MMMM") do?

A. Returns the full month name from the date in cell A1
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 feature is used to create a drop-down list in a cell?

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

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

Which Excel function is used to find the rank of a number in a list?

A. =RANK()
B. =SORT()
C. -
D. -

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

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

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise