Week 1 Getting Started Guide Ruth Greene’s ITE140 Level 2 Objectives: Calculating and Comparing Data Using Simple Functions Work with multiple worksheets Calculate total, average, minimum, and maximum values with functions Understand how functions work: syntax, arguments, and algorithms Use the AutoSum feature to perform calculations quickly Calculate the number of values using both COUNT and COUNTA Succeeding in Business with Microsoft Excel 2010 2 Working with Multiple Worksheets Succeeding in Business with Microsoft Excel 2010 3 Level 2 home Functions Predefined formula that performs calculations Structure Function name and open parenthesis mark Arguments (list of inputs in a specific order, separated by commas) Closing parenthesis mark Has its own syntax (specifies function name and order of arguments) Behaves according to its algorithm (rules programmed into the function) Succeeding in Business with Microsoft Excel 2010 4 Level 2 home Calculating Totals Using the SUM Function SUM function Adds a list of values and/or cell ranges Excel has an AutoSum feature for quick calculation Succeeding in Business with Microsoft Excel 2010 5 Level 2 home Inserting a Function into a Formula Succeeding in Business with Microsoft Excel 2010 6 Level 2 home Common Excel Functions Succeeding in Business with Microsoft Excel 2010 7 Level 2 home Calculating Average, Minimum, and Maximum Values Succeeding in Business with Microsoft Excel 2010 8 The AVERAGE function ignores blank cells and cells with text. Level 2 home Calculating the Number of Values Using COUNT and COUNTA Functions Succeeding in Business with Microsoft Excel 2010 9 COUNT function ignores blank cells and cells with text; COUNTA function does not ignore text cells. Level 2 home Level 2 Summary Simple functions (SUM, AVERAGE) and how to use them in formulas Syntax of functions and their underlying algorithms AutoSum tool Succeeding in Business with Microsoft Excel 2010 10