Writing Formulas in Excel

Writing Formulas in Excel

10th Grade

9 Qs

quiz-placeholder

Similar activities

Collage Vocabulary

Collage Vocabulary

5th - 10th Grade

12 Qs

POC PET PREPARATION 2020

POC PET PREPARATION 2020

1st Grade - University

11 Qs

Chess Strategies

Chess Strategies

KG - University

10 Qs

Elements of Music Quiz

Elements of Music Quiz

6th - 12th Grade

10 Qs

Left vs Right Brain

Left vs Right Brain

9th - 12th Grade

12 Qs

Types of Memory

Types of Memory

10th - 11th Grade

13 Qs

Fair Use

Fair Use

5th Grade - University

10 Qs

Tiling Area

Tiling Area

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