question In Excel what does the function ROUNDUP A1 0 do

In Excel, what does the term "Formula Bar" refer to?

A. The bar displaying the current cell address and content
B. The bar showing the sum of selected cells
C. A bar for entering only mathematical formulas
D. The bar displaying formatting options

In Excel, what does the function =SUBTOTAL(109, A1:A10) do?

A. Calculates the sum of values in the range A1:A10, excluding hidden rows
B. Counts the number of visible cells in the range A1:A10
C. Finds the average of visible cells in the range A1:A10
D. Multiplies visible cells in the range A1:A10

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

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

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

Which Excel feature is used to create a drop-down list in a cell?

A. Data Validation
B. Data Sorting
C. Data Filtering
D. Data Consolidation

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

Which Excel function is used to concatenate two or more text strings?

A. =CONCATENATE()
B. -
C. -
D. -

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

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

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

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise