Lecture 1

Question 1

BUS 321

Answer 1

Spreadsheet-Based Data Analysis

Question 2

averages the values in a range

Answer 2

AVERAGE(range)

Question 3

averages the values in a range that meet a criterion

Answer 3

AVERAGEIF(range, criterion, [average_range])

Question 4

averages the values in multiple ranges that meet the given criteria

Answer 4

AVERAGEIFS(average_range1, range1, criterion1, range2, criterion2, …rangeN, criterionN)

Question 5

counts the number of numeric cells in a range

Answer 5

COUNT(range)

Question 6

counts the number of nonblank cells in a range

Answer 6

COUNTA(range)

Question 7

counts the number of blank cells in a range

Answer 7

COUNTBLANK(range)

Question 8

counts the number of cells in a range that meet a given criterion

Answer 8

COUNTIF(range, criterion)

Question 9

counts the number of rows in multiple ranges that meet the given criteria

Answer 9

COUNTIFS(range1, criterion1,range2, criterion2,…rangeN,criterionN)

Question 10

totals the values in a range

Answer 10

SUM(range)

Question 11

totals the values in a range that meet a criterion

Answer 11

SUMIF(range, criterion, [sum_range])

Question 12

totals the values in multiple ranges that meet the given criteria

Answer 12

SUMIFS(sum_range, range1, citerion1, range2, criterion2, …rangeN, criterionN)

Question 13

used to represent any sequence of characters

Answer 13

*

Question 14

used to represent a single character

Answer 14

?

Question 15

Not

Answer 15

<>