Modified True or False: Write TRUE if the statement is correct. If the statement is false, change the underlined word or phrase to make the whole statement correct. Write your answer on a separate sheet of paper.
1. Microsoft Excel can perform mathematical equations.
2. Range, criteria, and logical test are part of the AVERAGEIF syntax.
3. Excel formulas always begin with a sign.
4. Excel can be used to create a database.
5. Column J and row 9 is also referred to as cell 9J.
6. AVERAGE function used to get the average of a certain range of cells if a condition is met.
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.
8. Both IF and AVERAGEIF can perform a logical test.
9. Asterisk (*) symbol is used to multiply items in Excel.
10. SUMIF function adds values that meet a given criteria.
11. IF function can have two results.
12. Functions are mathematical equations that calculates the value of a cell.
13. The intersection of rows and columns is called cell reference.
14. AVERAGEIF function returns the arithmetic mean of all the cells in a range that meet a given criteria.
15. In Excel, the active cell is indicated by an underline.