Excel formulas VS Functions

What does the SUM function do?

• Multiplies all the values in a range

• Adds all the values in a range

• Subtracts values in a range

What does the MAX function do?

• Returns the smallest value in a set of values

• Returns the largest value in a set of value

Choose the correct syntax

• =(MIN)

• =MIN()

• (MIN

What does the AVERAGE function do?

• Returns the median number in a set of values

• Returns the average number in a set of values

How do you properly specify a range of cells?

• B1;B16 (semicolon)

• B1-B16(dash)

• B1:B16(colon)

• B1,B16(comma)

Which function will total a range of cells?

• TOTAL

• SUM

• MIN

• AVERAGE

A formula always begins with this symbol. 

• +

• -

• =

• /

COUNT counts cells which are...

• Numbers only

• Letters and numbers

A function has 3 parts. Name them in the correct order

• Equal Sign, Argument, Function name

• Equal sign, Function name, argument

Bonus: The company that developed Excel

• Sony

• Microsoft

• Apple

• Samsung