It was a great challenge which reminded me that my Excel skills were a little rusty! The 10 best or 10 worst items is a great tool to have when presenting data to a client. I was happy I could take on this challenge!
Challenge9_Dataset_FredsFairlyReliable.xlsx (24.6 KB)
My Solution
This was a good lesson in conditional formatting which can be very helpful in digesting information. The MOD was new for me but I will try to use it more when I can.
Challenge9_Dataset_FredsFairlyReliable.xlsx (24.6 KB)
This was a great challenge! I was unfamiliar with these Exel functions before completing the challenge, and I feel like it was definitely worth the time invested. It was tricky, but I found the solution video, as well as some videos I found online, to be very helpful, especially with the last step. Good luck with the challenge and congrats if you already have completed it!
Time to Solve: 35 Minutes
Rating: Intermediate
Challenge9_Dataset_FredsFairlyReliable.xlsx (25.5 KB)
This was a great challenge! Not too complex and gave me some good practice with conditional formatting. I didn’t have a lot of experience with creating the new rules so I had to get a little bit of help on that. Overall, I enjoyed it.
Challenge9_Dataset_FredsFairlyReliable(2)SONA.xlsx (24.6 KB)
After completing this challenge, I found it to be a great exercise in data analysis and visualization using Excel. By applying conditional formatting techniques, including highlighting alternating rows, identifying top and bottom-selling cars, and showcasing dealership margins and fuel efficiency, the spreadsheet now provides a clear and visually appealing representation of the data.
The use of icon sets and color scales help to effectively communicate important information, such as margins and fuel efficiency. Moreover, the rule to highlight entire rows for cars that excel in all parameters simplifies the decision-making process.
In conclusion, the analysis highlights the top five cars that Fred’s Fairly Reliable should prioritize for selling on the lot. These recommendations are based on a comprehensive assessment of popularity, dealership margins, and fuel efficiency, ultimately aiming to drive sales and ensure the dealership’s success.
I finished the assignment in about 25 minutes. I recommend that Tom displays the Corrolla, Accord, Camry, Taurus, and Explorer. It was helpful to go through the process of highlighting and organizing a graph to share results to an audience in a simple way
Challenge9_FredsFairlyReliable_JAREDM.xlsx (24.3 KB)
Interesting challenge was not familiar with finding even rows but it was easy enough to figure out and the solution video is also pretty good if you get stuck.
time to complete: 40 min
level: intermediate
I am not so familiar with conditionals, so it was a great learning experience for me!
Challenge9_Dataset_FredsFairlyReliable.xlsx (24.6 KB)
This challenge was not necessarily difficult it just required a lot of polishing up my excel
skills that I learned in previous Information Systems courses.
I would pick the following
- Ford Taurus
- Ford Explorer
- Honda Accord
- Toyota Corolla
Challenge9_Dataset_FredsFairlyReliable_Nicholas_Bellini.xlsx (24.5 KB)
time: This took me about 20 minutes to complete
rating: There were a few things I forgot how to do, so it was a good refresher
comments: I enjoy learning and reminding myself how to use excel, I enjoyed being able to complete this project.
Time to complete: 25
Rating: Intermediate
I really liked learning how to use the MOD function and gaining more experience using conditional formatting!
My recommendation is to begin selling these 5 cars: Ford Taurus, Ford Explorer, Honda Accord, Toyota Corolla, and Toyota Camry.
Not too bad! I didn’t know you could make rules like that!
- Ford Taurus
- Ford Explorer
- Honda Accord
- Toyota Corolla
5.Toyota Camry
Time to complete: 60
Rating: Intermediate
Comments: This was a great refresher on IS and it was such a well thought through project.
/r/personal/mlarkin1_byu_edu/Documents/Copy%20of%20Challenge9_Dataset_FredsFairlyReliable.xlsx?d=w8b3beac82d764ad2aa2e2dbc03b0ddf1&csf=1&web=1&e=mMjKxG
This Challenge was fun I got to learn more about how specific conditional formatting can help to visually see results. This challenge didn’t take me too long to complete about 25 minutes and struggled a bit towards the end on the last task of highlighting the rows with top parameters. My recommendation would be for them to sell Ford Taurus, Ford Explorer, Honda Accord, Toyota Corolla, and Toyota Camry!
Challenge9_Dataset_FredsFairlyReliableZAMACONA.xlsx (24.7 KB)
Time to complete: 20 minutes
Great challenge!
Challenge9_Dataset_FredsFairlyReliable.xlsx (24.5 KB)
