Question

19. Some students are planning a school promotional event. Their first attempt is shown
below.
Number of students paying
$80
Expenditure
Coach Hire
Function rooms
20 Decorations (per room)
Three course meal
12 Soft anns
Cost of
Number Total
each Needed Cost
5000
20000
2100
1250
3 3750
500
150 75000
50
150 7500
3
26
1 Total cost of the Prom
Cost per student
108350
a) What is the cell reference of the shaded cell?
b) Name the data/value types that have been used in this spreadsheet.
c) What formula has been used to calculate the cost per student in D19?
d) Many student say that at the most they will pay 500/- How much money would
be raised by collection? Say you have to enter this in D21, what would you enter?
e)Store in D22 how much extra money must be raised other than collection?​

Answer 1

Explanation:

a) Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row. In a standard spreadsheet, the first column is A, the second column is B, the third column is C, etc.

b) You enter three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters. Values (numbers) are generally raw numbers or dates.

c) you have to search in this app only, OK

d) this also, OK .

e) and this one also

please mark me brain list