Lesson 10 - MOS EXCEL

What function is used to total all of the cells in a range?

• MIN

• AVERAGE

• COUNT

• SUM

What does the IF function return when the Logical_test is TRUE?

• Value_if_true

• Value_if_false

• Logical_test

• IF

What does the SUMIF function do?

• None of the above

• Adds the cells in Range or Sum_range specified by a given Criteria

• Returns the arithmetic mean of cells in Range or Average_range that meet a Criteria

• Counts the number of cells within Range that meet the Criteria

When using the COUNTIF function, what does it count?

• The minimum value in a range of cells

• The number of cells within Range that meet the Criteria

• The total of all the cells in a range

• The largest value in a set of values

What does the AVERAGEIF function return?

• The number of cells within Range that meet the Criteria

• The arithmetic mean of cells in Range or Average_range that meet a Criteria

• The cells in Range or Sum_range specified by a given Criteria

• None of the above

What is the purpose of the Formulas tab in Excel?

• To apply conditional formatting

• To create and apply advanced formulas

• To format cells and data

• To insert charts and graphs

What is the syntax of the IF function?

• IF(Logical_test, Value_if_true, Value_if_false)

• IF(Value_if_true, Logical_test, Value_if_false)

• IF(Value_if_false, Value_if_true, Logical_test)

• IF(Value_if_true, Value_if_false, Logical_test)

What is the purpose of the AVERAGE function?

• To add a range of cells and then divide by the number of cell entries

• To count the number of cells within Range that meet the Criteria

• To determine the minimum value in a range of cells

• To return the largest value in a set of values

What is the syntax of the SUMIF function?

• SUMIF(Range, Sum_range, Criteria)

• SUMIF(Criteria, Range, Sum_range)

• SUMIF(Sum_range, Criteria, Range)

• SUMIF(Range, Criteria, Sum_range)

What is the syntax of the COUNTIF function?

• COUNTIF(Range, Criteria)

• COUNTIF(Criteria, Range)

• COUNTIF(Criteria, Criteria)

• COUNTIF(Range, Range)