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

Ecps instructure com

21/04/2021 Client: muhammad11 Deadline: 2 Day

New Perspectives Excel 2016 | Module 5: SAM Project 1a Forge and Polish Jewelry WORKING WITH EXCEL TABLES, PIVOTTABLES, AND PIVOTCHARTS GETTING STARTED • Open the file NP_EX16_5a_FirstLastName_1.xlsx, available for download from the SAM website. • Save the file as NP_EX16_5a_FirstLastName_2.xlsx by changing the “1” to a “2”. o • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file NP_EX16_5a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. Maureen Meek is doing an internship with Forge and Polish Jewelry. One of her assignments is to format the product sales records from 2018 to 2020 to make it easier to analyze. Switch to the Bracelet worksheet. Unfreeze the top row of the worksheet. 2. Sort the data in the BraceletSales table first in ascending order by the Material field and then in the ascending order by the Embellishment field. 3. Insert a Total Row in the BraceletSales table, and then use the Total Row to calculate the total of the values in both the 2018 and 2019 fields. (Hint: The Total Row should automatically total the values in the 2020 field.) 4. Maureen decides to create a PivotTable to allow her to better manipulate and filter the BraceletSales table data. Create a PivotTable based on the BraceletSales table in a new worksheet using Bracelet PivotTable as the worksheet name. Update the PivotTable as described below so that it matches Final Figure 1: a. Add the Material field and the Product ID field (in that order) to the Rows area. (Hint: The order of the materials should be Gold, Silver, Copper, as shown in Final Figure 1. Sort the PivotTable manually by dragging or by using the Move command if necessary.) b. Add the 2018, 2019, and 2020 fields (in that order) to the Values area. c. Update the Sum of 2018 field in the Values area to display the name 2018 Sales with the Accounting number format with 0 decimal places and $ as the symbol. New Perspectives Excel 2016 | Module 5: SAM Project 1a d. Update the Sum of 2019 field in the Values area to display the name 2019 Sales with the Accounting number format with 0 decimal places and $ as the symbol. e. Update the Sum of 2020 field in the Values area to display the name 2020 Sales with the Accounting number format with 0 decimal places and $ as the symbol. 5. Go to the Necklace worksheet. Format the range A2:G16 as an Excel table with headers using the Table Style Medium 6 table style. Use NecklaceSales as the name of the table. 6. Maureen notices that the NecklaceSales table is missing a record. Add the following record as shown in bold in Table 1 below to the end of the NecklaceSales table: Table 1: New Record for the NecklaceSales Table Product ID Type Material Embellishment 2018 2019 2020 NGPS-123 Necklace Gold Precious Stones $1,820 $1,900 $2,160 7. Forge and Polish Jewelry offerings a large selection of earrings. Maureen wants to summarize the Earring sales data using subtotals to show how the type of Material used influences earring sales. Go to the Earring worksheet and complete the following steps: a. Sort the table by the Material field in ascending order. b. Convert the table to a normal range. c. Insert subtotals into the range A2:G25, with the subtotals appearing at each change in the Material column value. d. The subtotals should use the SUM function and include subtotals for the 2018, 2019, and 2020 fields. (Hint: Make sure to check the summary below data check box if it is not checked automatically.) 8. Go to the Ring worksheet and remove the duplicate record associated with the Product ID of RGGB-200 from the RingSales table. 9. Maureen wants to summarize Forge and Polish Jewelry’s sales data for all products in a PivotTable. To do so, she must first update All Products table. Go to the All Products worksheet and freeze the top two rows of the worksheet. 10. Use the Find command to find the record with a Product ID of BCPP-182. Edit the record by changing the 2019 field value to $1200. Close the Find dialog box.

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:

Quick N Quality
Phd Writer
Professional Coursework Help
Chartered Accountant
Financial Hub
Assignment Solver
Writer Writer Name Offer Chat
Quick N Quality

ONLINE

Quick N Quality

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$41 Chat With Writer
Phd Writer

ONLINE

Phd Writer

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$39 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I have read your project details. I can do this within your deadline.

$41 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$15 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I have read and understood all your initial requirements, and I am very professional in this task.

$39 Chat With Writer
Assignment Solver

ONLINE

Assignment Solver

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$36 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

Critical Thinking - Mcdonalds french fries vegetarian lawsuit - Ansi asq z1 9 pdf - Electromagnetic induction lab answers - Essay english - Characteristics of the church - Good vision statement characteristics - Duration tempo intensity scope setting and chronology are - Business law essay questions and answers - Determine a total category lcnrv evaluation - Public Administration Assignment 1 - How to draw esters - What is earth continuity - Logbook sample for student - Dr irene man hsiao hazleton office - Dr ben terkasher reviews - Icare concept to interprofessional teams - Beaker on hot plate - Us based mncs commonly invest in foreign securities - Bus 499 peregrine assessment answers - Ethics in research - Ticket reservation system project - Credentialed community language test - Defining moments for jack in lord of the flies - Mitosis and meiosis lab 5 answers - Fire service manual volume 1 - Laplace transform of sint cost - Order 2087248: Academic skillst - Apa article critique - To https cs signal army mil dodiaa default asp - DNP - Kung fu punctuation resources - Research Proposal 1.0 - Employer employee loyalty is an outdated concept - Pentecostal churches in preston lancashire - Technical name for alcohol crossword clue 7 - I ask my mother to sing analysis - Alyogyne huegelii blue heeler - Performance lawn equipment case study - Properly tied pullover brown frost - Unit 4 business communication p5 p6 m2 - Why follow manufacturer's instructions - Alternative procedures in the confirmation of accounts receivable - Quantitative Research - Assignment - Human ecology current events article 2018 - Classifying liabilities as either current or long-term helps creditors assess: - Executions should be televised - Smileline inc has an onsite daycare facility - MAN 4162 Assignment - Chartered engineer interview presentation - Block style business letter template word - Ata 2200 chapters list - Homework: Demand forecasting (250 words) - Maned wolf interesting facts - The devil's arithmetic chapters 17 epilogue questions and answers - Hy dairies case study analysis - Hoppy's parts r us geraldton - Yarn measure equivalent to 18 hanks - Bombing of darwin interactive - NEED DISCUSSION IN 18 HOURS or LESS - Define family resource management - Apply tort and criminal law irac case brief - How to add french accents in word - Sleep deprivation and iq - A reducing medium contains - What is informed opinion - Square inc financing a unicorn case solution - What makes a good advert - Psychology a level grade boundaries - One page - Booker t washington and web dubois similarities - Informative Outline - Pensioner services online pss - Hot coffee movie summary - Assignment - Milliohm meter circuit schematic - Richard winsor street dance - 3 person in english - Why did smithson chose the inaccessible, inhospitable utah location for spiral jetty? - Single phase ac voltage controller ppt - General ecology lecture notes - Australian guide legal citation - 3 4x 6 7x simplify - Anz credit card hotline - Negotiation readings exercises and cases 6th edition pdf - Musykiones - T55 flour equivalent australia - CC2 - How do glaciers cause erosion - Solve the inequality 4x 1 11 - Explain Nola Pender's model and how can you apply it to your nursing practice. Explain in 150 words - Is heinz beans halal - Late submission penalty uts - Brain imaging studies support the conclusion that meditation _____ - Week 5 Tort Questions - Managing Organizational Cultural Change and Sustainability - Se habla espanol tanya barrientos analysis - Describe and evaluate two theories of the formation of relationships - Confronting without offending by deborah pegues