# (Solved): You have been given this excel workbook named Car sales.xlsx Download Car sales.xlsx containing d ...

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.

We have an Answer from Expert