{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch 3 class notes

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

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

***IF functions- when using AND logic then the subsequent if statement need to be nested in the value “if true” ***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) Introduction to Excel Functions and Working with Dates in Excel 2) IF 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

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

View Full Document
o Search for a function by name.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 5

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

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

View Full Document
Ask a homework question - tutors are online