Lesson 4 –Formatting the Contents of Cells

Welcome to Lesson 4. This page will guide you through your work on this lesson.

• Learning Objectives
• Lesson Overview
• Video Tutorials
• Hands-On Study
• Self-Test
• Assessment Exercises

---

Learning Objectives

After completing this lesson, you will be able to

• Format worksheets using a variety of methods: Ribbon, Mini Toolbar, Format Cells Dialog Box
  
• Horizontally align and indent cell entries
  
• Apply and cancel text control options: merge, wrap text, and shrink to fit
  
• Format cell borders and fill colors
  
• Use the Format Painter tool to copy formatting
  
• Apply a theme to your worksheet
  
• Work with dates and create date and time functions

back to top

---

Lesson Overview

back to top

---

Hands-On Study

Read the lesson and perform every Hands-On exercise. If you run into a problem with an exercise step, post it to the discussion area of the course or send an email message to your instructor.

back to top

---

Self-Test

Concepts Review Questions

• Take the Concepts Review Self-Test Quiz for this lesson. This quiz is not graded.

Skill Builder Exercises

• Especially if you miss more than one or two of the Concepts Review questions, you should perform at least one of these exercises.

Completing the Self-Test Stage

• After you have completed one or more Skill Builder, you are finished with this lesson.

back to top

---

Assessment Exercises

Unless your teacher assigns them, you are not required to perform the Assessment Exercises at the end of the lesson.

back to top

---