From this Excel spreadsheet, what information can be used to create a chart?a) Can this information be used to make a pivot chart?b) Provive an example of a chart made from this information. 2020 ENDING QUARTER HOUSEHOLD BUDGETIncomeOctoberNovemberDecemberQuarterSummer's Income$4,333.33$4,333.33$2,242.50$4,333.33$12,999.99John's Income$2,212.50$2,242.50$6,575.83$6,697.50Total Income$6,545.83$6,575.83$19,697.49Deductions$959.68$964.08$964.08$2,887.83Net Earnings$5,586.15$5,611.75$5,611.75$16,809.66HousingMortgage$1,857.00$1,857.00$1,857.00$5,571.00Home Owners Insurance$215.00$215.00$215.00$645.00H.O.A Fee's$30.00$30.00$30.00$90.00Family Insurance$105.00$105.00$105.00$315.00Metro Phone Service$120.00$120.00$120.00$360.00Excel Electricty$144.10$138.51$132.41$415.02Fort Collins Utilities/ Gas$133.89$94.88$108.24$337.01City of Fort Collins Water$92.01$115.22$99.01$306.24Xfinity Internet$25.00$25.00$25.00$75.00Housing Totals$2,722.00$2,700.61$2,691.66$8,114.27OtherCar Payment$240.00$240.00$240.00$720.00Progressive Car Insurance$160.00$160.00$160.00$480.00Gas (Transportation)$180.00$115.00$98.00$393.00Sheet1 Car Maintenance$401.02$500.00$0.00$100.00$48.73$449.75C.B. Credit Card$74.23$24.96$674.23Sally's Credit CardFood$208.00$0.00$232.96$800.00$800.00$800.00$2,400.00Household Supplies$87.77$40.00$40.00$167.77Misc.$300.00$100.00$100.00$500.00Other Totals$2,876.79$5,598.79$1,555.00$1,585.92$4,277.58$6,017.71Subtotal$4,255.61$14,131.98Balance-$12.64$1,368.78$1,334.17$2,677.68SavingsChristmas Funds19%$260.07$253.49$508.76EmergencyKids College27%$369.57$360.23$722.9727%$369.57$360.23$722.97Vacation27%$369.57$360.23$722.97Savings Totals100%$1,368.78$1,334.17$2,677.68Ending Balance-$13.45$0.00$0.00$0.00

Answered: From this Excel spreadsheet, what…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

From this Excel spreadsheet, what information can be used to create a chart?

a) Can this information be used to make a pivot chart?

b) Provive an example of a chart made from this information.

2020 ENDING QUARTER HOUSEHOLD BUDGET
Income
October
November
December
Quarter
Summer's Income
$4,333.33
$4,333.33
$2,242.50
$4,333.33
$12,999.99
John's Income
$2,212.50
$2,242.50
$6,575.83
$6,697.50
Total Income
$6,545.83
$6,575.83
$19,697.49
Deductions
$959.68
$964.08
$964.08
$2,887.83
Net Earnings
$5,586.15
$5,611.75
$5,611.75
$16,809.66
Housing
Mortgage
$1,857.00
$1,857.00
$1,857.00
$5,571.00
Home Owners Insurance
$215.00
$215.00
$215.00
$645.00
H.O.A Fee's
$30.00
$30.00
$30.00
$90.00
Family Insurance
$105.00
$105.00
$105.00
$315.00
Metro Phone Service
$120.00
$120.00
$120.00
$360.00
Excel Electricty
$144.10
$138.51
$132.41
$415.02
Fort Collins Utilities/ Gas
$133.89
$94.88
$108.24
$337.01
City of Fort Collins Water
$92.01
$115.22
$99.01
$306.24
Xfinity Internet
$25.00
$25.00
$25.00
$75.00
Housing Totals
$2,722.00
$2,700.61
$2,691.66
$8,114.27
Other
Car Payment
$240.00
$240.00
$240.00
$720.00
Progressive Car Insurance
$160.00
$160.00
$160.00
$480.00
Gas (Transportation)
$180.00
$115.00
$98.00
$393.00
Sheet1

Car Maintenance
$401.02
$500.00
$0.00
$100.00
$48.73
$449.75
C.B. Credit Card
$74.23
$24.96
$674.23
Sally's Credit Card
Food
$208.00
$0.00
$232.96
$800.00
$800.00
$800.00
$2,400.00
Household Supplies
$87.77
$40.00
$40.00
$167.77
Misc.
$300.00
$100.00
$100.00
$500.00
Other Totals
$2,876.79
$5,598.79
$1,555.00
$1,585.92
$4,277.58
$6,017.71
Subtotal
$4,255.61
$14,131.98
Balance
-$12.64
$1,368.78
$1,334.17
$2,677.68
Savings
Christmas Funds
19%
$260.07
$253.49
$508.76
Emergency
Kids College
27%
$369.57
$360.23
$722.97
27%
$369.57
$360.23
$722.97
Vacation
27%
$369.57
$360.23
$722.97
Savings Totals
100%
$1,368.78
$1,334.17
$2,677.68
Ending Balance
-$13.45
$0.00
$0.00
$0.00

Expert Solution

Information can be used to create a chart

1.Select data for chart

2.Select Insert > Recommended chart

3.Select a chart on the Recommended charts tab, to preview the chart. you can also select the data which you want in the chart and press ALT + F1 to create chart immediately.

4.Select a chart

5.Select OK

a) Can this information be used to make a pivot chart?

No, this information cannot be used to make pivot chart.

It contains following errors.

Step by step

Solved in 3 steps with 5 images

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions