In this video, learn the solution to each problem on the full-length MOS sample exam.
For this challenge, you use the 07_01 … challenge exercise file, and I challenged you to complete … all of the tasks in 40 minutes or less. … Let's jump right in. … First, we'll save the file as My Final Challenge … in the Chapter Seven folder. … and that quickly it's gone. … We'll go over to Close and Load. … And there's our data. … Let me go back to the instructions. … We are going to complete the task for all projects … one through eight. … Let's jump right into project one. … First, create a table from the data in A14 to D124. … Let's go to our Name box and type that range in. … That's a quick way to select a whole range of data. … We will go to Insert Table. … Everything looks good, My table has headers is selected, … I'll click OK. … We'll then apply the green table style light 14. … Let's go to our table styles. … It's going to be in the light group, right there, perfect. … Okay, next, name the table Products. … Click on the table, go into the Table Name. … Products, perfect. …
- 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.