This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: *** I F functions- when using AND logic then the subsequent if statement need to be nested in the value if t rue ***For OR logic each subsequent if function is nested in the value if false ***Requirement for lookup table, range data must be in ascending order Chapter 3: Excel Functions, Part 1 (of 3) This chapter will be presented in three parts: 1) I nt roduction to Excel Functions and Working with Dates in Excel 2) I F Function 3) VLOOKUP Function Chapter skills, vocabulary, demonstration notes, will be provided in separate class notes for each part. Chapter review questions will be provided at the end of Part 3 notes. Chapter Skills for Chapter 3, Part 1 Enter functions into Excel worksheet cells. o Enter some function arguments that are cell references o Enter some function arguments that are actual values (not cell references). Explore multiple ways to enter Excel functions into worksheet formulas. o Select Formulas Function Library Insert Function. o Type the name of the function into the formula. o Click on the drop-down arrow on the AutoSum icon. o Click on the fx to the left of the formula bar. o Use the keyboard shortcut Shift+F3 Explore the Insert Function dialog box 1 o Search for a function by name....
View Full Document
This note was uploaded on 08/15/2011 for the course ACIS 2504 at Virginia Tech.