- The task is to find the car model with the highest final price among those sold in 2018.
- First, filter the rows where the "Sale Date" column (column J) falls within the year 2018. This means the date should be between 01/01/2018 and 31/12/2018.
- The relevant rows are:
- Row 4: Hyundai Sonata, Final Price = 9600
- Row 5: Ford Edge, Final Price = 18600
- Row 6: Hyundai i25, Final Price = 12100
- Row 7: Hyundai Sonata, Final Price = 9200
- Row 8: Mini Cooper, Final Price = 20300
- Row 9: Ford Edge, Final Price = 21100
- Row 10: Hyundai i25, Final Price = 12000
- Row 11: Hyundai Sonata, Final Price = 8600
- Row 12: Mini Cooper, Final Price = 18700
- Row 13: Hyundai i25, Final Price = 12400
- Row 14: Hyundai Sonata, Final Price = 9500
- Row 15: Hyundai i25, Final Price = 14400
- Compare the "Final Price" values for these filtered rows.
- The highest value is 21100, which corresponds to the Ford Edge in row 9.
- Therefore, the car model with the highest final price sold in 2018 is the Ford Edge.
Parent Tip: Review the logic above to help your child master the concept of excel practice worksheets.