Lesson 2: APPLIED PRODUCTIVITY TOOLS

Question 1

allows to sum numerical data in any number of columns or rows by selecting them or
typing them in

Answer 1

=SUM(sum_range)

Question 2

used to summate values of cells in a range
that meets the criteria that have been
specified

Answer 2

=SUMIF(range, criteria,
sum_range)

Question 3

allows user to get the average of all numbers
in the chosen cells

Answer 3

=AVERAGE(range to be
averaged)

Question 4

used to count the number of chosen cells that
have a number value in them

Answer 4

=COUNT(range to be
counted)

Question 5

allows users to achieve a particular value if
the condition has been satisfied or TRUE, or if
the condition has not been satisfied or FALSE

Answer 5

=IF(condition, result if
true, result if false)

Question 6

used to search for the highest value in an array

Answer 6

=MAX(range)

Question 7

used to search for the lowest value in an array

Answer 7

=MIN(range)

Question 8

combines two or more text strings;
combines the values from two or more cells into another cells

Answer 8

=CONCATENATE(text1,
text2, text3)