Basic Spreadsheet Formulas

Basic Spreadsheet Formulas

Professional Development

10 Qs

quiz-placeholder

Similar activities

Exam Prep 1

Exam Prep 1

Professional Development

10 Qs

2. Day 1_ITBA 10 Soal

2. Day 1_ITBA 10 Soal

KG - Professional Development

10 Qs

social engineering

social engineering

1st Grade - Professional Development

10 Qs

HP Commercial Product Training Quiz

HP Commercial Product Training Quiz

Professional Development

10 Qs

IPv6 Direccion simplificada, completa y MAC

IPv6 Direccion simplificada, completa y MAC

Professional Development

12 Qs

Minecraft (Good luck Jake)

Minecraft (Good luck Jake)

KG - Professional Development

10 Qs

Python Data Structures & Statements

Python Data Structures & Statements

Professional Development

11 Qs

PLAL Agile Onboarding

PLAL Agile Onboarding

Professional Development

10 Qs

Basic Spreadsheet Formulas

Basic Spreadsheet Formulas

Assessment

Quiz

Computers

Professional Development

Practice Problem

Hard

Created by

Ruth Lock

Used 9+ 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

Media Image

Which formula would add the January and February profits?

B2+B3

B2+B3=

B3+B4=

=B2+B3

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What value would the following formula return? =2+3*4-1

17

19

13

11

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Now that the formula has parentheses, what value would the following formula return?

17

19

13

11

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a relative cell reference?

$C$2

$C2

!C2

C2

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

If you wanted to make an absolute reference to cell E2, what would it look like?

[E2]

E2

@E2

$E$2

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following functions is using the correct syntax?

SUM=(A2:A8,E2:E8)

=A2:A8(SUM)E2:E8

=SUM(A2:A8,E2:E8)

SUM(A2:A8,E2:E8)=

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

In this example, we want to use the formula =MAX(B3:D7)

What would that formula find?

The total number of items sold between January and March

The average number of cakes sold in March

The smallest amount of an item ordered in March

The largest amount of an item ordered between January and March

Create a free account and access millions of resources

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?