Computer Science, asked by Ashutoshjah, 3 months ago

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

Answered by varsha6033
6

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.

Answered by nakabposh41
5

Answer:

how is this hope it's help you mark at brainlist

Attachments:
Similar questions