NAME: SCORE:
I.DIRECTION: Choose the letter of the correct answer
___1. A formula that uses the COUNTIF function is broken into two pieces. What are they?
a. If and count c. Range and criteria
b. Operators and symbols d. Range and arguments
___2. If you wanted Excel to look in B3 through B10 and find text equal to cookie, which formula would be correct?
a. =COUNTIF(B3:B10,cookie) c. =COUNTIF(B3:B10=cookie)
b. =COUNTIF(B3:B10,&cookie) d. =COUNTIF(B3:B10,''cookie'')
___3. If you wanted Excel to look in cells C4 through C24 and find all numbers that are greater than or equal to 10, which formula
would be correct?
a. =COUNTIF(C4:C24,''>=''&10) c. =COUNTIF(C4:C24,''>=''10)
b. =COUNTIF(C4:C24,>=''10'') d. =COUNTIF(C4:C24,>=&10)
___4. In order for the syntax to be correct, when writing a formula using the COUNTIF function, operators must have what symbol on
both sides?
a. Brackets b. Quotes c. Parenthesis d. Dollar Sign
___5. What operator(s) are the symbol for Not Equal To?
a. += b. {} c. () d. <>
II.DIRECTIONS: For the table below find the following.
1.TAX: if item price is less than 100, tax is 50, otherwise it should be 100.
2. TOTAL PRICE BEFORE TAX is the product of number of items and item price.
3. TOTAL PRICE TAX AFTER is equal to total before price tax added by tax.
4. RATE: if the total price after tax is less than 3500 indicate HIGH, otherwise REASONABLE.
5. Find the Count of items, Average of taxes, Minimum Item Price, and Maximum Item Price.
PREPARED BY:
DYLEEN GRACE A. ROBILLOS
T1 – TLE 7
