S3 AIT Spreadsheets

Each box on a spreadsheet is called ....

• A Square

• A Box

• A Cell

• A Cube

What symbol must every formula start with?

What does this symbol mean?

• Minus

• Times

• Add

• Star

What does this symbol mean?

• Times

• Slash

• Add

• Divide

Will this formula work properly?

• YES

• NO

When adding a range of cells together to find a TOTAL, what function do you use?

• = CountA

• = Average

• = Sum

• = Count

To find out which month had the highest sales revenue what formula should I use?

• =Average

• =Max

• =Min

• =Sum

To find out which month had the lowest sales revenue what formula should I use?

• =Average

• =Max

• =Min

• =Sum

If I am trying to add up numbers and dates to find out how many pieces of data are in the list what formula should I use?

• =Count

• =CountA

• =CountBlank

If I am trying to add up words or numbers or ANYTHING to find out how many pieces of data are in the list what formula should I use?

• =Count

• =CountA

• =CountBlank