Microsoft Office Tutorials and References

In Depth Information

**Entering Formulas**

To Change the Sheet Name and Save the Workbook

The following steps change the sheet name to Biweekly Payroll Report, change the

sheet tab color, and save the workbook on a USB l ash drive in the Excel folder (for your

assignments) using the i le name, The Mobile Masses Biweekly Payroll Report.

1

Double-click the Sheet1 tab and then enter
Biweekly Payroll Report
as the

sheet name and then press the
ENTER
key.

2

Right-click the tab to display the shortcut menu and then click Tab Color on the shortcut

menu to display the Color gallery. Click Blue, Accent 1, Darker 25% (column 5, row 5) in

the Theme Colors area to apply a new color to the sheet tab.

3

With a USB l ash drive connected to one of the computer’s USB ports, click the Save button

on the Quick Access Toolbar to display the Save As dialog box.

4

Type
The Mobile Masses Biweekly Payroll Report
in the File name text box

to change the i le name. Do not press the
ENTER
key after typing the i le name because you

do not want to close the dialog box at this time.

5

Navigate to the desired save location (in this case, the Excel folder in the CIS 101 folder

[or your class folder] on the USB l ash drive).

6

Click the Save button (Save As dialog box) to save the document in the selected folder on

the selected drive with the entered i le name.

Entering Numbers

in a Range

An efi cient way to enter

data into a range of cells is

to select a range and then

enter the i rst number in

the upper-left cell of the

range. Excel responds by

accepting the value and

moving the active cell

selection down one cell.

When you enter the last

value in the i rst column,

Excel moves the active cell

selection to the top of the

next column.

Entering Formulas

One of the reasons Excel is such a valuable tool is that you can assign a
formula
to a cell,

and Excel will calculate the result. Consider, for example, what would happen if you had

to multiply 65.25 by 20.5 and then manually enter the product for Gross Pay, 1,337.625,

in cell F4. Every time the values in cells D4 or E4 changed, you would have to recalculate

the product and enter the new value in cell F4. By contrast, if you enter a formula in cell

F4 to multiply the values in cells D4 and E4, Excel recalculates the product whenever new

values are entered into those cells and displays the result in cell F4.

Plan

Ahead

Determine the formulas and functions needed.

As you have learned, formulas and functions simplify the creation and maintenance of

worksheets because Excel performs calculations for you. When formulas and functions are

used together properly, the amount of data that a user manually must enter in a worksheet

greatly can be diminished:

•
Utilize proper algebraic notation.
Most Excel formulas are the result of algebraic

calculations. A solid understanding of algebraic operators and the order of operations

is important to writing sound formulas.

Utilize the i ll handle and copy and paste operations to copy formulas.

•

The i ll handle

and the Excel copy and paste functionality help to minimize errors caused by retyping

formulas. When possible, if a similar formula will be used repeatedly in a worksheet,

avoid retyping the formula and instead use the i ll handle.

Be careful about using invalid and circular cell references.

•

An invalid reference occurs

when Excel does not understand a cell reference used in a formula, resulting in Excel

displaying a #REF! error message in the cell.

(

Continued

)