Y8 HT6 WK1 SS SPACE QUIZ RECAP

What is the purpose of the feature shown in the image in Spreadsheets?

• Fill the colour of the cells

• Add borders to the spreadsheet table

• Add colour to the text

• Change the font & size

What is the purpose of the feature shown in the image in Spreadsheets?

• Fill the colour of the cells

• Add borders to the spreadsheet table

• Add colour to the text

• Change the font & size

What is the purpose of the feature shown in the image in Spreadsheets?

• Fill the colour of the cells

• Add borders to the spreadsheet table

• Add colour to the text

• Change the font & size

What is the purpose of the feature shown in the image in Spreadsheets?

• Fill the colour of the cells

• Add borders to the spreadsheet table

• Add colour to the text

• Change the font & size

In the image (circled in red) for the score an IF STATEMENT formula has been used, what is its purpose? SELECT MORE THAN ONE ANSWER.

• Works out the total

• If the correct answer has been typed give them a score of 1 (or 2)

• If the correct answer has been typed give them a score of 0

• If the wrong answer has been typed give them a score of 0

• If the wrong answer has been typed give them a score of 1 (or 2)

In the image (circled in red) what formula has been used to work out the total

• =AVERAGE

• =SUM

• = d2+d3+d4+d5+d6+d7+d8+d9+d10

• =TOTAL

• =IF (IF STATEMENT)