EXCEL Assignment 3 (EBILL)

The following table shows details of electricity meter readings for ten different customers:

Enter this data onto a spreadsheet and save the file..

Complete the following tasks:

Add a Units Used column to show the number of units of electricity used by each customer (Hint: Subtract the Previous Reading from the Present Reading).

The cost of one unit of electricity is 0.08. Add a Unit Cost column to show the cost of one unit. (This column will contain 0.08 in all of the relevant cells).

Add a Units Charge column to show the total cost of the units used by each customer. (Hint: Unit Cost * Units Used)

There is a standing charge of 13.60 on each customer's account. Add a column to display this Standing Charge. (This column will contain 13.60 in all of the relevant cells).

Add an Amount Payable column to show the total amount each customer must pay the electricity board (Hint: Units Charge + Standing Charge).

Insert a new row above Denise Martin's details. Enter the following data on Lisa Glover's account in this row:

Previous Present 23488

Reading Reading 29046

Obtain the total amount payable by Lisa.

• Format the last four columns to currency format.
• Save the spreadsheet.
• Submit via e-mail.