Answered step by step
Verified Expert Solution
Question
1 Approved Answer
B Please save completed excercise file as Excel Exercise-First and Last Name and upload to the google form sent with this file. 4 5
B Please save completed excercise file as "Excel Exercise-First and Last Name" and upload to the google form sent with this file. 4 5 Below is an example of a school's budgeted amounts for expense categories and the actual expense. 6 7 8 9 Personnel Budget 1,000,000.00 Actual 1,250,000.0 10 Curriculum Budget 80,000.00 Actual 85,000.0 12 13 14 15 16 23 24 F27EE72222222 Supplies Budget 55,000.00 Actual 53,000.0 Communications Budget 5,000.00 Actual 3,500.0 Transportation Budget 25,000.00 Actual 27,000.0 School lunch Budget 30,000.00 Actual 28,500.0 17 In Excel or Google Sheets, create a spreadsheet that shows the following: 18 19 1. Percentage each category represents of the school's entire budget 20 2. The dollar amount that the actual expense was over or under your budgeted amount. 21 22 Include Totals for each column
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started