Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
To Enter the Projected Monthly Sales
The following steps enter the projected revenue, listed earlier in Table 3 – 1 on page
EX 143, in row 13 and compute the projected six-month revenue in cell H13.
If necessary, display the Home tab.
Freezing Titles
If you want to freeze only
column headings, select
the appropriate cell in
column A before you click
the Freeze Panes button
(View tab | Window
group). If you want to
freeze only row titles,
select the appropriate cell
in row 1 before you click
the Freeze Panes button
(View tab | Window
group). To freeze both
column headings and row
titles, select the cell that
is the intersection of the
column and row titles
before you click the Freeze
Panes button (View tab |
Window group).
Enter 3113612.16 in cell B13, 7962235.53 in cell C13, 5112268.58 in cell
D13, 2924627.87 in cell E13, 7630534.65 in cell F13, and 3424270.23 in
cell G13.
Select cell H13 and then click the Sum button (Home tab | Editing group) twice to create a
sum in the selected cell (Figure 3–20).
Home tab
Sum button
columns B, C, and
D not displayed
when active cell
is in column H
projected six-month sales
projected monthly sales
for last three months
The Insert Options
When you insert columns
or rows, Excel displays the
Insert Options button only
if formats are assigned to
the leftmost column or top
row of the selection.
row titles frozen
on screen
Figure 3 –20
To Enter and Format the System Date
The sketch of the worksheet in Figure 3 – 3a on page EX 142 includes a date stamp on the right side of the
heading section. A date stamp shows the date a workbook, report, or other document was created or the period it
represents. In business, a report often is meaningless without a date stamp. For example, if a printout of the worksheet
in this chapter were distributed to the company’s analysts, the date stamp would show when the six-month projections
were made, as well as what period the report represents.
A simple way to create a date stamp is to use the NOW function to enter the system date tracked by your
computer in a cell in the worksheet. The NOW function is one of 22 date and time functions available in Excel.
When assigned to a cell, the NOW function returns a number that corresponds to the system date and time
beginning with December 31, 1899. For example, January 1, 1900 equals 1, January 2, 1900 equals 2, and so on.
Noon equals .5. Thus, noon on January 1, 1900 equals 1.5 and 6 P.M. on January 1, 1900 equals 1.75. If the computer’s
system date is set to the current date, which normally it is, then the date stamp is equivalent to the current date.
The steps on the following pages enter the NOW function and then change the format from mm/dd/yyyy
hh:mm to mm/dd/yyyy.
Search JabSto ::

Custom Search