Creating Formulas and Functions

Creating Formulas and Functions

7th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

Excel

Excel

7th Grade

15 Qs

Python with DataScience

Python with DataScience

7th Grade - University

10 Qs

Quiz Analisis Data

Quiz Analisis Data

10th Grade

15 Qs

تكنولوجيا عاشر

تكنولوجيا عاشر

10th Grade

10 Qs

UH EXCEL TIK

UH EXCEL TIK

10th Grade

10 Qs

Ms Excel - Grade 8

Ms Excel - Grade 8

8th Grade

10 Qs

Ms. Exel dan Fungsi Logika IF

Ms. Exel dan Fungsi Logika IF

10th Grade - University

15 Qs

S3 Programming with Visual Basic

S3 Programming with Visual Basic

9th Grade

12 Qs

Creating Formulas and Functions

Creating Formulas and Functions

Assessment

Quiz

Computers

7th - 12th Grade

Medium

Created by

Susan Crane

Used 36+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Multiply H3 times C4

=H3xC4

H3XC4

H3*C4

=H3*C4

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Add C2 and C3

C2+C3

C3+C2

=C2+C3

=SUM(C2+C3)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Subtract D4 from D3

=D4-D3

=D3-D4

=SUBTRACT(D4-D3)

D3-D4

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Divide E3 by C1

=C1/E3

=E3/C1

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Add the range B2-B10

=B2+B10

=SUM(B2,B10)

=SUM(B2-B10)

=SUM(B2:B10)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Add C6 through C10 then subtract C5

=SUM(C6:C10)-C5

=C6+C7+C8+C9+C10-C5

=SUM(C6-C10)/C5

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Add A3 and A4 then divide by C10

=A3+A4/C10

=(A3+A4)/C10

=C10/A3+A4

=C10/(A3+A4)

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?