Help for Excel:

• Templates are at the text web site.  After clicking on student resources, choose the appropriate chapter and then click on templates at the top of the screen.  For the final click, if your Internet Explorer browser displays the template within the browser, you need to right click (Windows) or option-click (Mac) and select the "Save Target As..." option and then open the saved file using Excel. The templates are write protected and you should turn the protection off so you aren't restricted to only changing certain cells. You may get an error message telling you to turn off the protection before modifying a cell. To turn the protection off, click on tools, protection, unprotect and enter hartman as the password. You must be using Excel instead of Internet Explorer when changing the write protection.
• Copying a formula
• Formulas:  To display formulas: click on tools, options, view, and check formulas.  Also you can hold down control key and press the squiggle (~) key/

• Printing 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
• 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.
• Rounding
• 
   

   
   
   
   
   
   
   
   
   

Copy:
When you move a formula, the cell references within the formula do not change. When you copy a formula, absolute cell references do not change; relative cell references will change.

• 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.
• 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."

ROUND(number,num_digits)

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.