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.
Challenge: Manage data, cells, and ranges
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Challenge: Manage data, cells, and ranges
(upbeat techno music) - [Instructor] Welcome to the chapter three challenge. For this challenge, you'll be using the 03_09 challenge exercise file, and I believe you should be able to complete all the tasks in under 10 minutes. If you find that you're unable to complete all the tasks within that timeframe, please watch the videos again for chapter three, and come and try 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 options6m 28s
-
(Locked)
Fills cells by using AutoFill4m 16s
-
(Locked)
Insert and delete columns, rows, and cells3m 15s
-
(Locked)
Format cells and ranges5m 39s
-
(Locked)
Apply styles to cells and ranges6m 44s
-
(Locked)
Define and reference named ranges5m 18s
-
(Locked)
Insert sparklines5m 35s
-
(Locked)
Summarize data visually with built-in conditional formatting5m 3s
-
(Locked)
Challenge: Manage data, cells, and ranges27s
-
(Locked)
Solution: Manage data, cells, and ranges4m 23s
-
-
-
-
-
-