QUIZ #2

1. 1. Microsoft Excel can perform mathematical equations.

• TRUE

• FALSE

2. 2. Range, criteria, and logical test are part of the AVERAGEIF Syntax.

• TRUE

• FALSE

3. 3. Excel formulas always begin with a sign.

• TRUE

• FALSE

4. 4. Excel can be used to create a database.

• TRUE

• FALSE

5. 5. Column J and row 9 is also referred to as cell 9J.

• TRUE

• FALSE

6. 6. AVERAGE function used to get the average of a certain range of cells if a condition is met.

• TRUE

• FALSE

7. 7. SUMIF function adds all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell.

• TRUE

• FALSE

8. 8. Both IF and AVERAGEIF can perform a logical test.

• TRUE

• FALSE

9. 9. Asterisk (*) symbol is used to multiply items in Excel.

• TRUE

• FALSE

10. 10. SUMIF function adds values that meet a given criteria.

• TRUE

• FALSE