NP_EX16_5a_EdgarSaldana_Report_1

NP_EX16_5a_EdgarSaldana_Report_1 - New Perspectives Excel...

This preview shows page 1 - 2 out of 21 pages.

New Perspectives Excel 2016 Module 5: SAM Project 1a Edgar Saldana GE ver. 5.78 1. 0/6 Unfreeze rows. In the Bracelet worksheet, the top row should not be frozen. 2. 6/6 Sort a table on multiple ranges. 3. 6/6 Insert a total row in a table. Summarize table data with a total row. 4. 3/6 Create a PivotTable. Add rows to a PivotTable. Add values to a PivotTable. Modify the number format of a PivotTable. Modify the number format of a PivotTable. Modify the number format of a PivotTable. 5. 4/6 Create a table. Add a style to a table. Set the name of a table. In the Necklace worksheet, the table in the range A3:G16 should be named "NecklaceSales". 6. 6/6 Add a record to a table. 7. 6/6 Sort a table. Convert a table to a range. Insert subtotal rows in a range. Set options for subtotalling data. Add a grand total to subtotals. 8. 6/6 Delete a record from a table. 9. 0/6 Freeze rows. In the All Products worksheet, rows 1 and 2 should be frozen. 10. 0/6 Enter a number in a cell. In the All Products worksheet, cell F41 should contain the value 1200. 11. 6/6 Filter a table on multiple fields. 12. 6/6 Refresh PivotTable data. 13. Apply the Pivot Style Medium 13 PivotTable style to the PivotTable. 7/7 Apply a style to a PivotTable. 14. 4/7 Add a filter to a PivotTable. Filter a PivotTable. 15. 7/7 Add a slicer to a PivotTable. Resize a slicer. Filter a PivotTable using a slicer. 16. 7/7 Create a PivotChart. Resize and reposition a PivotChart. Add a title to a PivotChart. Filter a PivotChart. SUBMISSION #1 | SCORE IS: 74 OUT OF 100 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. 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. 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.) 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.
Image of page 1

Subscribe to view the full document.

Image of page 2
  • Winter '08
  • Johnsmith
  • Computer Security, glass beads, Jewellery, precious stones, Product ID, Polish Jewelry, PivotTable.

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern