Font size
WorksheetsS3 AIT Spreadsheets
Total questions: 19
Worksheet time: 12mins
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
If I am trying to find out how many pieces of data are in the list but there are blanks or info is missing then what formula should I use?
=Count
=CountA
=CountBlank
When you copy a formula across a row it is called?
Copying
Replication
Dragging
Mirroring
What button do you click in the Home Ribbon to make the text look like this?
What would you use these buttons for on a spreadsheet?
To add and take away decimals
To move the direction of numbers
What does this button do?
Quick Link to Input Forumla
Predicts Forumla
Adds in numbers
What date format is this?
Short Date
Long Date
What date format is this?
Short Date
Long Date
Which button would you use to make text bold?
How confident do you feel at using semi complex formula in Excel?
Very Confident
Confident
Unsure
Not Confident
