Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Recommendations for any products that should be discontinued. The input in the box below will not be graded, but may be reviewed and considered

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
2. Recommendations for any products that should be discontinued. The input in the box below will not be graded, but may be reviewed and considered by your instructor. \begin{tabular}{|l|r|r|r|} \hline 10076 Highlighter, Green, Box & 35 & $10.99 & $384.65 \\ \hline 10076 Binder Clips, Small & 23 & $7.99 & $183.77 \\ \hline 10077 8x11 Heavy Bond, Box & 39 & $54.99 & $2,144.61 \\ \hline 10078 Highlighter, Green, Box & 34 & $10.99 & $373.66 \\ \hline 10080 Legal, Beige, Box & 42 & $64.99 & $2,729.58 \\ \hline 10082 Ballpoint Pens, Blue, Box & 20 & $10.99 & $219.80 \\ \hline 10082 Paper Clips, Large & 41 & $8.99 & $368.59 \\ \hline 10083 Highlighter, Green, Box & 20 & $10.99 & $219.80 \\ \hline 10084 Binder Clips, Extra Large & 29 & $9.99 & $289.71 \\ \hline 10084 Highlighter, Green, Box & 25 & $10.99 & $274.75 \\ \hline 10090 Highlighter, Yellow, Box & 15 & $10.99 & $164.85 \\ \hline 10091 Legal File Folders, Dark Green, Pack of 10 & 2 & $15.99 & $31.98 \\ \hline 100913 Ring Binders, Box of 20 & 10 & $39.99 & $399.90 \\ \hline 10091 Paper Clips, Large & 36 & $8.99 & $323.64 \\ \hline 10092 Pencils, Mechanical, Box & 37 & $8.99 & $332.63 \\ \hline 10095 8x11 Heavy Bond, Box & 35 & $54.99 & $1,924.65 \\ \hline 10095 8x11 Heavy Bond, Box & 18 & $54.99 & $989.82 \\ \hline 10095 Erasers, 50 count & 11 & $4.99 & $54.89 \\ \hline 10096 Ballpoint Pens, Blue, Box & 49 & $10.99 & $538.51 \\ \hline 10096 Legal File Folders, Dark Green, Pack of 10 & 6 & $15.99 & $95.94 \\ \hline 10098 8x11 Glossy Photopaper, Box & 67 & $69.99 & $4,689.33 \\ \hline 10098 8x11 Heavy Bond, Box & 56 & $54.99 & $3,079.44 \\ \hline 10099811 Heavy Bond, Box & 42 & $54.99 & $2,309.58 \\ \hline 10100 8x11 Heavy Bond, Box & 29 & $54.99 & $1,594.71 \\ \hline \end{tabular} Download spreadsheet Excel Item-a43658.xlsx Using the spreadsheet provided, perform the following steps: 1. Open the file and gain an understanding of what data is availab 2. This data has no errors, so we can prepare the data for analysis a. Insert PivotTable. b. Select the data in cells A1 through E50. c. Select New Worksheet to place the pivot table in a separate 3 Ring Binders, Box of 20 811 Glossy Photopaper, Box 811 Heavy Bond, Box A12 Matte, Ream Ballpoint Pens, Red, Box Ballpoint Pens, Black, Box Binder Clips, Extra Large Binder Clips, Small Ballpoint Pens, Blue, Box Erasers, 50 count Highlighter, Yellow, Box Highlighter, Green, Box Legal File Folders, Dark Green, Pack of 10 Legal, Beige, Box Pencils, Mechanical, Box Paper Clips, Small Paper Clips, Large in a new sheet. re ready to perform our IVENTORY NAME and ty sold from SMALLEST xt to the Row Labels he he drop down. fally sort SMALLEST to L i short recommendation Giring Binders, Boxor20 d for a recent month. , Insert Nenctible. i. Cok mots sokr opnows 2. Recommendations for any products that should be discontinued. The input in the box below will not be graded, but may be reviewed and considered by your instructor. \begin{tabular}{|l|r|r|r|} \hline 10076 Highlighter, Green, Box & 35 & $10.99 & $384.65 \\ \hline 10076 Binder Clips, Small & 23 & $7.99 & $183.77 \\ \hline 10077 8x11 Heavy Bond, Box & 39 & $54.99 & $2,144.61 \\ \hline 10078 Highlighter, Green, Box & 34 & $10.99 & $373.66 \\ \hline 10080 Legal, Beige, Box & 42 & $64.99 & $2,729.58 \\ \hline 10082 Ballpoint Pens, Blue, Box & 20 & $10.99 & $219.80 \\ \hline 10082 Paper Clips, Large & 41 & $8.99 & $368.59 \\ \hline 10083 Highlighter, Green, Box & 20 & $10.99 & $219.80 \\ \hline 10084 Binder Clips, Extra Large & 29 & $9.99 & $289.71 \\ \hline 10084 Highlighter, Green, Box & 25 & $10.99 & $274.75 \\ \hline 10090 Highlighter, Yellow, Box & 15 & $10.99 & $164.85 \\ \hline 10091 Legal File Folders, Dark Green, Pack of 10 & 2 & $15.99 & $31.98 \\ \hline 100913 Ring Binders, Box of 20 & 10 & $39.99 & $399.90 \\ \hline 10091 Paper Clips, Large & 36 & $8.99 & $323.64 \\ \hline 10092 Pencils, Mechanical, Box & 37 & $8.99 & $332.63 \\ \hline 10095 8x11 Heavy Bond, Box & 35 & $54.99 & $1,924.65 \\ \hline 10095 8x11 Heavy Bond, Box & 18 & $54.99 & $989.82 \\ \hline 10095 Erasers, 50 count & 11 & $4.99 & $54.89 \\ \hline 10096 Ballpoint Pens, Blue, Box & 49 & $10.99 & $538.51 \\ \hline 10096 Legal File Folders, Dark Green, Pack of 10 & 6 & $15.99 & $95.94 \\ \hline 10098 8x11 Glossy Photopaper, Box & 67 & $69.99 & $4,689.33 \\ \hline 10098 8x11 Heavy Bond, Box & 56 & $54.99 & $3,079.44 \\ \hline 10099811 Heavy Bond, Box & 42 & $54.99 & $2,309.58 \\ \hline 10100 8x11 Heavy Bond, Box & 29 & $54.99 & $1,594.71 \\ \hline \end{tabular} Download spreadsheet Excel Item-a43658.xlsx Using the spreadsheet provided, perform the following steps: 1. Open the file and gain an understanding of what data is availab 2. This data has no errors, so we can prepare the data for analysis a. Insert PivotTable. b. Select the data in cells A1 through E50. c. Select New Worksheet to place the pivot table in a separate 3 Ring Binders, Box of 20 811 Glossy Photopaper, Box 811 Heavy Bond, Box A12 Matte, Ream Ballpoint Pens, Red, Box Ballpoint Pens, Black, Box Binder Clips, Extra Large Binder Clips, Small Ballpoint Pens, Blue, Box Erasers, 50 count Highlighter, Yellow, Box Highlighter, Green, Box Legal File Folders, Dark Green, Pack of 10 Legal, Beige, Box Pencils, Mechanical, Box Paper Clips, Small Paper Clips, Large in a new sheet. re ready to perform our IVENTORY NAME and ty sold from SMALLEST xt to the Row Labels he he drop down. fally sort SMALLEST to L i short recommendation Giring Binders, Boxor20 d for a recent month. , Insert Nenctible. i. Cok mots sokr opnows

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

Accounting And Finance For Non-Specialists

Authors: Eddie McLaney, Peter Atrill

3rd Edition

9780273646327

More Books

Students also viewed these Accounting questions