Microsoft Office Tutorials and References
In Depth Information
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.
Double-click the Sheet1 tab and then enter Biweekly Payroll Report as the
sheet name and then press the ENTER key.
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.
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.
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.
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).
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.
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
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.
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.