{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch3ClassNotes_Part1_sp10a

# Ch3ClassNotes_Part1_sp10a - C hapter 3 Excel Functions Pa r...

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

Chapter 3: Excel Functions, Part 1 (of 4) This chapter will be presented in three parts: 1) Introduction to Excel Functions & Working with Dates in Excel 2) Mathematical and Logical Functions (with emphasis on the IF Function) 3) Financial Functions 4) LOOKUP Functions Chapter Skills for Part 1: Introduction to Excel Functions & Working with Dates in Excel Enter functions into Excel worksheet cells. o Enter some function arguments as cell references. o Enter some function arguments as actual values. Explore multiple ways to enter Excel functions into worksheet formulas. o Click on the fx to the left of the formula bar. o Use the keyboard shortcut Shift+F3. o Select Formulas (tab) Function Library(task group) Insert Function. o Click the drop-down arrow on the AutoSum icon (same task group as above). o Type the name of the function into the formula. Explore the Insert Function dialog box o Search for a function by name. o Select a category of functions. o Select a function to enter into a formula. Use the Function Argument dialog box to enter function arguments or get more information about a function’s arguments. Use the Evaluate Formula formula auditing feature to find the source of syntax errors that involve functions. o #VALUE! input value of the wrong data type o #NAME? incorrect spelling of a function name incorrect spelling of named range (recall from chapter 1) o #N/A a missing argument for a function o #NUM! 1

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

View Full Document
text type argument when numeric argument is required Become familiar with date and time functions as a group and understand some of the common arguments for functions in this group. o a formatted date value (a format that Excel recognizes) o a text date (a format that Excel does not recognize) o a serial date o date elements, such as day of the month, weekday, month, year.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 7

Ch3ClassNotes_Part1_sp10a - C hapter 3 Excel Functions Pa r...

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

View Full Document
Ask a homework question - tutors are online