1 / 13

Day Nine Complete the budget spreadsheet - PowerPoint PPT Presentation

Day Nine Complete the budget spreadsheet Calculator pie chart Enrollment (more charts) Day nine charts plus more charts A Monthly Budget \$36,000 annual salary Take home pay (?) Monthly expenses Food \$400 Rent \$700 Car payment \$250 Electric + gas \$250 Insurance \$200

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

• Calculator pie chart

• Enrollment (more charts)

Day nine charts plus more charts

• \$36,000 annual salary

• Take home pay (?)

• Monthly expenses

• Food \$400

• Rent \$700

• Car payment \$250

• Electric + gas \$250

• Insurance \$200

• Savings + entertainment \$200

• Extra (what ever is left!)

• Monthly take home and expenses

• Total monthly take home pay and dollar expenses

• Expenses as a percentage of monthly take home

• Construct a bar graph

• Take home

• expenses

• Construct a linear graph

• Construct a pie chart

• Expenses as a percentage of take home

Press [APPS] on calculator

Use the arrows to find <CelSheet> and press [ENTER]

press [ENTER] again to take you to the help screen.

Press [GRAPH] which is F5

Choose menu item 3 and type BUDGET [ENTER] [ENTER]

(one enter saves the name and the other takes you to the cell sheet)

In Column A enter the names of the categories: Food, Rent, Car, Ele. and gas, Ins., Sav. and Ent.

You will need to press [ALPHA] [+] to access the quotation marks to put around names.

In Column B enter

the amount for each

Press [GRAPH] which is F5

Choose menu item 4 < Charts…>

Categories: A1:A6 [ENTER]

Series: B1:B6 [ENTER]

Number Percent (make sure you have Number

highlighted)

Title: BUDGET [ENTER]

DRAW [ENTER]

Press [TRACE] to see what each category represents

Pie Charts and Bar Graphs: Computer and Calculator

• K1 Group: the spreadsheet and charts are by K1omputer

• C2 Group: the spreadsheet and charts are by C2alculator using [stat1] (lists)

• C3 Group: the spreadsheet and charts are by C3alculator using [apps] <CelSheet>

• Presentations: by K1, C2 , andC3