excel assignment, due 10 hours later
Nancy 00001excel 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
Purchase the answer to view it
- AnswerDocument.docx
Purchase the answer to view it
- Task2and3.xlsx
- ExcelBasicsAssignmentSpreadsheet.xlsx
- Music response 1-page paper
- South Africa case study on page 145 and answer the four questions presented at the end of the chapter.
- Look at Tootsie Roll Industry Inc.'s most current annual report. $10.00 Focus on the Balance Sheet, which Tootsie Roll Industries Inc. titles Consolidated Statements of Financial Position, and the notes following the financial statements. Answer the foll
- Discussion
- Operation Management 2
- unit III assessment
- read the instructions and tutor comments and make corrections in my journals - if you can complete by Sunday Midnight, it will be great
- week.5.1
- Short answer
- Article Review!