Spreadsheet Functions and Charts Quiz

Spreadsheet Functions and Charts Quiz

7th Grade

18 Qs

quiz-placeholder

Similar activities

la internet

la internet

3rd - 11th Grade

20 Qs

Linux-2 Quiz 2 -- LAMP

Linux-2 Quiz 2 -- LAMP

1st - 12th Grade

15 Qs

Name The Disney Animation Films

Name The Disney Animation Films

KG - University

20 Qs

MORE ON CSS3

MORE ON CSS3

7th Grade

15 Qs

Empowerment Technologies

Empowerment Technologies

KG - 12th Grade

15 Qs

DPS Jorhat - Robotics Skill Assessment

DPS Jorhat - Robotics Skill Assessment

6th - 8th Grade

20 Qs

Q7/Q8 Email Vocabulary (Basics in 21t4s)

Q7/Q8 Email Vocabulary (Basics in 21t4s)

5th - 9th Grade

17 Qs

Pre-test: On Online searching by Innovative Teaching Ideas)

Pre-test: On Online searching by Innovative Teaching Ideas)

6th - 12th Grade

14 Qs

Spreadsheet Functions and Charts Quiz

Spreadsheet Functions and Charts Quiz

Assessment

Quiz

Computers

7th Grade

Practice Problem

Hard

Created by

Kimberly Watson

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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?