Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

University Auditing In The Digital Era Challenges And Lessons For Higher Education Professionals And CAEs

Authors: Sezer Bozkus Kahyaoglu; Erman Coskun

1st Edition

0367553228, 9780367553227

More Books

Students also viewed these Accounting questions