CGS2570 Fall-2011 Excel, Chapter 2

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

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

View Full Document Right Arrow Icon
This chapter reviews how to perform quantitative analysis, focusing on formulas and functions. 1
Background image of page 1

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

View Full Document Right Arrow Icon
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
Background image of page 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
Background image of page 3

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

View Full Document Right Arrow Icon
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.
Background image of page 4
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.
Background image of page 5

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

View Full Document Right Arrow Icon
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
Background image of page 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
Background image of page 7

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

View Full Document Right Arrow Icon
A mixed cell reference contains a fixed column and relative row or a fixed row and a relative column. 8
Background image of page 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
Background image of page 9

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

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

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

View Full Document Right Arrow Icon
Image of page 12
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 Right Arrow Icon
Ask a homework question - tutors are online