Using the "Green Savings" worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals.
 b. Using the auto format feature format range A3:D12 in "Green Savings" worksheet. Note that values are to be formatted with the thousands separator, ZERO decimal places
Following are formulas for above requirement: Cell D5 formula: =B5-C5 Then copy the... View the full answer
Sign up to view the full answer
To calculate the savings, you will need to subtract 'Green Computer Use' from 'General computer use' ( =B5 - C5) using the... View the full answer