question Which Excel function is used to find the position of a specific item within a range

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 calculate the internal rate of return (IRR) of an investment?

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

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

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

A. Switch the rows and columns of a range of cells
B. Merge cells in a table
C. Summarize data using charts
D. Filter data based on specific criteria

In Excel, what does the term "Data Bars" refer to in conditional formatting?

A. Color gradients that represent the values in a range of cells
B. Bars displayed in a chart
C. Cell borders with specified colors
D. Font colors based on specified conditions

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 find the square root of a number?

A. -
B. =SQRT()
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 "Slicer" feature in Excel?

A. Filter PivotTable or PivotChart data visually
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 protect a worksheet or workbook with a password?

A. Worksheet Security
B. Workbook Lock
C. Excel Security
D. Password Protect

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise