41
Saylor URL: http://www.saylor.org/books
Saylor.org
54
1.3 Formatting and Data Analysis
LEARNIN G OB JECTIVES
1.
Use formatting techniques to enhance the appearance of a worksheet.
2.
Understand how to align data in cell locations.
3.
Examine how to enter multiple lines of text in a cell location.
4.
Understand how to add borders to a worksheet.
5.
Examine how to use the AutoSum feature to calculate totals.
6.
Understand how to insert a chart into a worksheet.
7.
Use the Cut, Copy, and Paste commands to manipulate the data on a worksheet.
8.
Examine how to use the Sort command to rank data on a worksheet.
9.
Understand how to move, rename, insert, and delete worksheet tabs.
This section addresses formatting commands that can be used to enhance the visual appearance of a
worksheet. It also provides an introduction to mathematical calculations and charts. The skills
introduced in this section will give you powerful tools for analyzing the data that we have been
working with in this workbook and will highlight how Excel is used to make key decisions in virtually
any career.
Formatting Data and Cells
Follow-along file: Excel Objective 1.0 (Use file Excel Objective 1.04 if you are starting with this skill.)
Enhancing the visual appearance of a worksheet is a critical step in creating a valuable tool for you or your
coworkers when making key decisions. The following steps demonstrate several fundamental formatting
skills that will be applied to the workbook that we are developing for this chapter. Several of these
formatting skills are identical to ones that you may have already used in other Microsoft applications such
as Microsoft® Word® or Microsoft® PowerPoint®.
1.
Highlight the range A2:D2 in the Sheet1 worksheet by placing the mouse pointer over cell A2 and left
clicking and dragging to cell D2.
2.
Click the Bold button in the Font group of commands in the Home tab of the Ribbon (see Figure 1.36
"Font Group of Commands").