question Which Excel function is used to calculate the future value FV of an investment

Which Excel feature is used to filter data based on specific criteria?

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

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

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

A. Summarize and analyze data from a range of cells
B. Merge cells in a table
C. Create a table with dynamic data
D. Filter data based on specific criteria

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

In Excel, what does the function =ROUND(A1, 2) do?

A. Rounds the value in cell A1 to 2 decimal places
B. Adds the values in cell A1 and 2
C. Finds the square root of the value in cell A1
D. Multiplies the value in cell A1 by 2

Which Excel feature is used to create a visual representation of data using bars, lines, or pie slices?

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

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

What is the purpose of the "IF" function in Excel?

A. Perform conditional logic based on a specified condition
B. Add values in a range of cells
C. Find the average of a range of cells
D. Count the number of cells in a range

Which Excel function is used to return the current date and time?

A. 45296.041864
B. 45296
C. =DATE()
D. =TIME()

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise