Excel MCQs - Data Handling

Which measure shows the middle value in a sorted list?

• Mean

• Median

• Mode

• Standard Deviation

In Excel, what happens when you apply a filter to a column?

• Rows with no values are deleted

• Rows not matching the filter are hidden

• All rows are sorted

• Data is parsed

Which measure is not part of the standard descriptive statistics output in Excel?

• Mean

• Standard Deviation

• Mode

• ANOVA

What does 'Text to Columns' not support?

• Delimited split

• Fixed width split

• Auto-formatting

• Parsing

What does the SUMPRODUCT function return if A1:A3={1,2,3} and B1:B3={4,5,6}?

• 32

• 21

• 18

• None

Which Excel tool provides Mean, Median, Mode, Variance, and Standard Deviation together?

• Pivot Table

• Descriptive Statistics

• Histogram

• Advanced Filter

What type of chart is typically recommended for frequency distribution analysis?

• Bar Chart

• Histogram

• Line Chart

• Pie Chart

Which function is best for conditional summing in Excel?

• SUMIF

• IF

• COUNTIF

• AVERAGE

What does the 'Descriptive Statistics' tool provide?

• Pivot Table

• Summary measures like mean and SD

• Charts

• Filtering options

What does the 'Parsing' feature typically involve in Excel?

• Splitting data into columns

• Filtering data

• Summing rows

• Applying validation