N5 Spreadsheets

We can use this function to count the number of cells containing numbers

• =COUNTA

• =COUNTW

• =COUNT

• =COUNTN

We can use this function to count the number of cells containing words/letters

• =COUNTA

• =COUNTW

• =COUNT

• =COUNTN

We can use this function to perform a 'logical test' where the answer is a TRUE or FALSE outcome

• =MAYBE

• =WHEN

• =LOGIC

• =IF

We can use this function to add more than 2 cells together

• =ADD

• =SUM

• =ANSWER

• =COUNT

We can use this function to find the highest number in a range of cells

• =MAX

• =MIN

• =HIGHEST

• =LARGEST

We can use this function to find the lowest number in a range of cells

• =MAX

• =MIN

• =SMALLEST

• =LOW

We can use this function to find the average value in a range of cells

• =MIDDLE

• =AVG

• =AVERAGE

• =AV

We use this to 'lock in' a value in a cell so that replicating formula is accurate.

• Named cell

• Cell reference

• Same cell

• The cell

When printing in value view we must show

• Row and column headings only

• Grid lines and row and column headings

• Grid lines only

• A blank background

When printing in formula view we must show

• Row and column headings only

• Grid lines and row and column headings

• Grid lines only

• A blank background