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

Unlock the full course today

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

Solution: Perform operations using formulas and functions

Solution: Perform operations using formulas and functions - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

Solution: Perform operations using formulas and functions

“

(upbeat music) - [Instructor] Welcome to the solution video for the chapter five challenge. For this challenge, you used the 05_10 Challenge exercise file, and I challenged you to complete all the tasks in 10 minutes or less. We have a lot to do, so let's get started. First we will save the file as My 05_10 Challenge. File, save as, keep it on the desktop in my chapter five folder. And moving on, we're going to complete the tasks on project one and project two worksheets. First, beginning in M8, format all regions in capital letters. I'll go ahead and click in M8. We will use the upper function. Equals upper, tab, to step into that function, we'll select A8 and hit Enter. We can copy that formula all the way down using the auto fill handle. Next we're going to replace the current region data with the newly formatted data, and delete column M when the task has been completed. So let's go ahead and select all of our…

Contents