Spreadsheet Overview (Formula & Function)

All functions and formulas begin with which symbol?

• #

• /

• :

• =

Which of the following is a formula that will add cells C9 and C10?

• =C9+C10

• C9+C10

• SUM(C9:C10)

• =SUM(C9:C10)

This function adds the range of cells

• =AVERAGE( )

• =SUM( )

• =MIN( )

• =MAX( )

This function determine the average of the range of cells

• =AVERAGE( )

• =SUM( )

• =MIN( )

• =MAX( )

This function finds the highest number in the range of cells

• =AVERAGE( )

• =SUM( )

• =MIN( )

• =MAX( )

This function finds the lowest number in the range of cells

• =AVERAGE( )

• =SUM( )

• =MIN( )

• =MAX( )

A mathematical operation is called a _______________.

• formula

• range

• label

• graph

If you wanted to change the size of the text inside a cell, which tool would you use?

• Cell width

• Cell height

• Text colour

• Font size

Which mathematical operator (symbol) would you use to divide the values in two cells?

• +

• -

• /

• *

Which mathematical operator (symbol) would you use when subtracting a value in a cell from a value in another cell?

• +

• -

• /

• *