S3 Spreadsheets

Front

What does this tool do? Options: Add a table, Add a border, Add a Pie chart, Add an image

Back

Add a border

Front

What is the tool used for?

Back

Change colour of the Cell (Box)

Front

What does the formula do?

Back

Add everything together you select

Front

What do I use to add pound signs to my numbers?

Back

Currency

Front

To create a formula, you first:

Back

Type the equals sign (=) to tell Excel that you're about to enter a formula

Front

What is the correct formula for SUM  in Excel?

Back

=SUM(B3:B9)

Front

Which button can you click to add up a series of numbers?

Back

The autosum button

Front

If the cell contains hashtags (#), what do you need to do?

Back

Expand the column

Front

Which formula gets the biggest value of a range of cells? Options: MAX, MIN, LARGE, SUM

Back

MAX

Front

Which formula gets the smallest value of a range of cells?

Back

MIN