excel assignment, due 10 hours laterYou will do these 3 tasks: 1) Rename Sheet2 as Task 2 2) enter data Month Rent Gas Water Total Jan 100 80 100 Feb 150 85 80 Mar 200 90 90 Apr 150 95 120 May 200

You will do these 3 tasks:

1) Rename Sheet2 as Task 2

2) enter data

Month Rent Gas Water Total

Jan 100 80 100

Feb 150 85 80

Mar 200 90 90

Apr 150 95 120

May 200 100 110

Jun 220 105 152

Jul 240 110 125

Use Auto Sum to add your data

3) Create a simple formula- Insert a new column Revised Rent between rent and Gas...Revised rent is 5 percent added to Rent ( = Rent (Rent*5)/100)

4) Apply a number format, Add Meaning to data using Quick Analysis tool ( available in Excel 2013 and 2016 onward). Ctrl Q shortcut

5)Show total/average, Show your data in a chart

Task 3)

Download a copy of the PhoneBill.xls Excel spreadsheet file. Copy the Data into Sheet 3 (rename it as Task 3)

Inside task 3 Sheet ...update rate as 5% increase.(Rate Rate*0.05), recalculate in total.

Create New Pie chart with- total/country and new rate/country

The first and second file is requirements, please follow all.