Ch 3 class notes

Ch 3 class notes - *** I F functions- when using AND logic...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 5

Ch 3 class notes - *** I F functions- when using AND logic...

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