Excel Formula Review

What do all formulas begin with?

• =

• $

• #

• Formula Name

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.

How could you select this range for a formula?

What is the result of the following equation?

=T1 * V1 + U1 - W1

• 16

• 14

• 17

• Syntax Error

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

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

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

How do you count the number of elements in an range?

• SUM

• AVERAGE

• COUNT

• MAX

What formula would you use here?

• =AVERAGE(B1:B3)

• =SUM(B1:B3)

• =COUNT(B1:B3)

What function would you use to get the time for a specific movie?

• VLOOKUP

• SUMIF

• COUNTIF

• AVERAGE