These questions have to do with the computer program Microsoft Excel
1. The results of the logical test can either be true or false. (T/F)
2. The > < operator is defined as "not equal to". (T/F)
3. A valid output of a logical function is either "1" or "0". (T/F)
4. The = < operator is defined as "less than or equal to". (T/F)
5. The output of the logical test 4 <= 5 is TRUE. (T/F)
6. The value of the "logical_test" arguement in the IF function can be either "1" or "-1". (T/F)
7. If a text input is used to define the [value_if_true] argument in the IF function, then that text must be enclosed in round brackets. (T/F)
8. If one of the logical tests in the OR function is true, the output of the function will be the word TRUE. (T/F)
9. The COUNT function will count the number of cells in a range that contain numeric or text data. (T/F)
10. The arguments used the COUNTIF function are "coefficient" and "mean". (T/F)
11. The AVERAGEIF function allows the user to define three cell ranges. (T/F)
12. The COUNTIFS function provides the option of defining multiple sets of criteria for selecting cells from a targeted range that will be used in the function output. (T/F)
13. The VLOOKUP function is typically used to access and display data located in another worksheet or workbook. (T/F)
14. A VLOOKUP function will search horizontall across the first row of a range of cells to find what is called a lookout value. (T/F)
15. "Criteria" is one of the arguments used in a VLOOKUP function. (T/F)
16. The cell range defined by the Table_array argument of the VLOOKUP function must contain the criteria used to define the Lookup_value in the first column. (T/F)
17. When the [Range_lookup] argument of the VLOOKUP function is defined with the word FALSE, the function will look for an exact match to the criteria used to define the Lookup_value argument in the first column of the table array range. (T/F)
18. If the [Range_lookup] argument of the VLOOKUP function is defined with the word TRUE, the function will look for a value that is an exact match or the closest match that is "more than" the lookup value. (T/F)
19. If the [Range_lookup] argument of the HLOOKUP function is defined with the word TRUE, the data in the table array range must be sorted based on the values in the first row in descending order from left to right. (T/F)
20. If the [Range_lookup] argument of the HLOOKUP function is not defined it will automatically be defined with the word TRUE. (T/F)