Mastering Spreadsheets Quiz

Mastering Spreadsheets Quiz

7th Grade

20 Qs

quiz-placeholder

Similar activities

ICT Spreadsheet Essentials - Lesson 1 (Part 3)

ICT Spreadsheet Essentials - Lesson 1 (Part 3)

7th - 8th Grade

15 Qs

Spreadsheet Fundamentals - Quiz2

Spreadsheet Fundamentals - Quiz2

University

20 Qs

MS Excel

MS Excel

9th Grade

22 Qs

Excel Review

Excel Review

7th - 8th Grade

15 Qs

Spreadsheet Revision

Spreadsheet Revision

7th - 9th Grade

20 Qs

Google Sheets Review

Google Sheets Review

KG - University

20 Qs

Microsoft Excel

Microsoft Excel

University

15 Qs

Spreadsheets 1

Spreadsheets 1

7th - 9th Grade

20 Qs

Mastering Spreadsheets Quiz

Mastering Spreadsheets Quiz

Assessment

Quiz

Computers

7th Grade

Hard

Created by

Samar Chauhan

Used 1+ times

FREE Resource

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the SUM function in a spreadsheet?

To divide a series of numbers

To multiply a series of numbers

To add up a series of numbers

To subtract a series of numbers

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which formula can be used to find the average value of the numbers in cells A1 through A10?

=AVERAGE(A1:A10)

=SUM(A1:A10)/10

Both A and B

=AVG(A1:A10)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the cell address A1 indicate?

Column A and Row 1

Column 1 and Row A

The first cell in Column A

Both A and C

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you insert a pie chart in a spreadsheet?

Select the data and press the pie chart button

Write a formula to generate a pie chart

Copy and paste from another document

Use the SUM function

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What function would you use to find the maximum value in a range of cells from B1 to B10?

=MAX(B1:B10)

=HIGHEST(B1:B10)

=LARGEST(B1:B10)

=TOP(B1:B10)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To find the minimum value in the cells C1 through C10, which function is correct?

=SMALLEST(C1:C10)

=MIN(C1:C10)

=LOWEST(C1:C10)

=BOTTOM(C1:C10)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the result of the formula =AVERAGE(2, 4, 6, 8)?

4

5

6

20

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?