Ch3ClassNotes_Part1_sp10a

Ch3ClassNotes_Part1_sp10a - Chapter 3: Excel Functions,...

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: Chapter 3: Excel Functions, Part 1 (of 4) This chapter will be presented in three parts: 1) I ntroduction to Excel Functions & Working with Dates in Excel 2) Mathematical and Logical Functions (with emphasis on the I F Function) 3) Financial Functions 4) LOOKUP Functions Chapter Skills for Part 1: I ntroduction 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 functions 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 text type argument when numeric argument is required Become fam iliar with date and t ime 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....
View Full Document

This note was uploaded on 08/22/2011 for the course ACIS 2504 taught by Professor Mtgriffin during the Spring '08 term at Virginia Tech.

Page1 / 7

Ch3ClassNotes_Part1_sp10a - Chapter 3: Excel Functions,...

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