Question: Formulas Classwork H W 1 0 : Section 8 . 1 Write the formula and make the calculations t o complete the spreadsheet. Show your

Formulas Classwork
HW10: Section 8.1
Write the formula and make the calculations to complete the spreadsheet. Show your work."
?ABc1The7thInningBudgetedOperatingExpenses??2???3ExpenseBudgetAmountPercentofTotalBudget4???5SalariesB5$42000.00C56Rent$36000.00?7Depreciation$9000.00?8UtilitiesandPhone$14500.00?9TaxesandInsurance$14000.00?10Advertising$3500.00?11Purchases$120000.00?12Other(2)$500.00?13???14TotalB14C14
Show the formula for each possible cell and then give the answer.
Example: B14=B5+B6+B7+B8+B9+B10+B11+B12or?S=um(B5:B12)
B14=239,500.00
Example: C5=B5B14*100
C5=
C6=
C8=
C9=
C10=
C11=
C12=
C14=
Formulas Classwork H W 1 0 : Section 8 . 1 Write

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!