Lesson 15 –Using Advanced Formatting and Analysis Tools
Welcome to Lesson 15. This page will guide you through your work on this lesson.
- Learning Objectives
- Lesson Overview
- Hands-On Study
- Self-Test
- Assessment Exercises
- Critical Thinking Exercises
After completing this lesson, you will be able to
-
Group worksheets for efficient data entry
- Consolidate data from multiple worksheets by position and category
- Set data validation rules to restrict data entry
- Apply conditional formatting to flag positive or negative trends
- Create data tables to perform what-if analyses
- Develop trendlines to analyze chart data
Read the lesson and perform every Hands-On exercise. If you run into a problem with an exercise step, use the discussion board or send an email message to your instructor.
Concepts Review Questions
- Take the Concepts Review Self-Test Quiz for this lesson. This quiz is not graded.
- Especially if you miss more than one or two of the Concepts Review questions, you should perform at least one of these exercises.
- After you have completed one or more Skill Builder, you are finished with this lesson.
Unless your teacher assigns them, you are not required to perform the Assessment Exercises at the end of the lesson.
These optional exercises give you the opportunity to apply the skills you've gained in the lesson to real-world problems and situations. Unless your teacher assigns them, you are not required to perform the Critical Thinking exercises at the end of this lesson.
