Ch2ClassNotes_sp11

Ch2ClassNotes_sp11 - Chapter 2: Excel Formulas Chapter...

Info iconThis preview shows pages 1–3. 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 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
Background image of page 1

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

View Full DocumentRight Arrow Icon
1. Using cell references v. actual (typed-in) value a. Open the workbook VerySimplePayroll.xlsx that is posted on Scholar. 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. =32*8 How effective is this way of entering formulas? 2. Using relative cell references Use relative cell references for values that change for each new formula location (when formulas are copied and pasted to new locations). a. Re-enter the formula into the first cell in the Gross Pay column. a.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. a.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. b.i. After pasting the formula down the column, examine the formulas in the subsequent rows. b.ii.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

Ch2ClassNotes_sp11 - Chapter 2: Excel Formulas Chapter...

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

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