Spreadsheet Functions: SUM and AVERAGE

Spreadsheet Functions: SUM and AVERAGE

1st Grade

16 Qs

quiz-placeholder

Similar activities

COMPUTING REVISION QUIZ

COMPUTING REVISION QUIZ

1st Grade

12 Qs

Trắc nghiệm excel - 1

Trắc nghiệm excel - 1

KG - University

20 Qs

What is a computer

What is a computer

KG - University

11 Qs

Database Basics v2 N5

Database Basics v2 N5

1st - 12th Grade

20 Qs

COMPUTER PARTS-GRADE 1

COMPUTER PARTS-GRADE 1

1st Grade

20 Qs

Word Processing Lessons 3 and 4 Review

Word Processing Lessons 3 and 4 Review

KG - University

20 Qs

Grade 1 ICT  Quiz Activity

Grade 1 ICT Quiz Activity

1st Grade

20 Qs

WordPress

WordPress

1st Grade

21 Qs

Spreadsheet Functions: SUM and AVERAGE

Spreadsheet Functions: SUM and AVERAGE

Assessment

Quiz

Computers

1st Grade

Practice Problem

Medium

Created by

adegboyega adewumi

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

16 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the result of adding 5 and 3 using the SUM function?

6

8

10

7

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Calculate the total of 10, 15, and 20 using the SUM function.

25

35

30

45

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using the SUM function, find the total of the numbers in cells A1, A2, and A3.

=SUM(A1, A2, A3)

=SUM(A1, A3)

=SUM(A1:A2)

=SUM(A1:A3)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If the values in cells B1, B2, B3, and B4 are 8, 12, 15, and 20 respectively, what is the total using the SUM function?

45

55

30

60

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the average of the numbers 10, 15, 20, 25, and 30?

The average is 18.

The average is 25.

The average is 12.

The average is 20.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Find the average of the range A1 to A5 using the AVERAGE function.

=AVERAGE(A1,A2,A3,A4,A5)

=SUM(A1:A5)/5

=A1+A2+A3+A4+A5/5

=AVERAGE(A1:A5)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If the values in cells B1, B2, B3, B4, and B5 are 12, 18, 20, 25, and 30 respectively, what is the average using the AVERAGE function?

28

21

15

23

Create a free account and access millions of resources

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?