From the course: Excel: Advanced Formulas and Functions
Join today to access over 23,200 courses taught by industry experts.
Challenge 3: Guitars
From the course: Excel: Advanced Formulas and Functions
Challenge 3: Guitars
(upbeat energetic music) - Amy is a guitar player and a guitar collector. Here is a list of guitars that she's bought and sold over the years. And is sorted by the amount descending. Here's what we want to know. Does Amy still own guitars: F, L, M, or A? If she's never owned one, then return N, period. O, period. Well, let's look at the data. So on the 25th of August of 2013, Amy sold guitar M. We also see on the 6th of June of 2020, she purchased guitar M. We see that for guitar J, that was purchased on the 17th of October 21 and sold the 5th of December of 21. So, we want to know about guitars F, L, M and A specifically. Does she still own them or not? Right? Pause the video and work that out. Come back. (upbeat energetic guitar music) All right, let's do it. Let's see if your result matches my result. I'm going to go guitar and we're interested in F, L, M and A. Make this bold. Slide…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.