You are working on a spreadsheet that uses the miles per gallon of a hybrid car. See worksheet Vehicle in the Excel file.

What Excel formula should be typed into cell C8 to match the Gas Only miles per gallon of whichever car is entered into cell A8?

You are working on a spreadsheet to make a decision about opening a new business. See worksheet Qty Sold in the Excel file.

What Excel formula should be typed into cell B3 to calculate the Qty Sold?

\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ B3 } & \multicolumn{1}{|c|}{} & X & fx & \\ \hline & A & B & C & D & E \\ \hline 1 & Supply & 1,480 & & & \\ \hline 2 & Demand & 1,340 & & & \\ \hline 3 & Qty Sold & & & \\ \hline 4 & & & & \\ \hline 5 & & & & \\ \hline 6 & & & & \\ \hline 7 & & & & \\ \hline 8 & & & & \\ \hline 9 & & & & & \\ \hline 10 & & & & \\ \hline \end{tabular}