From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Solution: Create advanced formulas

Solution: Create advanced formulas - Microsoft Excel Tutorial

From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep

Start my 1-month free trial Buy for my team

Solution: Create advanced formulas

“

(upbeat music) - [Instructor] Welcome to the Solution video for the Chapter 4 Challenge. For this challenge, you used the 04_13 Challenge exercise file, and I challenged you to complete all these tasks in 12 minutes or less. We have a lot to do, so let's get started. First, we'll save the file as My Challenge. File, Save as, change the name, and Save. Complete the tasks on the Project 1 through 4 worksheets. First, we'll create a dropdown list in G7 that has the names of all the salespeople. Only the names in the list can be used. Here's G7. We will use data validation. Data tab, Data validation, Allow from a list, click in the source field, and select all the salespeople, and click OK. Select Booker. Booker. In H7, use a function to return the commission rate for the employee selected in G7. We can use XLOOKUP. The lookup value is in G7, comma, the lookup array will be the name column, comma, the return…

Contents