From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

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 using formulas and functions

Solution: Perform operations using formulas and functions

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Solution: Perform operations using formulas and functions

“

(lively music) - [Instructor] Welcome to the solution video for the chapter five challenge. For this challenge, we use the 05_09 challenge exercise file and I challenged you to complete all the tasks in 10 minutes or less. Let's get started. First, we'll save the file as my challenge in the chapter five folder. File and save as, chapter five and click save. Complete the tasks on the project one and project two worksheets. Let's jump right into project one. First, insert a column to the right of region. I'll select column B, right-click and insert. Use the new column to format all regions in uppercase and replace the current region data with the newly formatted data. We'll start in B8. We're going to use the upper function. Equals upper, tab. I'll click in A8 and hit Enter. That looks great. Let's go ahead and copy our newly formatted data. I can right-click and copy and click in A8, go to our paste special options and we just want the values and click OK. That looks good. I'll use my…

Contents