In this video, learn how to solve the challenge.
(upbeat music) … - [Instructor] Welcome to the solution video … for the Chapter Three challenge. … For this challenge, … we used the 03_09 challenge exercise file … and I challenged you to complete … all the task in 10 minutes or less. … Let's jump right in. … First, we'll save the file as My Challenge … in the Chapter Three folder, File, Save As, … Chapter Three, My Challenge, and Save. … Next, we'll complete the task on the Project One worksheet. … Our first task is to split A13 into multiple cells. … So, A13 contains merged cells, … we'll go to Merge and Center, and Merge Cells. … Next, format the cells data … for January through June as currency … and negative numbers in parentheses in red. … Let's select all of the sales data. … Go into our Number, Formatting window, … Currency, negative numbers in red and parentheses, … and click OK. … Number three, create a named range January Sales … to include all sales for January. … Let's select all of the data for January. … With it highlighted, we can now click in our name box …
- 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.