Decode the Data! An Intro to Data Science

What function can you use to calculate the average score in Excel?

• =SUM(range)

• =MEAN(range)

• =AVERAGE(range)

• =MEDIAN(range)

What Excel feature helps to isolate rows that match specific conditions?

• Sorting

• Filtering

• Conditional Formatting

• Charts

Which chart is best for showing the relationship between two numerical variables?

• Pie Chart

• Bar Chart

• Scatter Plot

• Line Chart

Which formula would label a score above 60 as a pass?

• =IF(Score>60, "Pass", "Fail")

• =IF(Score>=60, "Pass", "Fail")

• =IF(Score=60, "Fail", "Pass")

• =IF(Pass, Score, Fail)

What function would you use to count the number of cells that contain numbers in a range in Excel?

• =COUNT(range)

• =SUM(range)

• =COUNTA(range)

• =COUNTIF(range, criteria)

Which formula would return the maximum value from a set of scores?

• =AVERAGE(range)

• =SUM(range)

• =MAX(range)

• =MIN(range)

What Excel tool allows you to create a visual representation of data trends over time?

• Pivot Table

• Line Chart

• Histogram

• Data Table