Google Sheets 1 Final Assessment

Google Sheets 1 Final Assessment

7th Grade

27 Qs

quiz-placeholder

Similar activities

FBLA Business Etiquette

FBLA Business Etiquette

7th - 8th Grade

28 Qs

Ulangkaji Perniagaan Bab 1 Tingkatan 1

Ulangkaji Perniagaan Bab 1 Tingkatan 1

1st Grade - Professional Development

25 Qs

Microsoft Excel 2016

Microsoft Excel 2016

7th - 8th Grade

25 Qs

Excel Worksheet Management Quiz

Excel Worksheet Management Quiz

7th Grade

22 Qs

3rd Nine Weeks Exam Review

3rd Nine Weeks Exam Review

7th - 8th Grade

30 Qs

Collaboration

Collaboration

5th Grade - Professional Development

32 Qs

Unit 1- First Month

Unit 1- First Month

7th - 9th Grade

30 Qs

FBLA Business Etiquette 2022

FBLA Business Etiquette 2022

7th - 12th Grade

28 Qs

Google Sheets 1 Final Assessment

Google Sheets 1 Final Assessment

Assessment

Quiz

Business

7th Grade

Easy

Created by

Faith Brooks

Used 7+ times

FREE Resource

27 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which of the following uses a function to calculate the total value for cells B2 through B5?

=SUM(B2:B5)

=B2+B3+B4+B5

=13.5+6.08+7.53+45.1

=B1++B5

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What value would the function =COUNT(A2:A7) return?

4 (four)

3 (three)

5 (five)

5 (five)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using the correct order of operations, what does this formula equal? =(4-2)*6/2.

8 (eight)

6 (six)

2 (two)

4 (four)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Using the correct order of operations, what does this formula equal? =16/4*2.

4 (four)

2 (two)

16 (sixteen)

8 (eight)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How can you force a certain order of operations in a formula?

They cannot be forced.

By positioning the operations from left to right.

By using parentheses.

By using simple formulas.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A cell has a very long formula that you must edit. What would be the best way to edit the formula?

Select the cell and edit the formula in the Formula Bar.

Double-click on the cell and edit the formula in the cell.

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which Menu tab would you use to access the command to clear a cell's format?

File

Edit

View

Format

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?