Problem $2$: In worksheet Problem $2,$ two tables have been created. Table $1$ needs to be

completed. Table $2$ contains information only.

In cell B$4,$ create a drop$-$down menu so the user can choose from one of the Metals

listed in the first column of Table $2.$

In cell B$5,$ the value for Specific Gravity associated with the Metal chosen in B$4$ should

appear.

In cell B$6,$ the value for the Hardness associated with the Metal chosen in B$4$ should

appear.

In cell $B7,$ calculate the number of Metals with a Hardness value LESS than the value

shown in cell B$6($the metal chosen$).$

In cell B$9,$ have Excel output the Metal which has the lowest Hardness value. This may

NOT be hardcoded, and should change if Hardness values are modified.

PLEASE SHOW ALL THE FORMULA STEP BY STEP.