
Question bank 327
12 The data that can be entered onto a spreadsheet comprises which of the following?
A Text and numbers
B Formulae, text and numbers
C Numbers and formulae
D Text and formulae
Questions 13, 14, 15 and 16 refer to the Employment targets and bonuses spreadsheet shown below. This
spreadsheet shows the target sales for each employee (column C) and the amount that they actually sold (column
D). The bonus value is calculated by subtracting the actual sales from the target sales. If the employee has failed to
achieve their target level, then there is no bonus. The target figure for next month (column F) is calculated by
multiplying the target figure by a defined growth rate (cell B15).
A B C D E F G
1
2 Employment targets and bonuses
3
4 Employee No Target Actual Bonus Next month
5 345 Rianne 2,100.00 2,000.00 0.00 2,121.00
6 567 Sian 4,300.00 4,400.00 100.00 4,343.00
7 543 Claire 2,345.00 2,300.00 0.00 2,368.45
8 231 Mark 5,680.00 5,600.00 0.00 5,736.80
9 890 Danny 345.00 500.00 155.00 348.45
10
11 14,770.00 14,800.00 14,917.70
12 Sales staff 5
13 Income/staff 2,960
14
15 Growth rate 1.00%
13 In the spreadsheet what is the formula in C11 (column C row 11)?
A =SUM(C5:C9)
B =TOTAL(C5:C9)
C =SUM(C5:C11)
D =TOTAL (C5:C9)
14 In the spreadsheet the figure in E5 (column E row 5) is calculated by subtracting the value in C5 (column C
row 5) from the value in D5 (column D row 5). However, if the calculated value is negative, then the value
returned in E5 is zero.
In the spreadsheet what is the formula in E5?
A =IF(D5-C5>0,D5-C5,0)
B =IF(C5-D5>0,C5-D5,0)
C =IF(C5-D5>0,0,C5-D5)
D =IF(D5-C5>0,0,D5-C5)