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

What does the term "Conditional Formatting" mean in Excel?

A. Formatting cells based on specific conditions
B. Formatting cells with random styles
C. Applying formatting to an entire worksheet
D. Formatting cells with a fixed style

What is the purpose of the "Error Checking" feature in Excel?

A. Identify and correct errors in formulas or functions
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

In Excel, what does the term "Data Series" refer to in a chart?

A. A group of related data points
B. The data displayed on the horizontal axis
C. The legend of the chart
D. The title of the chart

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

In Excel, what does the function =ROUNDUP(A1, 0) do?

A. Rounds the value in cell A1 up to the nearest whole number
B. Rounds the value in cell A1 down to the nearest whole number
C. Adds the values in cell A1 and 0
D. Finds the square root of the value in cell A1

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 term "Consolidation" mean?

A. Combining data from multiple ranges into a single range
B. Summarize and analyze data from a range of cells
C. Merge cells in a table
D. Filter data based on specific criteria

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

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 find the average of cells that meet multiple criteria?

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

Microsoft Excel MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise