FTC Data Week 7

What does the =SUM function do in Excel?

• Calculates the average of numbers in a range.

• Finds the total of numbers in a range.

• Displays the smallest number in a range.

• Counts the number of cells in a range.

What is the primary purpose of Flash Fill in Excel?

• To extend a pattern across a series.

• To automatically clean and restructure data.

• To highlight duplicate values in a dataset.

• To copy formulas across rows and columns.

Which function counts the number of cells that are not empty in a range?

• =COUNT

• =COUNTA

• =COUNTBLANK

• =COUNTIF

What does the =MEDIAN function return?

• The average of the numbers in a dataset.

• The smallest number in a dataset.

• The middle value in a sorted dataset.

• The most frequently occurring value in a dataset.

How is variance related to standard deviation?

• Variance is the square root of standard deviation.

• Variance is the square of standard deviation.

• Variance and standard deviation are always equal.

• Variance is unrelated to standard deviation.

Which Excel function can identify the k-th largest value in a dataset?

• =MAX

• =LARGE

• =SMALL

• =QUARTILE

What does a confidence interval represent in statistics?

• The range of values most likely to contain a sample mean.

• The average of a dataset.

• The relationship between two datasets.

• The highest and lowest values in a dataset.

Which logical function checks if at least one condition is TRUE?

• =IF

• =AND

• =OR

• =EXACT

What is the key output of linear regression?

• The slope and intercept of the best-fit line.

• The correlation coefficient between two datasets.

• The p-value for hypothesis testing.

• The quartiles of a dataset.

What does the =COUNTIFS function do?

• Counts cells based on multiple conditions.

• Counts cells containing numbers only.

• Counts the total number of blank cells in a range.

• Counts the unique values in a dataset.