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 "overunder", 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 "yearsbetween", 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 Q with value
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
