From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 23,000 courses taught by industry experts.
Challenge: Perform operations using formulas and functions
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Challenge: Perform operations using formulas and functions
(upbeat techno music) - [Narrator] Welcome to the chapter five challenge. For this challenge you'll be using the 05_09 challenge exercise file. And I believe you should be able to complete all of the tasks in 10 minutes or less. Remember, if you find you're unable to complete all of the tasks within that time frame, watch the videos again for chapter five 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
-
-
-
-
-
-
-
(Locked)
Insert relative, absolute, and mixed references8m 7s
-
(Locked)
Reference named ranges and named tables in formulas3m 35s
-
(Locked)
Using the AVERAGE(), MAX(), MIN(), and SUM() functions3m 11s
-
(Locked)
Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions2m 41s
-
(Locked)
Perform conditional operations using the IF() function4m 13s
-
(Locked)
Format text using the RIGHT(), LEFT(), and MID() functions2m 36s
-
(Locked)
Format text using UPPER(), LOWER() and LEN() functions2m 21s
-
(Locked)
Format text using the CONCAT() and TEXTJOIN() functions4m 42s
-
(Locked)
Challenge: Perform operations using formulas and functions28s
-
(Locked)
Solution: Perform operations using formulas and functions4m 55s
-
(Locked)
-
-
-