From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Challenge 1: Towers

Challenge 1: Towers

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Challenge 1: Towers

“

(intro music) - Congratulations getting through the course. And before we wrap up and sent you across the graduation stage, there are a few challenges. And here is the first one. We have a list of units and rents and we want to find out the minimum rent, the maximum rent for towers 1 or 3 with floor plan 9. And let's look at these codes. 02-1706. That means it's in the second tower, it's on the 17th floor and it has floor plan 6. So let's look over in our data. Unit 01-3906. That's in Tower 1, 39th floor. And it has floor plan 6. We scroll down. And this one we've got 03. That's tower 3, 40th floor, number 6 floor plan. And the rent is $2,430 All right, so that's how the data works. And you have all you need to get through this challenge. And now it is that time to pause a video, figure out those minimum and maximum rents based on the criteria and then come on back. (uplifting music) Okay, here we go.…

Contents