Creating Formulas and Functions

Creating Formulas and Functions

7th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

ÔN TẬP TIN 8 GIỮA KÌ 2

ÔN TẬP TIN 8 GIỮA KÌ 2

8th Grade

13 Qs

THI LÝ THUYẾT HK1 - KHỐI 7

THI LÝ THUYẾT HK1 - KHỐI 7

7th Grade

10 Qs

NGHS Y7 SPREADSHEET 1

NGHS Y7 SPREADSHEET 1

7th Grade

14 Qs

Вбудовані функції

Вбудовані функції

1st - 12th Grade

12 Qs

Soal Pre Test Analisis Data: Pengolahan Data Dasar

Soal Pre Test Analisis Data: Pengolahan Data Dasar

7th Grade

10 Qs

Excel

Excel

12th Grade

15 Qs

Bài 29. Nhận biết lỗi chương trình

Bài 29. Nhận biết lỗi chương trình

9th - 12th Grade

14 Qs

Test Excel

Test Excel

10th - 12th Grade

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