From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Challenge: Manage data, cells, and ranges - Microsoft Excel Tutorial
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Microsoft 365 Apps
Challenge: Manage data, cells, and ranges
(upbeat music) - [Instructor] Welcome to the Chapter 3 Challenge. For this challenge, you'll be using the 03_10 challenge exercise file. And I challenge you to complete all of the tasks in 10 minutes or less. Be sure and watch my solution video so you can see how I completed all of the tasks. Remember, if you have a challenge with any of the tasks on the challenge, watch the videos again and come back and take the challenge again.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Paste data using special paste options5m 28s
-
(Locked)
Fill cells by using AutoFill4m 20s
-
(Locked)
Insert and delete columns, rows, and cells3m 26s
-
(Locked)
Format cells and ranges5m 28s
-
(Locked)
Generate random and sequential data using Functions4m 55s
-
(Locked)
Apply styles to cells and ranges7m 49s
-
(Locked)
Define and reference named ranges3m 39s
-
(Locked)
Insert sparklines3m 28s
-
(Locked)
Summarize data visually with built-in conditional formatting3m 24s
-
(Locked)
Challenge: Manage data, cells, and ranges32s
-
(Locked)
Solution: Manage data, cells, and ranges4m 46s
-
-
-
-
-