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

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

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

What is the purpose of the "Flash Fill" feature in Excel?

A. Automatically fill cells based on patterns recognized by Excel
B. Summarize and analyze data from a range of cells
C. Merging cells in a table
D. Filter data based on specific criteria

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

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

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

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

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

Which Excel function is used to return the current date and time?

A. 45296.041864
B. 45296
C. =DATE()
D. =TIME()

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 function in Excel is used to find the highest value in a range of cells?

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

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise