• Print row and column headings for all problems.  To print  row and column  headings:  click on file, page set up, sheet, and then in the section identified as print, check the row and column headings box.
• Print two copies of each problem.  One copy with normal printing and the other copy displaying the formulas.  To display formulas:  To display formulas: click on tools, options, view, and check formulas.  Also you can hold down control key and press the squiggle (~) key/
• To change the size of the printing to fit on a page, click on file, click on page set up and under the page tab scaling section, either reduce the % of normal size or click on fit to: ? pages wide by ? tall.  Sometimes changing to landscape (page tab) will help the fit.
• Copying a formula
• Rounding
• Using several sheets (tabs on bottem of woorksheet) within a worksheet.
• General Excel help and other Microsoft help
• Additional Help
• BASIC EXCEL FUNCTIONS:
Addition =F1+F2+F3
Subtraction =F1-F2
Multiplication =F1*F2
Division =F1/F2
Sum =SUM(F1:F14)

Absolute cell reference:
• In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute reference takes the form $A$1, $B$1, and so on.  With the cursor on the address in the formula you can press the F4 key to change an address to absolute.
• If you only want the absolute to be effective going horizontal, press F$ another time and then there will be a $ only to the right of the column letter.
• If you only want the absolute to be effective going vertical, press F$ one more time and then there will be a $ only to the left of the column letter.
• You can just  keep pressing the F4 key to recycle through the options

Relative cell reference:

• A cell reference, such as A1, that tells Microsoft Excel how to find another cell by starting from the cell that contains the formula. Using a relative reference is like giving someone directions that explain where to go from where the person is starting out ¾ for example, "go up two blocks and over one block."

Number   is the number you want to round.

Num_digits   specifies the number of digits to which you want to round number.

· If num_digits is greater than 0 (zero), then number is rounded to the specified number of decimal places.
· If num_digits is 0, then number is rounded to the nearest integer.
· If num_digits is less than 0, then number is rounded to the left of the decimal point.

Examples

ROUND(2.15, 1) equals 2.2

ROUND(2.149, 1) equals 2.1

ROUND(-1.475, 2) equals -1.48

ROUND(21.5, -1) equals 20

ROUND((A1*B1),0) equals the product of  the contents of A1 times the contents of B1 rounded to zero decimal places.