Question: In the Data sheet, create a new column labeled saleno, sorted by saledate in ascending order, so each row can be uniquely identified. Create a

In the Data sheet, create a new column labeled "saleno", sorted by saledate in ascending order, so each row can be uniquely identified.
Create a new column after "trim", labelled "car details", that combines "make", "model", and "trim".
Create a new column after selling price, labelled "over_under", that returns for each record either "over" or "under" if the selling price is over (or under) the mmr.
Create a new column after saledate, labelled "years_between", that returns the number of years between the manufacturing and selling years.
Write a formula to return the day of the week (Sunday to Saturday) for the date of "salesno" (that you have created in Q1) with value 57.
In the Data sheet, create a new column labeled

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!