Self-test your comprehension by completing a series of hands-on activities for the challenge in this video. Practice importing data into workbooks from .txt and .csv files, navigating within workbooks, formatting worksheets and workbooks, customizing options and views, and configuring content for collaboration.
(upbeat techno music) … - [Instructor] Welcome to the chapter two challenge. … For this challenge, … you'll be using the 02_12 challenge exercise file. … You should be able to complete all of the tasks … in 10 minutes or less. … Now if you find … that you're unable to complete all of the tasks … within that timeframe, … go back and watch the videos for chapter two, … and come try the challenge again. … Now because this is your first challenge, … let's take a look at the challenge file together. … On the instructions page, … you'll always have a few tasks to complete … before you're asked to move on to the project worksheets. … Each project worksheet will have additional tasks … for you to complete, … some will be completed on this worksheet, … and some will reference other worksheets … for you to complete tasks on. … Once you've completed all of the tasks … on all of the project worksheets, … go back to your instructions … and your final task will always be to save … and close the workbook. …
- 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.