Google Sheets: Creating Complex Formulas Quiz

Google Sheets: Creating Complex Formulas Quiz

8th Grade

10 Qs

quiz-placeholder

Similar activities

KLS VIII-Objek Utama dalam Aplikasi

KLS VIII-Objek Utama dalam Aplikasi

8th Grade

15 Qs

Google Apps Finals

Google Apps Finals

8th Grade

15 Qs

Google sheets

Google sheets

7th Grade - University

14 Qs

Latihan Soal

Latihan Soal

8th Grade

15 Qs

Presentation Software Quiz Class 8

Presentation Software Quiz Class 8

8th Grade

10 Qs

Pre-test Analisis Data

Pre-test Analisis Data

8th Grade

10 Qs

Google Docs, Sheets, Slides Quiz

Google Docs, Sheets, Slides Quiz

8th Grade

10 Qs

soal latihan tik kelas 8

soal latihan tik kelas 8

8th Grade

11 Qs

Google Sheets: Creating Complex Formulas Quiz

Google Sheets: Creating Complex Formulas Quiz

Assessment

Quiz

Information Technology (IT)

8th Grade

Easy

Created by

EDITH KATZFEY

Used 1+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the first step in the order of operations in Google Sheets?

Multiplication and division

Exponential calculations

Operations enclosed in parentheses

Addition and subtraction

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which mnemonic can help you remember the order of operations?

Please Excuse My Dear Aunt Sally

My Very Educated Mother Just Served Us Noodles

Never Eat Soggy Waffles

Every Good Boy Deserves Fudge

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the formula 5 + 2 * 8, which operation is performed first?

Addition

Subtraction

Multiplication

Division

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the result of the formula 3/4*4?

12

0.75

3

1

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In the example formula =B3*C3+B4*C4, which operation is performed first?

Addition

Subtraction

Multiplication

Division

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the result of the formula 10 + 3 - 1?

14

13

11

12

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of using parentheses in formulas?

To add comments to the formula

To define which calculations will be performed first

To make the formula look complex

To increase the font size

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?

Discover more resources for Information Technology (IT)