You should avoid blanks rows and columns in the main body of the "List"
What is Good Practice
Bonus Points - Name other forms of good practice for Excel
100
Selects the whole Row or Column
What is clicking on the row/column header
100
Good practice in creating formulas
What is referring to cell references rather than numbers
100
Three ways you can Format Cells
What is Format + Format Cells on Ribbon, Right Click + Format Cells on range of cells, or choosing items on the Home Tab
200
Allows the screen to become larger/smaller
What are the magnification/zoom tools
200
Holds an element of Data
What is a Cell
Bonus point, what is the Active Cell
200
Highlight Cell, left click and drag
What is how to select a range of adjacent cells
Bonus point, what is another way?
200
Arithmetic Operators
What are + / * -
Bonus Points - What does a formula start with
200
Will put data in the middle of a range of cells
What is Merge and Centre
300
One overwrites, one creates a new file
What is save and save as
300
Forward Slash
What is the operator used for date formats and to divide in a sum
300
Ctrl + Click
What is how to select Non Adjacent Cells
300
Double Points --------------------------------
Tell me what $F$4 is and what does it do
What is an Absolute Reference
Bonus Points - What is relative
300
Gives you different options for pasting
What is Paste Special
400
Ctrl F1, Double Click Tab, Right Click and Tick
What are three ways to hide/unhide the ribbon
400
B3:F20
What is a Cell Range
400
Ctrl + Click
What is how to select Non Adjacent Cells
400
Counts the number of cells not empty
What is CountA
Bonus point, write a formula using the CountA function
400
Copies the formatting from one cell/cell range to another cell/cell range
What is Format Painter
500
It has been partially completed and you change it for your own use
What is a template
Bonus, what types of forms could you use as a template?
500
The keyboard shortcut for copy
What is Crl C
Bonus points - Paste, Undo, Redo, Bold, Underlined
500
Additional pages to your "book"
What is a Worksheet
Bonus Point - How do you rename, move, copy and delete a worksheet
500
A logical function that yields one of two specific values
What is the IF function. =IF(A1>2, "Stock Ok", "Buy More")
Bonus points, how would you write a formula to say if B4 is less than or equal to 6 then place order if not OK
500
How do you make a selection of Columns Wider
What is select them and double click the line between the columns