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

On an ice rink two skaters of equal - Forgetting in psychology ppt - The major product line decision involves - Planning Business Messages and Writing Business Messages - HR Paper - What are the needs and wants of ancient communities - Ba oh 2 h3po4 - Morganton company makes one product - Comparative advantage theory of international trade ppt - Www lk case pages case4you - Understanding labor practices - Bramhall park medical practice - Assignment ethics in accounting linbarger company - North kew tennis club - Meiotic division beads diagram with crossing over - In a 4 page project proposal written to the leadership of your healthcare organization, propose a nursing informatics project for your organization that you advocate to improve patient outcomes or patient-care efficiency. This must be - Sociology - Case study - Urgent Interpretations and results written-Read instructions before bidding - That means a lot to me - Create a Lesson Plan - From bottom to top how one provider retooled its collections - To bid or not to bid case study - Ritz carlton case study solution - Trait approach to leadership theory - Just walk on by brent staples thesis statement - Journal due in 16 hours - Navy federal membership application - Algebra 2 midterm exam - Faculty of science helwan university - General reserve in trial balance - Grade 3 spelling words - Nsw health vaccination centre 1 figtree drive - What is a purpose statement in research - Discussion - Gordon's 11 functional health patterns examples - Cost per occupied room spreadsheet - Free organic chemistry drawing software - MGT317 Week-5 Final Exam score 87% - Essay - Jim angel holds a $200,000 portfolio consisting of the following stocks: - Religious site visit essay - Kol balish english meaning - Jack canfield train the trainer review - Rock it little red lyrics - The patriot reverend oliver - Bunsen burner flame test - Impact of bantu migration - Jabulani)][@DURBAN HAPPY CLINIC +27835179056 SAFE ABORTION CLINIC//PILLS Tembisa,Soweto,Johannesburg, Pretoria, Germiston MIDRAND BIZANA - Multiple Choices . Answer A/B/C/D/E directly - How to curate wikis on amino - Gram staining lab report pdf - Help needed - Liberty university letter of recommendation - Density mass volume units - Things i'm grateful for - Career Research - Hunter rain clik gutter mount - +91-8306951337 get your love back by vashikaran IN Erode - How to apply chlorsig eye ointment - 40 pound to kg - Specific purpose of persuasive speech - Essay Outline - Discussion Responses 1& 2 - Topic 2 DQ2 - Separation of a mixture of solids lab report - Discussion - Little giant pump model pmo 650 - Journal Article Summaries - Where did the exodusters migrate to apex - Ego and greed she cray - Lia hotel san carlos yelp - Bikini body meal plan - Non automated system in front office - What type of account unearned revenue - Baking soda finger bfp - A cat corp forecasting case solution - Why didn t dexter want a pocket calculator - 6-1 Project 2: Historical Context and Introduction Submission - Distance and bearing between two cities - Mendel conducted his most memorable experiments on - 107nurTRwk2 - Sunbeam channel stuffing - Political cartoon dred scott decision - Hydraulic rod bending machine project report pdf - Ron redmond qld police - How does cancer cause a homeostatic imbalance in the body - Northumbria university blackboard login - The big risk of employing an outsourcing strategy is - Supreme court scavenger hunt answers - Norton park glen waverley - In the xy plane what is the slope - Country phone code 212 - Physical Security Final Research Project - Essay 1 English - Cover page for a report - Bus 499 discussion question - Sub disciplines of exercise science - List five steps of ethical decision making - Assignment