Modifying a Worksheet
The "Modifying a Worksheet" module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises: Managing Worksheets, Inserting, Deleting and Hiding.
The Modifying a Worksheet module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:
- Managing Worksheets
- Inserting, Deleting and Hiding
Lab time: It will take approximately 1 hour to complete this lab.
Exercise 1 - Managing Worksheets
Excel workbooks can be organized to make it easier to find information that contain so much data. It can be hard to understand what is in a workbook with the default, number-based sheet names. Fortunately, you can rename them. You can also color-code sheet tabs, and hide and unhide worksheets, so you're showing only what you want to show to a particular user or users.
Exercise 2 - Inserting, Deleting and Hiding
You often find that the structure you initially set up on a worksheet needs to be modified. You might need to add new rows of data in the middle of a table, or a new category of information as a new column. You can easily insert or delete cells and ranges, or entire rows or columns.
You can also hide rows or columns so that their data remains in the workbook but isn't visible. This is useful when some of the data in a workbook is appropriate for some people to see but not others, or when you don't want people distracted by too much detail.
IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.