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: Full-length practice exam

Solution: Full-length practice exam

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

Start my 1-month free trial

Solution: Full-length practice exam

“

For this challenge, you use the 07_01 challenge exercise file, and I challenged you to complete all of the tasks in 40 minutes or less. Let's jump right in. First, we'll save the file as My Final Challenge in the Chapter Seven folder. and that quickly it's gone. We'll go over to Close and Load. And there's our data. Let me go back to the instructions. We are going to complete the task for all projects one through eight. Let's jump right into project one. First, create a table from the data in A14 to D124. Let's go to our Name box and type that range in. That's a quick way to select a whole range of data. We will go to Insert Table. Everything looks good, My table has headers is selected, I'll click OK. We'll then apply the green table style light 14. Let's go to our table styles. It's going to be in the light group, right there, perfect. Okay, next, name the table Products. Click on the table, go into the Table Name. Products, perfect. Next, display the product count. Click on the…

Contents