Chapter 2

# Chapter 2 - Click to edit Master subtitle style Excel...

This preview shows pages 1–6. Sign up to view the full content.

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

View Full Document

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

View Full Document

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Click to edit Master subtitle style Excel Formulas Chapter 2 Topics from Chapter 2 &#2; Workbook design goals &#2; Using cell references in formulas Relative Absolute &#2; Using named cell ranges &#2; Troubleshooting formula errors Error Values Formula Auditing Tools &#2; Protecting worksheets Workbook Design Goals &#2; Flexibility: Most important! Outputs should recalculate automatically when inputs change. Inputs should be easy to locate for users to change. &#2; Accuracy: Developer testing ensures logically correct formulas. &#2; Ease of Information Gathering: Use formatting to make information easy to scan visually. &#2; Good Documentation: Developer’s notes User instructions Flexible Workbook Design &#2; Formulas are the foundation of flexible workbook design. &#2; Formulas convert workbook inputs to outputs. &#2; Formulas should reference input cells whose contents (values) are apt to change. &#2; Flexible formula design is the most important concept to master for Excel users! &#2; Formula Rule/Guideline: Don’t type anything into a cell if its value can be derived from data in Cell Reference Notations &#2; The contents of a cell can be used in a calculation (formula) by including the cell’s address in the formula. &#2; The cell’s address is represented by its column and row intersection. &#2; Two types of notation exist in Excel....
View Full Document

## This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.

### Page1 / 21

Chapter 2 - Click to edit Master subtitle style Excel...

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

View Full Document
Ask a homework question - tutors are online