Functions

Functions

5th Grade

20 Qs

quiz-placeholder

Similar activities

Excel - Worksheet 1

Excel - Worksheet 1

4th - 5th Grade

20 Qs

Ms Excel Test

Ms Excel Test

1st - 12th Grade

20 Qs

Class 5 Computer chapter 7

Class 5 Computer chapter 7

5th Grade

16 Qs

EXCEL EDITING AND FORMATTING

EXCEL EDITING AND FORMATTING

5th Grade

17 Qs

Excel 2016

Excel 2016

5th Grade

20 Qs

Spreadsheet

Spreadsheet

5th - 9th Grade

19 Qs

Chapter - 14 Spreadsheet Formulas

Chapter - 14 Spreadsheet Formulas

4th Grade - University

18 Qs

Excel functions

Excel functions

5th Grade

17 Qs

Functions

Functions

Assessment

Quiz

Computers

5th Grade

Easy

Created by

Rogevir Rivera

Used 3+ times

FREE Resource

20 questions

Show all answers

1.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the sum of cells A1 to A12 and write the correct formula using a function.

2.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the average of cells B1 to B12 and write the correct formula using a function.

3.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the count of cells C1 to C12 and write the correct formula using a function.

4.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the maximum number in cells D1 to D12 and write the correct formula using a function.

5.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the minimum number in cells E1 to E12 and write the correct formula using a function.

6.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the sum of cells F1 to F12 and write the correct formula using a function.

7.

FILL IN THE BLANK QUESTION

5 mins • 1 pt

Media Image
Find the average of cells G1 to G12 and write the correct formula using a function.

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?