You have been given this excel workbook named Car sales.xlsx Download Car sales.xlsx containing data about $51$ cars. Every car $($row$)$ has $14$ features $($Column$).$ You must calculate the following using suitable excel functions or formulas: $($To download the work book click on the name of workbook given in the question$).$

Average of all the feature $($columns$)$ from C to N$.$

In the workbook there$$s a column named $$CAR TYPE$.$ There are $2$ options in car type $$Car$$ or $$Passenger$.$ You must find how many cars belong to each type?

There$$s given the $$LAUNCH DATE $$of the car model. You must calculate how old the car is depending on the $$LAUNCH DATE$.$ The age of car should be in weeks $($with proper precision$).$

Each car has their fuel efficiency. You must add one more column at the last of all columns to the workbook named $$CAR RUNNING COST$.$ The new column that you are going to add should have two types: $$E$$ or $$NE$.($E: Economical, NE: Non$-$Economical$).$If the "FUEL EFFECIENCY" is greater than OR equals to $22,$ mark it as $"$E$"$ else $"$NE$".$

Using the new column added after doing question $4,$ determine how many cars are under $$E$$ category and how many are under $$NE$$ category.

Highlight the cars who are among top $10$ in sales with color of your choice. $($Highlight only that specific cell in Sales column not the entire row.$)$

Highlight the cars with following colors on basis of their fuel efficiency given that the cars with fuel efficiency with $10$ to $20$ with red color, $20$ to $25$ with yellow color and cars above $25$ with green color.