WorksheetsY8 HT6 WK1 SS SPACE QUIZ RECAP
Total questions: 6
Worksheet time: 6mins
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)
