excel assignment, due 10 hours later

profileNancy 00001

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.

  • 4 years ago
  • 20
Answer(2)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    AnswerDocument.docx

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    Task2and3.xlsx
  • attachment
    ExcelBasicsAssignmentSpreadsheet.xlsx