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.
Challenge: Perform operations using formulas and functions - Microsoft Excel Tutorial
From the course: Microsoft Office Specialist: Excel Associate (Microsoft 365 Apps) Cert Prep
Challenge: Perform operations using formulas and functions
(upbeat music) - [Instructor] Welcome to the Chapter 5 Challenge. For this challenge, you will be using the 05_10 challenge exercise file. I believe you should be able to complete all of these tasks in 10 minutes or less. Please keep in mind if you're unable to complete all the tasks that quickly, go back and watch the videos for chapter five and then come back and try the challenge again. You can also watch my solution video to see how I completed all of the tasks.
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
-
-
-
-
-
-
-
(Locked)
Insert relative, absolute, and mixed references6m 3s
-
(Locked)
Use structured references in formulas4m 56s
-
(Locked)
Using the AVERAGE(), MAX(), MIN(), and SUM() functions2m 32s
-
(Locked)
Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions2m 51s
-
(Locked)
Perform conditional operations using the IF() function4m 18s
-
(Locked)
Sort data and return unique values using the SORT() and UNIQUE() functions5m 5s
-
(Locked)
Format text using the RIGHT(), LEFT(), and MID() functions3m 56s
-
(Locked)
Format text using UPPER(), LOWER(), and LEN() functions2m 5s
-
(Locked)
Format text using the CONCAT() and TEXTJOIN() functions3m 53s
-
(Locked)
Challenge: Perform operations using formulas and functions34s
-
(Locked)
Solution: Perform operations using formulas and functions5m 21s
-
(Locked)
-
-