SUPERSTORE ASSIGNMENT

Requirements:

Work through the instructions below. As you work, you$$ll be asked to:

$$ Follow the steps to perform the required analysis.

$$ Answer questions. You will save your answers to these questions in the Excel VLOOKUP Screenshot Answer Sheet.

$$ Paste $5$ Screen Clippings into the Excel VLOOKUP Screenshot Answer Sheet.

Many of the instructions in the Superstore Assignment are very similar to those found in the Intro Assignment. If you get stuck, you should use the Intro Assignment as a resource to help you get un$-$stuck. Questions $9-20$ have a $$Check Figure$$ section below each question$/$Screen Clipping. In the $$Check Figure$$ section, there are some answers that you can compare to your work. If you get the same answers as the $$Check Figure$$ answer, it is likely that your answers to the actual question will be correct. Remember to fill out your answers in the Excel VLOOKUP Screenshot Answer Sheet. Have fun!

Section $1$: Examine the Superstore Data.

$$ Open the Superstore data file and look at the Order Info tab.

$$ The Superstore data file is a fictional open source dataset that contains a variety of order data for a company that does wholesale equipment sales across the US$.$

o You should see $22$ different columns that correspond to a variety of different categories.

o You should also see that there are $9994$ rows $($the top row doesn$$t count as it is the header row$).$

o You should also see that the Row IDs are color coded with five colors. They have been color$-$coded based on the table they will be in$.$

o There are additional tabs $($Customer$,$ Employee, Order, OrderLine ID$,$ and Product$)$ along the bottom of the worksheet that have the data sorted by their eventual table location. Notice, those tabs have the same colors as the Row IDs.

$$ Click the Order Recreation tab.

o You should see all the columns from all the color$-$coded tabs $($Customer$,$ Employee, Order, OrderLine ID$,$ and Product$).$

$1)$ How many Columns$/$Rows$/$Individual Values are found in the Order Info tab?