question In Excel what does the function ROUND A1 2 do

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

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

What is the purpose of the "Fill Handle" in Excel?

A. Quickly fill cells with a series or copy cell contents
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Adjusting column widths

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

A. Calculate subtotals for a range of data, grouping by specified criteria
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 "Outline" feature in Excel?

A. Group and organize rows or columns with a hierarchical structure
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

What does the term "Workbook Themes" refer to in Excel?

A. Sets of formatting options applied to an entire workbook
B. Styles applied to individual cells
C. A collection of worksheet templates
D. The color scheme of the Excel application

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise