Old course week 12

Which function in Excel counts only the cells that are not empty?

• COUNT

• COUNTBLANK

• COUNTA

• COUNTIFS

What does the COUNTIF function do in Excel?

• Counts cells that are empty in a range

• Counts cells that meet a single criterion

• Counts cells containing numbers

• Counts cells containing any type of data

Which of the following correctly describes "median"?

• The most frequently occurring value in a dataset

• The sum of a group of numbers divided by the count of those numbers

• The middle value of a dataset, where half the numbers are greater and half are smaller

• The largest value in a dataset

What does the STDEV function estimate in Excel?

• Variance

• Standard deviation based on a sample

• Median value

• Maximum value

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

• Bar Chart

• Scatter Chart

• Funnel Chart

• Box & Whisker Chart

What is the purpose of a secondary axis in Excel charts?

• To change the chart’s colour scheme

• To chart two quantities of different magnitudes effectively

• To display a summary of numerical data

• To create a hierarchical view of data

What kind of chart would you use to display hierarchical data in Excel?

• Funnel Chart

• Histogram Chart

• Sunburst Chart

• Map Chart

Which function would you use to find the top 25% of incomes in a dataset?

• MAX

• QUARTILE

• CORREL

• AVERAGEIF

What is a key feature of sparklines in Excel?

• They allow the creation of detailed scatter plots.

• They summarise data visually in a single cell.

• They represent hierarchical relationships.

• They display the median and outliers.

How can altering the scale of a chart in Excel affect its interpretation?

• It improves the colour scheme of the chart.

• It changes the underlying data values.

• It can make the chart misleading.

• It adds hierarchical levels to the chart.