question Which Excel function is used to calculate the net present value NPV of an investment

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 concatenate two or more text strings?

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

In Excel, what does the function =COUNTA(A1:A10) do?

A. Counts the number of non-empty cells in 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

What is the purpose of the "Data Bars" feature in Excel?

A. Visualize the values in a range with colored bars in each cell
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

Which Excel function is used to calculate the cumulative interest paid on a loan between two periods?

A. =CUMIPMT()
B. =CUMPRINC()
C. -
D. =IPMT()

In Excel, what does the term "Formula Bar" refer to?

A. The bar displaying the current cell address and content
B. The bar showing the sum of selected cells
C. A bar for entering only mathematical formulas
D. The bar displaying formatting options

Which Excel function is used to count the number of cells that meet multiple criteria?

A. =COUNT()
B. =COUNTIF()
C. =COUNTIFS()
D. =COUNTA()

What is the purpose of the "Watch Window" feature in Excel?

A. Monitor the values in specific cells while working in a different part of the worksheet
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 "Data Validation" feature in Excel?

A. Control the type of data entered into a cell
B. Summarize data using charts
C. Filter data based on specific criteria
D. Merge cells in a table

Which Excel function is used to find the square root of a number?

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

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise