Microsoft Office Tutorials and References
In Depth Information
Session 3.2
Figure 3-19
Cells with formatted backgrounds
colored
pattern
background
applied
5. Save your changes to the workbook.
Joan is pleased with the progress you have made. In the next session, you will explore
other formatting features.
Session 3.1 Quick Check
Review
1. Describe two ways of applying the Currency style to cells in your worksheet.
2. If the number 0.05765 has been entered into a cell, what will Excel display if you:
a. format the number using the Percent style with one decimal place?
b. format the number using the Currency style with two decimal places and a dollar sign?
3. Which two buttons can you use to copy a format from one cell range to another?
4. A long text string in one of your worksheet cells has been truncated. List three ways
to correct this problem.
5. How do you center the contents of a single cell across a range of cells?
6. Describe three ways of creating a cell border.
7. How would you apply a colored background pattern to a selected cell range?
To reinforce the tasks you
learned in this session,
go to the SAM 2003
Training Companion CD
included with this text.
Session 3.2
Formatting the Worksheet
In the previous session, you formatted individual cells within the worksheet. Excel also
provides tools for formatting the columns and rows in a worksheet. You will explore some
of these tools as you continue to work on Joan’s sales report.
For hands-on practice of
key tasks in this session,
go to the SAM 2003
Training Companion CD
included with this text.
 
Search JabSto ::




Custom Search