Search Header Logo

Excel Formula Review

Authored by Points Prizes

Computers

6th - 12th Grade

Used 1+ times

Excel Formula Review
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do all formulas begin with?

=

$

#

Formula Name

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do functions do in Excel?

Functions in Excel perform calculations and automate tasks.
Functions in Excel create charts and graphs.
Functions in Excel store data in tables.
Functions in Excel format text and images.

3.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Media Image

How could you select this range for a formula?

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Media Image

What is the result of the following equation?

=T1 * V1 + U1 - W1

16

14

17

Syntax Error

5.

FILL IN THE BLANK QUESTION

1 min • 1 pt

What is the function to get the smallest number in a range?

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

What is the function to get the largest number in a range?

7.

FILL IN THE BLANK QUESTION

1 min • 1 pt

What is the function to add up all the numbers in a range?

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?