CGS2570 Fall-2011 Excel, Chapter 2

# CGS2570 Fall-2011 Excel, Chapter 2 - This chapter reviews...

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

This chapter reviews how to perform quantitative analysis, focusing on formulas and functions. 1

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

View Full Document
The objectives of Chapter 2 include to: Use semi-selection to create a formula Use relative, absolute, and mixed cell references in formulas Avoid circular references Insert a function Total values with the SUM function Insert basic statistical functions 2
Additional objectives include to: Use date functions Determine results with the IF function Use lookup functions Calculate payments with the PMT function Create and maintain range names Use range names in formulas 3

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

View Full Document
4 To use semi-selection to create the formula, take the following steps. Assume you want to create a formula such as =A1+A2. 1. Click the cell where you want to create the formula. 2. Type an equal sign (=). 3. Click cell A1. 4. Type a plus sign (+). 5. Click cell A2. 6. Press Enter to complete the formula.
5 Excel offers three types of cell references for use when a formula is copied. An absolute cell reference (for example, \$A\$1) indicates that the address will be fixed and will not be altered during a copy operation. A relative reference (for example, A1) indicates that the address will be adjusted relative to its new location. A mixed reference (for example, \$A1 or A\$1) has one part that is absolute and the other relative. The F4 key can be used to toggle through the four types of cell references.

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

View Full Document
Figure 2.1 in the textbook illustrates formulas using relative cell references. The house cost in column A differs for each row and should be altered during a copy operation. So, for example, when the formula =A8*\$B\$5 is copied from row 8 to row 9, the formula become =A9*\$B\$5 6
Again, in Figure 2.1, the textbook illustrates a formula with an absolute cell reference. The down payment rate in cell B5 is the same for each row and should not be altered during a copy operation. For example, when the formula =A8*\$B\$5 is copied from row 8 to row 9, the formula become =A9*\$B\$5 7

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

View Full Document
A mixed cell reference contains a fixed column and relative row or a fixed row and a relative column. 8
A circular reference would occur if the formula written in cell C8 is =A8-C8. Since the formula is self-referential and cannot be evaluated, the error message in Figure 2.2 will appear. Excel displays a green triangle in the top-left corner of a cell if it detects a potential error in a formula. 9

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

View Full Document
An Excel function is a predefined formula available in many categories. Function categories and their descriptions are listed in Table 2.1. 10
Trig, Statistical and Text. 11

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.

{[ snackBarMessage ]}

### Page1 / 40

CGS2570 Fall-2011 Excel, Chapter 2 - This chapter reviews...

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

View Full Document
Ask a homework question - tutors are online