Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I just need to know what to click to do these steps thanksss sorry uploaded the wrong chart 5. Go to the Necklace worksheet. Format
I just need to know what to click to do these steps thanksss
sorry uploaded the wrong chart
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. (Hint: Depending on your version of Office, the table style may be named Blue, Table Style Medium 6 instead.) 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 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. Forge and Polish Jewelry Forge and Polish Jewelry Sales Rernrde - on1o monn 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. (Hint: Depending on your version of Office, the table style may be named Blue, Table Style Medium 6 instead.) 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 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. Forge and Polish Jewelry Forge and Polish Jewelry Sales Rernrde - on1o monn
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started