Shriya is planning her friend's birthday party. She has created a spreadsheet to make an es
of the expenditure.
А
B
С
D
1
PARTY EXPENSE
2
Number of Guests
75
3
Item
Unit Cost Total Cost
4
Buffet
75
120
5
Hall Decoration
500
6
Return Gifts
69
20
7
Disco Stage
1000
8
Hall Charges
11 5000
Total Expense
9
Guess the formulae she will write in the following cells:
D4
Answers
Answer:
PLEASE MARK ME AS BRAINLIEST ANSWER
Explanation:
Students create a birthday party budget using a spreadsheet to show how much they have to spend ($100.00), the total costs of the items they buy, and how much they are over or under the budget amount. Students create a chart of the costs ONLY. Hint: select only the items in column A and the costs in column D to create the chart.
Students use formulas to calculate each item's cost (quantity x price each), the total expense costs (use autosum Σ), and the (over)/under budget amount (allowance - total cost).
Students may format their spreadsheet with a title, different fonts, colors, sizes for improved clarity and appearance. Students stick to the budget. Students research online stores (amazon, walmart, other) to find their party items and prices.
Answer: