CTE Digital Literacy - Excel Formulas and Functions

CTE 8 - Digital Literacy
Excel Formulas & Functions

Draw

Write your preferred first name.

Multiple Choice

Which of these formulas ADDs two cells?

• =A3+B3

• A3+B3

• =A3*B3

• =A3plusB3

Multiple Choice

Which of these formulas SUBTRACTs two cells?

• C3-B3

• =C3minusB3

• =C3-B3

• =C3/B3

Fill in the Blank

What is the answer to the formula in cell A3?

Fill in the Blank

What is the answer to the formula in cell A3?

Fill in the Blank

What is the answer to the formula in cell A3?

Fill in the Blank

What is the answer to the formula in cell A3?

Multiple Choice

Which of these functions AVERAGE a set of numbers?

• =middle( )

• =average( )

• =avg( )

• =average

Fill in the Blank

What is the answer to the function in cell A8?

Fill in the Blank

What is the answer to the function in cell A8?

Fill in the Blank

What is the answer to the function in cell A5?

Fill in the Blank

A basic math equation that can add, subtract, multiply, or divide is called a _______ in Excel.

Fill in the Blank

An advanced math equation / time saving hack that can add many cells, calculating averages, find the lowest and highest number, etc. is called a ________ in Excel.

Word Cloud

What word comes to mind when you think of how you FEEL about using Microsoft Excel?

Quiz Password

The password you need to access the QUIZ: CTE 8 - Lesson 3.04 is...
KERNKREW
(all caps, all one word)