Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
To Enter the Worksheet Titles, Change Workbook Properties,
Apply a Theme, and Save the Workbook
The worksheet contains two titles, one in cell A1 and another in cell A2. In the
previous chapters, titles were centered across the worksheet. With large worksheets that
extend beyond the size of a window, it is best to enter titles in the upper-left corner as
shown in the sketch of the worksheet in Figure 3–3a. The following steps enter the
worksheet titles and save the workbook.
1 Click cell A1 and then enter Campus Clothiers as the worksheet title.
2 Click cell A2 and then enter Semiannual Projected Gross Margin, Expenses, and
Operating Income as the worksheet subtitle and then press the ENTER key.
3 Click the Ofﬁ ce Button, click Prepare on the Ofﬁ ce Button menu, and then click Properties.
4 Update the document properties with your name and any other relevant information.
5 Click the Close button in the Document Properties pane.
6 Apply the Trek theme to the worksheet by clicking the Themes button on the Page Layout
tab on the Ribbon and then return to the Home tab on the Ribbon.
7 With a USB ﬂ ash drive connected to one of the computer’s USB ports, click the Save button
on the Quick Access Toolbar.
8 When Excel displays the Save As dialog box, type Campus Clothiers Semiannual
Financial Projection in the File name text box.
Rotating Text in a Cell
In Excel, you use the
Alignment sheet of the
Format Cells dialog box,
as shown in Figure 3-5, to
position data in a cell by
indenting; aligning at the
top, bottom, or center;
and rotating. If you enter
90 in the Degrees box in
the Orientation area, the
text will appear vertically
and read from bottom to
top in the cell.
9 If necessary, click UDISK 2.0 (E:) in the Save in list (your USB ﬂ ash drive may have a different
name and letter). Click the Save button in the Save As dialog box to save the workbook.
Rotating Text and Using the Fill Handle to Create
The data on the worksheet, including month names and the What-If Assumptions section,
now can be added to the worksheet.
Plan the layout of the worksheet.
The design of the worksheet calls speciﬁ cally for only six months of data. Because there
always will be only six months of data in the worksheet, the months should be placed across
the top of the worksheet as column headings rather than as row headings. There are more
data items regarding each month than there are months, and it is possible that more expense
categories could be added in the future. A proper layout, therefore, includes placing the
data items for each month as row headings. The What-If Assumptions section should be
placed in an area of the worksheet that is easily accessible, yet does not impair the view
of the main section of the worksheet. As shown in Figure 3–3a, the What-If Assumptions
should be placed below the calculations in the worksheet.
When you ﬁ rst enter text, its angle is zero degrees (0°), and it reads from left
to right in a cell. Text in a cell can be rotated counterclockwise by entering a number
between 1° and 90° in the Alignment sheet in the Format Cells dialog box.