spreadsheets 1

Spreadsheets

Create a budget for a new computer system in Microsoft Excel, Open Office Calc, or Google Sheets.

The top row should have column headings with columns for item, price. and URL where you can buy it for that price. Include a column to classify each item as software or hardware. If you will be using free software, include the same information with a price of 0.00

All money should be formatted to show 2 decimal places. Include a grand total as well as a total for software and hardware.

All fields that can be calculated should use equations.

Include a pie graph to show the breakdown of costs.