question In Excel what does the function SUBTOTAL 109 A1 A10 do

In Excel, which function is used to sum a range of cells?

A. =SUM()
B. =AVERAGE()
C. =COUNT()
D. =MAX()

Which function in Excel is used to find the highest value in a range of cells?

A. =MIN()
B. =AVERAGE()
C. =MAX()
D. =SUM()

What is the purpose of the "Solver" feature in Excel?

A. Find optimal solutions to complex problems by adjusting variables
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 "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 "Watch Window" feature in Excel?

A. Monitor the values of specific cells while working with other parts of the workbook
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 term "Workbook Views" refer to?

A. Different ways to display a workbook, such as Normal, Page Layout, and Page Break Preview
B. Viewing multiple workbooks simultaneously
C. Changing the color scheme of the workbook
D. Zooming in and out of the entire workbook

What does the term "Cell Reference" mean in Microsoft Excel?

A. The address of a cell, such as A1 or B2
B. The content of a cell
C. A reference to an external workbook
D. The width and height of a cell

What does the term "Data Validation" mean in Excel?

A. Controlling the type of data entered into a cell
B. Summarizing data using charts
C. Filtering data based on specific criteria
D. Merging cells in a table

Which Excel function is used to count the number of cells that meet a specific condition?

A. =COUNTIF()
B. =SUMIF()
C. =AVERAGEIF()
D. -

Which Excel function is used to find the number of characters in a text string?

A. =LEN()
B. =COUNT()
C. =CHAR()
D. =TEXT()

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise