Build a summary sheet $($called Efficiency Summary$)($that will allow users to quickly pick two vehicles from two different drop$$down lists $($data validation$))$

using the column labeled "Car Name $($for lookup$)"$ from the Car$\_$Fuel$\_$Efficiency sheet to populate the lists. This should be the landing sheet when users open the workbook.

The summary sheet should display fuel information $($for each of the selected cars$)$ from these four columns using lookup functions:

The ranking of the Annual Fuel Cost $$ Conventional Fuel

City FE $$ Conventional Fuel

Highway FE $$ Conventional Fuel

Combined FE $$ Conventional Fuel

Have the cell with the "Combined FE $$ Conventional Fuel" number shaded green if the car's "Combined FE $$ Conventional Fuel" is above $30$ and red if the car's "Combined FE $$ Conventional Fuel" is below $20.$

Make sure to$...$

Lines $-$ Remove the gridlines on the summary sheet.

Input $/$ Output designation $-$ Clearly label and format appropriately Input and Output cells $($i$.$e$.$ use appropriate number formatting and use color$).$

Typos and Errors $-$ Check spelling.

First Impressions $-$ Scroll every sheet to the top left, select cell A$1.$

First Impressions $-$ Make the Efficiency summary sheet the "landing page" when the workbook is opened and is in the first position of the workbook. H$3$

Car Name $($for lookup$)$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline Drive Desc & City FE $-$ Conventional Fuel & Highway FE $-$ Conventional Fuel & Combined FE $-$ Conventional Fuel & Annual Fuel Cost $-$ Conventional Fuel $\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Front & $24$ & $34$ & $28$ & $1750\backslash \backslash$

$\backslash$hline All Wheel Drive & $21$ & $27$ & $23$ & $2100\backslash \backslash$

$\backslash$hline All Wheel Drive & $21$ & $26$ & $23$ & $2100\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Front & $22$ & $28$ & $24$ & $2050\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Front & $22$ & $27$ & $24$ & $2050\backslash \backslash$

$\backslash$hline All Wheel Drive & $21$ & $29$ & $24$ & $2050\backslash \backslash$

$\backslash$hline All Wheel Drive & $21$ & $29$ & $24$ & $2050\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Front & $22$ & $31$ & $25$ & $1950\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Front & $22$ & $30$ & $25$ & $1950\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $20\mathrm{.}5$ & $29$ & $23\mathrm{.}5$ & $2125\backslash \backslash$

$\backslash$hline All Wheel Drive & $23$ & $31$ & $26$ & $1900\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $22$ & $29$ & $25$ & $1950\backslash \backslash$

$\backslash$hline All Wheel Drive & $19\mathrm{.}5$ & $25\mathrm{.}5$ & $21\mathrm{.}5$ & $2300\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $15$ & $22$ & $18$ & $2700\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $18$ & $24$ & $20$ & $2450\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $14$ & $22$ & $17$ & $2850\backslash \backslash$

$\backslash$hline $4-$Wheel Drive & $14$ & $18$ & $15$ & $3250\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $14$ & $21$ & $17$ & $2850\backslash \backslash$

$\backslash$hline $2-$Wheel Drive, Rear & $18$ & $24$ & $20$ & $2450\backslash \backslash$

$\backslash$hline All Wheel Drive & $24$ & $30$ & $26$ & $1900\backslash \backslash$

$\backslash$hline All Wheel Drive & $25$ & $34$ & $28$ & $1750\backslash \backslash$

$\backslash$hline All Wheel Drive & $24$ & $31$ & $27$ & $1800\backslash \backslash$

$\backslash$hline All Wheel Drive & $23$ & $31$ & $26$ & $1900\backslash \backslash$

$\backslash$hline All Wheel Drive & $24$ & $31$ & $27$ & $1800\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$