1. Using the Savings worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals.

2. Using the auto format feature, format range A3:D12 in Savings worksheet. Note that values are to be formatted with the thousands separator, TWO decimal places with $ signs on all totals [

Engery Cost Savings (Green Computing) The below data represents cost (expenses) and savings for AGI for all organizational computer use for 2015 and 2016. AGl implemented a green computer initiative in January 2016 1 2 Operating Cost General Green Computer Computer Use Use (2015) (2016) Savings 4 Computer type 5 Notebook Dual Core 6 Notebook Quad Core 7 PC Dual Core 8 PC Core Duo 9500 19500 12500 34500 21200 38050 26450 25000 16109 28200 12450 9000 18490 Servers Core Duo 10 Servers 4 Core Duo 11 Servers Xeon Quad Core18500 12 Total 13 1 Employee Department Contacts Green Savings uarterly Revenue 2015 Statement of Income Agg