Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel volume 1 grader project capstone

20/10/2021 Client: muhammad11 Deadline: 2 Day

Chapters noted above.

ASSIGNMENTS Use these instructions for ALL your assignments. PLEASE ASK IF YOU NEED CLARIFICATION.

Submit the complete assignment to the assignment drop box in the Learning Hub www.learn.bcit.ca

Prior to submitting:

 All submitted assignments must be in good presentation order. Treat your work as if you are presenting to

a current or potential employer or client. Marks will be deducted from the overall assignments for

submissions not in a presentable format.

 Presentation format means it is suitable for distribution to an audience both on-screen and in print form.

Use print preview to show what your assignment will look like. Each previewed page must not have any

text, tables or charts cut off or orphaned. Orphan rows and columns must be fixed prior to submission.

 Ensure all assignments are placed in the order of the exercises stated and the sheets are labelled

accordingly. No additional sheets or files should be included. This will facilitate more timely feedback.

 Email of assignments will not be accepted. No exceptions. Only assignments submitted to the correct

Learning Hub drop box will be marked. No printing is required.

 Assignments are due as per the date in the drop box in the Learning Hub and on the course outline. All

assignments must be completed individually. Late assignments, if accepted, may only be considered for

marking with penalty unless otherwise previously agreed upon.

 Check the course outline for % associated with your assignments.

 Additional exercises from the textbook or instructor may be added to assignments as required for the needs

of the class. Additional work will be announced at the end of each session. Please ensure you are present

to note additional work assignments.

http://www.pearsonhighered.com/exploring
http://www.learn.bcit.ca/
2 ©Gerrard 2016 – amd Atha 2016/2017/2018/19 Assignment 1

Assignment 1A

1. Open e05b2games.xlsx and save it as Yourname_Assignment_1A.

2. Click on the Salary Data tab. Copy this worksheet three times. You will now have four worksheets with

the same data. Easiest way is to hold down the CTRL key and drag the sheet and release. This will copy

the worksheet.

3. Rename the second sheet to By Department and Title; the third sheet By Gender and the fourth My

Pivot. Change the tab colour of all four sheets to blue.

4. In the Salary Data worksheet, sort by Performance and subtotal the salary by Performance. 5. In the By Department and Title worksheet, sort by department and title and then calculate the average

salary by subtotalling by department and title. 6. In the Gender worksheet, do a count of the number of salaries paid by gender using a subtotal.

7. Using the data from the My Pivot worksheet create your own pivot table in the same worksheet to show

the salaries for each department by title and gender.

8. Copy the My Pivot worksheet twice. Rename one of the new worksheets as Pivot Chart and the second

one as Formatted Pivot.

9. In the Pivot Chart worksheet, create a pivot chart and then use the chart filters to limit the chart to the

Animation, Art, Game Design and Production departments by gender. Change the Y Axis to thousands.

The pivot chart works just like the ordinary charts with the exception of the filters.

3 ©Gerrard 2016 – amd Atha 2016/2017/2018/19 Assignment 1

10. In the Formatted Pivot worksheet, complete the following:

a. Change the report layout to Tabular form.

b. Change the style to Pivot Style Medium 15.

c. Change to summarize by Average Salary.

d. Insert a slicer for Department and select Animation.

11. Save the file.

Assignment 1B

1. Complete the Capstone Exercise at the end of Chapter 6 Page 451. The required file for Assignment

1B, e06c1Manufacturing, is included in the Chapter 6 folder in the content area in the Learning Hub.

2. Save your file as Yourname_Assignment 1B_C.xlsx.

There’s more………..flip over the page…..

4 ©Gerrard 2016 – amd Atha 2016/2017/2018/19 Assignment 1

Assignment 1C

1. Open Studio.xlsx. This is not the same as the one from the Chapter. Copy the Loan worksheet to your

Yourname_Assignment 1B_C workbook. Rename the worksheet as Assignment 1C.

2. Complete the worksheet by:

a. Entering the Beginning Balance in B13 by referencing the Input Area.

b. Entering the Monthly Payment in C13 by referencing the Input Area.

c. Calculating the Interest Paid, Principal Reduction and Ending Balance in row 13.

d. Calculating the Cumulative Interest and Cumulative Principle.

e. Auto filling the balance of the table.

3. Save the file to the Yourname_Assignment 1B_C workbook.

Ensure all required files are uploaded to the Learning Hub.

There are two files to be submitted:

Yourname_Assignment 1A and Yourname_Assignment 1B_C

Please ensure the files are named correctly.

Other files (i.e. jpg, png, docx) will not be reviewed/marked.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Engineering Solutions
Financial Assignments
Top Academic Tutor
Fatimah Syeda
Calculation Master
Assignment Solver
Writer Writer Name Offer Chat
Engineering Solutions

ONLINE

Engineering Solutions

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$24 Chat With Writer
Financial Assignments

ONLINE

Financial Assignments

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$19 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$26 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$32 Chat With Writer
Calculation Master

ONLINE

Calculation Master

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$34 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$18 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Reaction paper about magna carta - Hurricane katrina latitude and longitude - 75 in lbs to nm - Mlc v evatt 1968 case summary - 1.2 6 maximizing motor power vex answer key - Gruffalo sequencing cards sparklebox - The many identical residents of whoville love drinking zlurp - Standard 5 care certificate answersscientific method game walk the plank - How secure is my password net - History 1-2 - You can show only one diagnosis code in block 21 - Herts grid for learning - Http communitycoffee com flymore - Why is a rectangle not a kite - What is the problem and solution in cinderella - Marketing management 12th edition - Relationship (Girl Boy) 91–9829644411 love vashikaran specialist molvi ji. - Explain why goals should follow the aeiou theory - Operational vs analytical database - Narrow and wide span of management - Cirque du soleil macau 2019 - Biology Week 5 - Victim facilitation - The perfect picture james thom pdf - Zahi hawass net worth - English sba reflection 2 outline - Umea university sweden world ranking - Deliverable 6 - Corporate Memo on Ethical and Legal Concerns - Eureka ca seismic station sp interval - Dulux texture full cover roll on - Acara work samples year 3 writing - Gen lib rus esc - Paper 1 - Backslap sunscreen applicator - Compare Statista 2019 canada and south korea - Winter solstice hilda morley analysis - Bowling for columbine purpose - Planning process of apple company - Week 5 Discussion - Course name : Ethical/Legal Aspects of Management - How to identify the precipitate in a reaction - In praise of the f word - Aova international ind southport - Popped secret the mysterious origin of corn answer sheet - Nursing Theory Application Brochure - Hypertrophy training program pdf - NR 509 shadow health Tina jones foot overview, complete solution - Hl7 oru message example - Wk 6 - Educational Technology Toolkit [due Mon] Wk 6 - Educational Technology Toolkit - Three beads are placed along a thin rod - As 1684 span tables - 1-2 page assignment - Walden university nursing specialty comparison matrix - Pseudo families in women's prisons - Big Developments in E-Business - 6 pages - APA - 5 references - Due 31 October - Download gns3 0.8 6 - Research Paper - Rolle rolle with a dab of ranch - Strategic alignment model henderson and venkatraman 1993 - Love and friendship by emily bronte analysis - Current issues in accounting and accounting information systems - Career Exploration Paper - Think good feel good age range - Peer review process - Sap pp training syllabus - Kegan and lahey self transforming mind - What is a service channel - Julie's pawn & jewelry sales flint mi - Investigating the social world 7th edition - Fashion stork out of business - Describe the processes used in developing and managing data warehouses - How to do pmt function in excel 2013 - Data structures and algorithms in java edition - Which of the following is true regarding data analysis - What kind of mark does gandalf put on bilbo's door - Elkay plumbing products division case solution - Voltage divider rule parallel - Asus p6x58 e pro manual - 8 comma rules powerpoint - 12.2 the structure of dna answers - Fire pump acceptance test checklist - Stanford university press address - Tia 942 floor loading capacity - Survey Proposal Assignment - 7000 tcp open afs3 fileserver - Propaganda in harrison bergeron - Baker edu solar - What does gns mean in shops - Turabian table of contents format - Principles of accounting chapter 1 homework answers - Romans 16 25 27 - If the tension developed in either cable ab or ac - Inspire education training and assessment - Operations management assignment 1 - 4 functions of nonverbal communication - Attention grabber examples for speeches - Political - English composition Q1 - Compare and contrast primary and secondary active transport - Types of job redesign