{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

acis 2504 ch 3 class notes

acis 2504 ch 3 class notes - Chapter 3 Excel Functions Part...

Info icon This preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
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 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. o #VALUE! (remember this one for the exam) (input value of the wrong data type) o #NAME? (you should recall this one from Chapter 2) (incorrect spelling of named range or function name) o
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern