Session 7 Quiz

What is a cell in a spreadsheet?

• The whole spreadsheet
• The box where a row and column meet, like A1 or C5
• A formula
• A chart

What does the formula =SUM(A1:A10) do?

• Finds the average
• Adds up all values from A1 to A10
• Counts how many cells have data
• Finds the biggest number

What does =AVERAGE(B2:B20) calculate?

• The total of all values
• The mean (average) of values from B2 to B20
• The middle value
• The number of values

How do you create a chart in a spreadsheet?

• Draw it by hand
• Select your data and click Insert > Chart
• Copy data to a drawing program
• Charts are not possible in spreadsheets

What is the advantage of spreadsheet charts over hand-drawn charts?

• Hand-drawn charts are always better
• Spreadsheet charts update automatically when data changes and let you try different types easily
• There is no advantage
• Spreadsheets only make bar charts

What should Row 1 of a spreadsheet contain?

• The biggest numbers
• Column headers (labels) describing what each column contains
• Formulas
• Nothing — start data in Row 1

What does =MAX(C1:C50) find?

• The average of column C
• The largest value in cells C1 through C50
• The smallest value
• The total

Why are spreadsheets one of the most important data tools?

• They are expensive
• They organize, calculate, and visualize data — skills used in nearly every profession
• Only data scientists use them
• They are only for math class