Speadsheet Formulas/Functions Review

What is the formula for multiplying two cells?

• =A1*B1

• A1*B1

• =A1+B1

• =A1/B1

• =A1-B1

Match the following formulas with the correct definition

• =A1+B1

• Divide

• =A1-B1

• Add

• =A1*B1

• Multiply

• =A1/B1

• Subtract

Match the following functions with the correct definition

• The sum of all the numbers in a set

• Mode

• The difference between the largest and smallest number in a set

• Mean

• The middle number in a set of numbers

• Sum

• The average of a set of numbers

• Median

• The number that appears most frequently in a set

• Range

Match the following functions with the correct formulas

• =med(A1:A5)

• Mode

• =sum(A1:A5)

• Range

• =A2-A5

• sum

• =mode(A1:A5)

• Mean

• =avg(A1:A5)

• Median

What are two spreadsheet programs? (a)   (b)  

• Microsoft Excel

• Google Sheets