question What does the term Workbook Themes refer to in Excel

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

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

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 keyboard shortcut for creating a new workbook in Microsoft Excel?

A. CTRL + N
B. CTRL + W
C. CTRL + A
D. CTRL + S

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 "Format Cells" dialog box in Excel?

A. Adjusting the formatting of selected cells, including number format, font, and alignment
B. Merging cells in a table
C. Summarizing data using charts
D. Changing the color scheme of the entire workbook

Which Excel function is used to calculate the internal rate of return for a series of cash flows?

A. =IRR()
B. =NPV()
C. -
D. =RATE()

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

Which Excel function is used to calculate the present value (PV) of an investment?

A. -
B. =NPV()
C. =IRR()
D. =PV()

Which Excel function is used to find the position of an item in a range?

A. -
B. =SEARCH()
C. =FIND()
D. =MATCH()

What is the purpose of the "Excel Table" feature?

A. A structured range of data that can be easily filtered, sorted, and analyzed
B. Summarizing data using charts
C. Merging cells in a table
D. Filtering data based on specific criteria

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise