1) Which cell reference contains a label? a) A6 b) B6 c) C9 2) Which column letter contains the individual cost of ingredients? a) A b) B c) C d) D 3) Which column letter contains the spell name? a) B b) A c) D d) C e) E 4) Which cell reference contains the title ‘ingredients’? a) E4 b) D7 c) B4 5) Which cell reference contains the quantity of Moth’s spots needed? a) E6 b) C7 c) C4 6) E7 says £2.80 a) True b) False 7) Which of the following cell reference contains a formula? a) E5 b) C5 c) B5 8) What is the formula used to work out the total cost of caterpillar hair required. a) E6*C6*D6 b) =C6*D6 c) =C6/D6 d) =SUM(B6:E6) 9) The individual cost of Batswings has gone up from £0.20 to £0.25. Which two cells will change as a result of this price increase? a) D5 and E5 b) C5 and E5

Spreadsheets Quiz Recap 5

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?