From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Solution: Perform operations with formulas and functions

Solution: Perform operations with formulas and functions

From the course: Cert Prep: Excel 2016 Microsoft Office Specialist (77-727)

Start my 1-month free trial

Solution: Perform operations with formulas and functions

“

- [Instructor] Welcome to the chapter five challenge solution video. For this challenge, we used the 0506 challenge exercise file and I challenged you to complete all the tasks in ten minutes or less. Let's go ahead and get started. Starting on our instructions worksheet, our first task is to save the file as my0506challenge. We'll go to file, save as, browse back to our desktop exercise files folder, type my in front of the document title, add a space, and click save. Number two says complete the tasks on the project one and project two worksheets and when we're done we'll save and close the workbook. Let's go ahead and go to the project one worksheet. Task number one, in cell J10, use the conditional function to determine if the order status is backordered and if so, we're going to insert follow up, if not we'll insert okay. We are going to fill the entire column with the function. Let's go ahead and click on J10. We're using if statements, so I'll type in equals if. Go ahead and…

Contents