Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A. Jose, a college working student wants to create a budgeting spreadsheet application for a month's worth of financial activity. Create a similar Budgeting Spreadsheet
A. Jose, a college working student wants to create a budgeting spreadsheet application for a month's worth of financial activity. Create a similar Budgeting Spreadsheet Application following the lesson discussed earlier with the data provided in Figure 2.16. It must have two (2) tabs namely Allowance & Expense and Summary. Income Amoun Expense Amount Parent's Allowance 9500 Food P850 Sallary 95.000 Transport 2700 Extra Income 2300 Dormitory 21,000 P5,800 School Expenses P1,750 School Supplies P250 Misc 2500 P5,050 Figure 2.16 Jose's Budgeting Date The Allowance & Expense tab contains Jose's source of income and its amount as well as his expenses and amount. Follow the formatting as seen in Figure 2.16. The Summary tab must contain a summary of the total income,expense, and the remaining money along with the pie chart. This is similar to what you did in the discussion. 1. How does a Spreadsheet application improve the presentation of your data? 2. What is the main advantage of using a Spreadsheet in terms of organizing and sorting data? B. My Budgeting Application Using data from the previous activity in the lesson My Expenses, create a Similar Budgeting Spreadsheet Application. It must have three (3) tabs namely: Allowance, Expense and Budget Summary. Like the activity earlier, Allowance tab contains your source allowance and income if any) and its amount. The Expense tab contains different expenses and their amount. The Budget Summary tab must contain a summary of the total income, expense and the remaining money
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