Question

Q26. Some students are planning a 5 points
School Promotional Event. Their
first attempt is shown below.
Answer questions 1 to 5 based on
below spreadsheet.
Your answer
Number of students paying 150
Cost of
Number Total
Expenditure
Needed
Coach Hire
Tood
4
20000
unction roomie
2100
Decorations (per room)
The course meal
100
150 75000
Soft drink
50
160
7600
700
10
100360
Total cost of the from
792 33
16 Cost per student
1. What is the cell reference of the shaded cell?
2. Name the data/value types that have been used in this spreadsheet
3. What formula has been used to calculate the cost per student in 197
4. Many students say that at the most they will pay Rs 5007. How much money would be raised
by collection? Say you to enter this in cell D21, what would you enter?
5. Store in D22 how much extra money must be raised other than collection?​

Answer 1

Answer:

calculate in your phone