You will begin your Module 1-3 Quiz next class.
Excel Module 3–Performing Calculations with Formulas and Functions
At the end of this module you will know about how to:
- Document formulas and data values
- Explore function syntax
- Insert functions from the Formula Library
- Perform a what-if analysis
- AutoFill series and formulas
- Use relative and absolute cell references
- Use the Quick Analysis tool
- Work with dates and Date functions
- Find value with Lookup functions
- Work the Logical functions
- Review Assignment pages EX181 to EX182: Print as instructed–remember to always print showing formulas also
- Case Problem 1 pages EX182 to EX183: Print as instructed–remember to always print showing formulas also
- Case Problem 2 pages EX183 to EX184: Print as instructed–remember to always print showing formulas also
- EXTRA CREDIT–Case Problems 3 & 4 pages EX184 to EX186: Print as instructed–remember to always print showing formulas also
- True/False: AutoFill copies content but formulas from a cell or range into an adjacent cell or range.
- True/False: The small black square in the lower-right corner of a selected cell or range is called the AutoFill button.
- Use the ________________ symbol to make a cell reference absolute.
- True/False: A relative reference is a cell reference that changes when it is copied and pasted in a new location.
- True/False: CTRL-A displays the menu of Quick Analysis tools.
- True/False: The right scroll arrow shows additional Quick Analysis tools.
- True/False: The TODAY function doesn’t have any arguments.
- True/False: The values returned by the TODAY and NOW functions are updated automatically whenever you reopen the workbook or enter a new calculation.
- To retrieve the return value from a vertical lookup table, you use the ______ function.
- If the VLOOKUP function cannnot find the lookup value, the ________ error value is displayed in the cell.
- What symbol appears at the beginning of a function?
- A(n) __________________ is a symbol that indicates the relationship between two values.