Ch2ClassNotes_sp10a

Ch2ClassNotes_sp10a - C hapter 2: Excel Formulas Chapter...

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

View Full Document Right Arrow Icon
Chapter 2: Excel Formulas Chapter Skills Recall the four goals of good spreadsheet design: Copy and paste formulas using cell references entering cell references into formulas use absolute cell references in formulas use relative cell references in formulas use mixed cell references in formulas Construct formulas using correct order or operations (PEMDAS: P lease E xcuse M y D ear A unt S ally) Use references to assumption cells in formulas View all worksheet formulas Recognize the advantages of using named cell ranges in Excel formulas Use named cell ranges in formulas Recall common causes of the following error values: (For this chapter, you need to know cause(s) for only the first 3 error values listed below.) ####### (Introduced in Chapter 1) #NAME? #REF! #VALUE! (wait until Chapter 3 for this one) Recall three types of errors encountered in Excel formulas Troubleshoot formula errors using the Evaluate Formula feature Properly apply worksheet and workbook protection Chapter Vocabulary 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
cell reference absolute cell reference relative cell reference mixed cell reference assumption cell (the actual cell) assumption cell value (contained in the assumption cell) “named” cell range (a.k.a. "range name") Name Manager feature formula error values "locked" and "unlocked" cells (with regard to worksheet protection) workbook protection Paste Special feature formula view of worksheet Constructing Formulas in Excel 1. Using cell references v. actual (typed-in) value a. Open the workbook VerySimplePayroll.xlsx that is posted on Bb. b. Examine the layout of the worksheet. c. Into the first cell under the column header Gross Pay , enter a formula that calculates the gross pay based on the hours worked and the hourly rate of pay for the particular employee. =40*22 d. Enter a formula into the cell below it, for the second employee. 2
Background image of page 2
How effective is this way of entering formulas? 2. Using relative cell references a. Re-enter the formula into the first cell in the Gross Pay column. i. Instead of typing in the cell reference, such as E6, click on the cell to have it inserted into the formula at the proper place. ii. To enter the formula: Type the = sign, then click on cell D6, type in the * sign, then click on cell E6, then hit the Enter key. Your formula should look like this: =D6*E6 b. Now, use the fill handle to copy the formula down to subsequent rows. i. After pasting the formula down the column, examine the formulas in the subsequent rows. ii. How well did that work? 3. Using Absolute Cell References in Excel Formulas a. You are anticipating increasing salaries by a set percentage across the board. You are interested in seeing how an 8% increase affects the hourly rates. i.
Background image of page 3

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

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

Page1 / 15

Ch2ClassNotes_sp10a - C hapter 2: Excel Formulas Chapter...

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