Search Header Logo

Spreadsheet Functions

Authored by S Nelson

Computers

6th - 12th Grade

Used 58+ times

Spreadsheet Functions
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SUM, AVERAGE and COUNT are all known as spreadsheet:

formula

data

functions

graphs

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A spreadsheet is used for

creating drawings

typing letters and resumes

calculating data

creating tables but not for calculations

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of a range?

D3

D3 and D5

D3:D18

Sum

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Use the spreadsheet you created, see sample in image. Which function calculates the total for score 1?

=Total(B2:B4)

=Sum(B2:B4)

=Sum(C2:C4)

=Total(C2:C4)

5.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Media Image

Use the spreadsheet you created, see sample in image. Type the CORRECT function that calculates the average for score 1?

6.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Media Image

Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the answer in cell C7?

7.

FILL IN THE BLANK QUESTION

30 sec • 1 pt

Media Image

Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the average for score 2? Rounded to 2 decimal places.

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?