Search Header Logo

Spreadsheet Functions and Charts Quiz

Authored by Kimberly Watson

Computers

7th Grade

Used 2+ times

Spreadsheet Functions and Charts Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

18 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function is used to find the highest number in a list of values? (1 mark)

SUM

AVERAGE

MAX

COUNT

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What will the formula =AVERAGE(10, 20, 30, 40, 50) return? (1 mark)

30

50

40

10

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If a spreadsheet has numbers in A1:A10, which formula counts how many cells contain numbers? (1 mark)

=COUNT(A1:A10)

=SUM(A1:A10)

=MAX(A1:A10)

=AVERAGE(A1:A10)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the SUM function do in spreadsheets? (1 mark)

Finds the largest number

Adds up all numbers in a range

Counts the number of cells

Finds the smallest number

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the function =MIN(A1:A20) return? (1 mark)

The smallest number in A1:A20

The total of all numbers in A1:A20

The largest number in A1:A20

The number of non-empty cells in A1:A20

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which function should you use to count all non-empty cells in a range (numbers and text)? (1 mark)

COUNT

COUNTA

SUM

AVERAGE

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which type of chart is best for showing trends over time? (1 mark)

Pie chart

Bar chart

Line graph

Scatter plot

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?