$2$

$45$ points

The information in the sheet titled "Lego Parts" lists out the individual parts which make up Lego sets in the Lego Architecture series. For instance, the set with the ID $21029-1$ comes with $4$ Fence $141$ parts with the Dark Blueish Gray color. The sheet titled "Lego Architecture $($Names$)"$ gives the names of the sets associated with each set ID$.$

Using this information, perform the following tabulations and reporting actions:

In Column E of the sheet titled Lego Architecture $($Names$),$ put the appropriate difficulty found in the table starting in G$2$ with each set based on the part count listed in column D$.$

In Cell H$9$ of Lego Architecture $($Names$)$ create a dropdown list of all of the potential Lego Set Names listed in column B$.$

In Cells H$10$:H$12$ of Lego Architecture $($Names$),$ have the Debut Year, Part Count, and Difficulty appear which correspond to the Lego Set Name chosen in cell H$9.$

Using the data in the Lego Architecture $($Names$),$ create a clustered column chart which shows the number of parts in each Lego Architecture Set. Give the Chart the title "Lego Architecture Set by Part Count". Make sure the vertical axis is labelled $"$# of Parts" and the horizontal axis is labelled "Set Name". Be sure to move the chart to the side so that all of the original data is still showing.

Merge the data from the "Lego Architecture $($Names$)"$ into the "Lego Parts" dataset so that the Set Name, Debut Year, Part Count, and Difficulty appears in E$,$ F$,$ G$,$ and H of the "Lego Parts" dataset which corresponds to the Set ID listed in column A$.$