question In Excel what does the function INDIRECT Sheet1 A1 do

What is the purpose of the "Data Validation" criteria "Whole number" in Excel?

A. Allows only whole numbers to be entered in a cell
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 "Named Range" feature in Excel?

A. Assigning a name to a specific range of cells
B. Changing the name of the entire worksheet
C. Sorting cells based on alphabetical order
D. Creating a table with named cells

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

A. Group and organize rows or columns with a hierarchical structure
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 =RADIANS(A1) do?

A. Converts the angle in cell A1 from degrees to radians
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 function is used to find the average of cells that meet multiple criteria?

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

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

A. Automatically fills in values based on patterns it recognizes
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 function =INDIRECT("Sheet1!A1") do?

A. Returns the value in cell A1 of Sheet1
B. Adds the values in the range A1:A10 on Sheet1
C. Finds the average of the range A1:A10 on Sheet1
D. Rounds the value in cell A1 on Sheet1 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

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