9|EXCEL – Fred’s Fairly Reliable

Challenges
, ,
41

image
image1246×484 32.1 KB

42

Challenge9_Dataset_FredsFairlyReliable.xlsx (24.9 KB)

My recommendations are

  1. Toyota Corolla
  2. Toyota Camry
  3. Honda Accord
  4. Ford Explorer
  5. Ford Taurus
43

Challenge9_Dataset_FredsFairlyReliable.xlsx (24.5 KB)
Here is my solution for some SONA credit for Evaluating a website. This was a fun challenge. Alec Carter; This is to replace a tax quiz

44

Challenge9.Dataset.FredsFairlyReliable.KR.xlsx (20.7 KB)

Camry, Corolla, Accord, Taurus, and Explorer

45

Challenge9_Dataset_FredsFairlyReliable (version 1).xlsb.xlsx (24.4 KB)

46

Challenge 9.xlsx (24.5 KB)
Interesting Challenge!

47

Here’s my solution:
Challenge9_Dataset_FredsFairlyReliable.xlsx (25.5 KB)

It was a good practice for me in remembering conditional formatting in cells. I also formatted all of my data as a table which was helpful for me in manipulating some of the formulas.

48

Challenge9_Dataset.xlsx (25.3 KB)

49

Challenge9_Dataset_FredsFairlyReliable_01.xlsx (31.4 KB)

Here’s my solution!

50

Time to complete: 20 mins
I liked this challenge, was kinda fun to learn something new with conditional formatting.

51

This challenge took me around 25 minutes. It took me a while to remember how to use conditional formatting tools and I learned how to make my own conditional formatting rules in the process. Here’s my solution:
Challenge9_Dataset_FredsFairlyReliable.xlsx (24.5 KB)

52

This was super difficult for me. Hopefully the next one will be easier. Conditional Formatting with formulas is tough.

53

Great challenge! Good refresher on conditional formatting.

Here’s my solution.
Finished Excel Challenge.xlsx (24.6 KB)

54

Challenge9_Dataset_FredsFairlyReliable.xlsx (24.4 KB)

Thanks for the challenge! It was nice to learn about different ways to format in excel!

55

Time to complete: 35 minutes
Rating: Beginner

This challenge was very straightforward and helpful to practice formatting skills that are great to know! I would highly recommend it to anyone wanting to practice conditional formatting.

Challenge9_Dataset_FredsFairlyReliable.xlsx (24.1 KB)

56

This was definitely new to me. Based on my excel sheet I got that the top 5 cars were

57

Challenge9_Dataset_FredsFairlyReliable_JeremPorter.xlsx (25.6 KB)

Time to complete: 22 minutes

It was a good refresher on conditional formatting!

58

Cool challenge, I’ve never used much conditional formatting but it seems very useful!

They should sell the following vehicles:

  • Ford Taurus
  • Ford Explorer
  • Honda Accord
  • Toyota Corolla
  • Toyota Camry

Challenge9_Dataset_FredsFairlyReliable_Askey_Quinn.xlsx (24.7 KB)

59

Challenge9_Dataset_FredsFairlyReliable.xlsx (33.6 KB)

This was a great challenge. I had never used conditional formatting before but I believe I could use it in the future!

60

Challenge9_Dataset_FredsFairlyReliable (1).xlsx (25.0 KB)