Module 6

Question 1

Summary Statistics

Answer 1

descriptive figures that help individuals show what the data shows

Question 2

Boolean Logic

Answer 2

0 is false 1 is true

Question 3

Conditional Functions

Answer 3

perform calculations wher the cell references used to complete the calculations depend on the values of other cells in a worksheet.

Question 4

=SUMIF(range,criteria,[sum_range])

Answer 4

calculates the total for a set of values that match a specific criterion.

Question 5

=AVERAGEIF(range,criteria,[average_range])

Answer 5

calculates the average for a set of values that match a specific criterion.

Question 6

”=”COUNTIF(range,criteria)

Answer 6

determines the number of cells within a range of cells that contain a specific value

Question 7

Range

Answer 7

the range of cells that you want to apply the criteria against

Question 8

Criteria

Answer 8

the criteria used to determine which cells to include in a calculation

Question 9

Row_Index

Answer 9

the row number from which to retrieve data (for HLOOKUP)

Question 10

Column_Index

Answer 10

the column number from which to retrieve data (for VLOOKUP)

Question 11

[Range_Lookup]

Answer 11

A boolean to indicate exact match or approximate match. Default=TRUE-approximate match.