Google Sheets: Creating Complex Formulas Quiz

Google Sheets: Creating Complex Formulas Quiz

8th Grade

10 Qs

quiz-placeholder

Similar activities

soal latihan tik kelas 8

soal latihan tik kelas 8

8th Grade

11 Qs

Kuis Google Classroom

Kuis Google Classroom

7th Grade - University

15 Qs

sheets

sheets

8th Grade

10 Qs

prgramming

prgramming

6th Grade - University

11 Qs

Ce știi despre aplicațiile Google?

Ce știi despre aplicațiile Google?

1st Grade - University

10 Qs

Copyright, Fair Use, and Ethical Use of AI In Schools

Copyright, Fair Use, and Ethical Use of AI In Schools

7th - 12th Grade

10 Qs

Post Test Aplikasi Kantor

Post Test Aplikasi Kantor

8th Grade

10 Qs

Quiz Pre Test APlikasi Perkantoran

Quiz Pre Test APlikasi Perkantoran

8th Grade

15 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?