Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

I just need to know what to click to do these steps thanksss

sorry uploaded the wrong chart

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance

Authors: Angelico Groppelli, Ehsan Nikbakht

2nd Edition

0812043731, 978-0812043730

More Books

Students also viewed these Finance questions

Question

How does JIT affect the firms cost equation? CVP analysis?

Answered: 1 week ago

Question

What is the financial outlook of the organization?

Answered: 1 week ago

Question

Determine miller indices of plane A Z a/2 X a/2 a/2 Y

Answered: 1 week ago

Question

What do you think Katsoudas means by the phrase one size fits one?

Answered: 1 week ago

Question

How do you think GM should handle this decision and why?

Answered: 1 week ago