Writing Formulas in Excel

Writing Formulas in Excel

10th Grade

9 Qs

quiz-placeholder

Similar activities

Top 5 Excel 23

Top 5 Excel 23

10th - 12th Grade

5 Qs

Chapter 27: Environmental & Ethical Issue

Chapter 27: Environmental & Ethical Issue

10th - 11th Grade

10 Qs

Tin 7 bài 4, 5

Tin 7 bài 4, 5

10th Grade

13 Qs

Spreadsheets

Spreadsheets

KG - University

10 Qs

Electro-8-formule

Electro-8-formule

1st - 12th Grade

8 Qs

CTE Math

CTE Math

9th - 12th Grade

9 Qs

Kiểm tra trình độ bóng đá Việt Nam

Kiểm tra trình độ bóng đá Việt Nam

1st Grade - University

12 Qs

Construction Materials

Construction Materials

10th - 11th Grade

10 Qs

Writing Formulas in Excel

Writing Formulas in Excel

Assessment

Quiz

Other

10th Grade

Medium

Created by

Eve Biddle

Used 3+ times

FREE Resource

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula? (Using the picture)

=A1*B3

13

103

30

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Which cell is the active cell? (using the picture)

A6

A1

C6

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula? (Using the picture)

=C1/A4

10

104

5

None of the above

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula? (Using the picture)

=sum(A3:C3)

133

17

7

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula: (Using the picture)

=average(A2:C2)

3

6

9

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula? (Using the picture)

=max(C1:C5)

10

9

3

0

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula? (Using the picture)

=min(C1:C5)

10

9

3

1

8.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is the result of this formula? (Using the picture)

=(A1+C1)/2

20

10

5

0

9.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

What is circled in red in the picture?

Sizing handle

Copy Handle

Fill Handle