Lesson 5 –Changing the Appearance of Worksheets
Welcome to Lesson 5. This page will guide you through your work on this lesson.
- Learning Objectives
- Lesson Overview
- Video Tutorials
- Hands-On Study
- Self-Test
- Assessment Exercises
- Unit Test
After completing this lesson, you will be able to
-
Modify column width and row height
- Insert as well as delete columns, rows, and cells
- Hide and unhide rows and columns
- Set the vertical alignment and rotate the text
- Find data in a worksheet and replace both data and formatting
- Effectively utilize AutoCorrect
- Search Help to learn how to complete a task
- Work with Excel tools: Spelling, Research, Thesaurus, and Translation
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.
Your teacher may assign a test for this single-lesson unit. Check the Unit Test link for instructions on any testing required for this unit before you continue to the next unit.
