question What does the term Workbook Linking mean in Excel

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

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

In Excel, what does the function =IF(A1>10, "Yes", "No") do?

A. Returns "Yes" if the value in A1 is greater than 10; otherwise, returns "No"
B. Adds the values in A1 and 10
C. Finds the square root of the value in A1
D. Multiplies the value in A1 by 10

Which Excel feature allows you to freeze rows and columns so they remain visible while scrolling through a large worksheet?

A. Freeze Panes
B. Split Cells
C. Lock Cells
D. Hide Rows

Which Excel function is used to find the average of cells that meet multiple criteria?

A. =AVERAGE()
B. =AVERAGEIF()
C. =AVERAGEIFS()
D. -

Which Excel feature is used to automatically adjust the width of a column based on its content?

A. AutoFit Column
B. Auto Column Width
C. Resize Column
D. Adjust Content Width

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

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

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

Which Excel function is used to calculate the internal rate of return (IRR) of an investment?

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

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

A. Combine multiple tables into a single table for analysis
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 "Timeline" feature in Excel?

A. Filter PivotTable or PivotChart data by specific date ranges
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise