Microsoft Office Tutorials and References
In Depth Information
Entering Formulas
4
Tap or click the Save button on the Quick Access Toolbar, which depending on
settings, will display either the Save As gallery in the Backstage view or the Save As
dialog box.
5
To save on a hard disk or other storage media on your computer, proceed to Step 5a.
To save on SkyDrive, proceed to Step 5b.
5a If your screen opens the Backstage view and you want to save on storage media on
your computer, tap or click Computer, if necessary, to display options in the right pane
related to saving on your computer. If your screen already displays the Save As dialog
box, proceed to Step 6.
5b If your screen opens the Backstage view and you want to save on SkyDrive, tap or click
SkyDrive to display SkyDrive saving options or a Sign In button. If your screen displays
a Sign In button, tap or click it and then sign in to SkyDrive.
6
Tap or click the Browse button in the right pane to display the Save As dialog box
associated with the selected Save As Place (i.e., Computer or SkyDrive).
7
Type HyperMass Online Storage Salary Report in the File name box to
change the le name. Do not press the ENTER key after typing the le name because
you do not want to close the dialog box at this time.
8
Navigate to the desired save location (in this case, the Excel folder in the CIS 101
folder [or your class folder] on your computer or SkyDrive).
9
Tap or click the Save button (Save As dialog box) to save the document in the selected
folder on the selected location with the entered le name.
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 60.45 by 19.5 and then manually enter the product for Gross Pay, 1,178.78, in
cell E4. Every time the values in cells C4 or D4 changed, you would have to recalculate
the product and enter the new value in cell E4. By contrast, if you enter a formula in cell
E4 to multiply the values in cells C4 and D4, Excel recalculates the product whenever
new values are entered into those cells and displays the result in cell E4.
A formula in a cell that contains a reference back to itself is called a circular
reference . Excel often warns you when you create a circular reference. In almost all
cases, circular references are the result of an incorrect formula. A circular reference
can be direct or indirect. For example, placing the formula =A1 in cell A1 results in
a direct circular reference. An indirect circular reference occurs when a formula
in a cell refers to another cell or cells that include a formula that refers back to the
original cell.
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Enter a Formula Using the Keyboard
The formulas needed in the worksheet are noted in the requirements document as follows:
1. Gross Pay (column E) = Hours Worked Hourly Pay Rate
2. Federal Tax (column F) = 0.22 (Gross Pay – Dependents 24.32)
3. State Tax (column G) = 0.04 Gross Pay
4. Tax % (column H) = (Federal Tax + State Tax) / Gross Pay
5. Net Pay (column I) = Gross Pay – (Federal Tax + State Tax)
 
Search JabSto ::




Custom Search