Excel assignment, due 10 hours later

excel assignment, due 10 hours later

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.