Self-test your comprehension by completing a series of hands-on objectives for the challenge in this video. Learn that time is a major factor in the Excel Associate 2019 MOS exam, so the ability to solve objectives quickly is important. Practice performing calculations using relative, absolute and mixed references, referencing named ranges and named tables in formulas, performing calculations using the AVERAGE(), MAX(), MIN(), SUM(), COUNT(), COUNTA(), COUNTBLANK(), and IF() functions. Also, practice formatting and modifying text using the RIGHT(), LEFT(), MID(), UPPER(), LOWER(), LEN(), CONCAT(), and TEXTJOIN() 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. … …
- Importing data
- Formatting worksheets and workbooks
- Exporting workbooks
- Pasting data
- Modifying columns, rows, and cells
- Formatting cells
- Conditional formatting
- Creating tables
- Filtering and sorting table data
- Using references
- Performing calculations with functions
- Formatting text with functions
- Creating charts
- Taking the practice exam
Skill Level Intermediate
Who should take this course?1m 15s
1. Microsoft Office Specialist Exam Overview
2. Manage Worksheets and Workbooks
3. Manage Data Cells and Ranges
4. Manage Tables and Table Data
5. Perform Operations Using Formulas and Functions
6. Manage Charts
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.