Format Cells and Ranges
The "Format Cells and Ranges" module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises: Format Cells and Ranges, Using Special Paste Options, Pasting Links.
The Format Cells and Ranges module provides you with the instructions and devices to develop your hands on skills. This module includes the following exercises:
- Format Cells and Ranges
- Using Special Paste Options
- Pasting Links
Lab time: It will take approximately 1 hour to complete this lab.
Exercise 1 - Formatting Cells and Ranges
As you can combine text, numbers and different type of data in Excel, you can use its formatting features to come up with a presentable workbook.
In this exercise, you will merge and unmerge cells, rotate then align cell data, copy/paste formatting to other cells using Format painter, wrap text in a cell or group of cells, apply appropriate number formatting, create custom styles and remove a cell style from.
Exercise 2 - Using Special Paste Options
When you copy and paste, Excel pastes all parts of what you copied: the contents of the cell (as a formula, if it's a formula), along with any formatting that had been applied to the copied cell. This is often useful, but sometimes you'll want just the values and not the formula (for a report, for example). Or you might get some formatting just the way you want it on one range, and then want to copy the same formatting, but not the contents, to another range.
Excel offers paste options that let you do those things and more.
Exercise 3 - Pasting Links
A link is really just a reference to another location. In a sense, every cell or range reference in every formula is a link. But you can refer to cells on other worksheets or workbooks, and those references are a bit more complex, because they have to include the name of the workbook, worksheet, or both. By pasting a link, you can avoid having to get that reference syntax right yourself.
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.