Excel Introductory Chapter 9 - Franklin University.docx

Excel 2010 Chapter 2 Answer Key for Matching and Multiple Choice Matching G Function predefined formula that performs calculations by using specific values ina particular order or structure. N Statistical functions 2. Excel functions such as AVERAGE that are useful to analyze a group of measurements. O SUM function predefined formula that adds all the numbers ina selected range. A AVERAGE function function that adds a group of values, and then divides the result by the number of values in the group. L MEDIAN function function that finds the middle value that has as many values above it in the group as are below it. M MIN function function that determines the smallest value ina range. K MAX function function that determines the largest value ina range. F Drag and drop 8. The action of moving a selection by dragging it toa new location. I Logical functions group of functions that tests for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false. E Criteria 10. Conditions that you specify ina logical function. D COUNTIF function 11. A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments — the range of cells to check and the criteria. J Logical test 12. Any value or expression that can be evaluated as being true or f