Module 13 - ..see Excel help (search on '#'). Audit your...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Module 13 - Spreadsheets Good Spreadsheet Design Use formulas whenever possible. Eliminate repetitive work. Copy formulas. Automatic numbering and labeling. Naming cell ranges (use Names in formulas instead of cell addresses) Relative vs. Absolute references in formulas 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. Protecting cells/formulas 1) Set cell format (Format/Cells/Protection) check or uncheck the 'Locked' checkbox. 2) Protect the worksheet (Tools/Protection/Protect Sheet) Shading and borers Comments Common errors ####: the numeric cell contents > column width. #N/A: when a value referenced in a formula is not available. #DIV/0!: when a formula divides by 0. Others.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ..see Excel help (search on '#'). Audit your formulas (double-click on your formulas to see a colored outline of the referenced cells) Examples MIS 250 Grading spreadsheet Decision Sciences 344 Finance 421 Relative References B6 = Average (B2:B4) What will be the result of copying the following? Copy B6 to C6 60 Copy B6 TO B7 75 Copy B6 to B5 65 Copy B6 to E3 #REF Absolute References B6= Average (B$2:B$4) Row position is fixed. What will be the result of copying the following? Copy B6 to C6 60 Copy B6 TO B7 70 Copy B6 to B5 70 Copy B6 to E3 Circular reference More Absolute References B6= Average ($B$2:$B$4) Row and Column Position are fixed. What will be the result of copying the following? Copy B6 to C6 70 Copy B6 TO B7 70 Copy B6 to B5 70 Copy B6 to E3 70...
View Full Document

This note was uploaded on 04/07/2008 for the course MIS 250 taught by Professor Wells during the Spring '08 term at Washington State University .

Page1 / 4

Module 13 - ..see Excel help (search on '#'). Audit your...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online