1) Identify the formula used to find the total cost of 1 chocolate cake and 2 chocolate biscuits? a) =D3 + D4 b) =B3 + B4 c) =D3 * D4 d) =C3 + C4 2) Identify the symbol used to represent multiply of times in a spreadsheet formula? a) + b) x c) / d) - e) * 3) Identify the symbol used to represent divide in a spreadsheet formula? a) + b) - c) x d) / e) * 4) Identify the formula that will calculate the total cost of 4 chocolate bars and 2 chocolate lollipops. a) =C6 + C8 b) =C6/C8 c) =D6 + D8 d) =B7 * B8 5) Identify the correct formula that calculates the difference in cost of 1 chocolate muffin and 1chocolate cake. a) =D7 - D3 b) =C7 - C3 c) =B3 * B8 d) =B7 -B3 6) Identify the correct formula for working out the cost of 1 chocolate lollipop? a) =D8/C8 b) =D8 + C8 c) =D8 - C8 d) =D4/C4 7) Identify the correct formula for working out the cost of 4 chocolate bars. a) =B6+B6+B6+B6 b) =B6*4 c) =B6 * C6 8) Identify the formula that will calculate the total cost of chocolate ice creams and chocolate muffins sold. a) =B5 + B7 b) =D5 + D7 c) =C6 +C7 d) =A4 + A5 9) Identify the correct formula for adding all the costs together. a) =B3+B4+B5+B6+B7+B8 b) =sum(B3:B8) 10) Identify the formula used to calculate the cost of 5 chocolate ice creams a) =B5 * C5 b) =B5 +B5+B5+B5+B5 c) =B5 * 4

Cell Referencing and Basic Formula

打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？