GRADE 12 - TYPING IF & COUNTIF FUNCTIONS

Use worksheet done for practice, same as in image: Write an IF function that will calculate answer in C8 to display In Stock when price is less than $200 otherwise Out of Stock

Use worksheet done for practice, same as in image: Write an IF function that will calculate answer in C4 to display In Stock when price is less than $200 otherwise Out of Stock

Use worksheet done for practice, same as in image: Write an IF function that will calculate answer in D3 to display Cheap for items costing less than $200 otherwise Expensive

Use worksheet done for practice, same as in image: Write an IF function that will calculate answer in D10 to display Cheap for items costing less than $200 otherwise Expensive

Use worksheet done for practice, same as in image: Write an IF function that will calculate answer in E7 to display Reject if item is expensive otherwise display Accept

Use worksheet done for practice, same as in image: Write an IF function that will calculate answer in E6 to display Reject if item is expensive otherwise display Accept

Use worksheet done for practice, same as in image: The IF function was used to calculate answer in E3 to display Reject if item is expensive otherwise display Accept. Was LAPTOP rejected or accepted? Click the correct answer.

• Rejected

• Accepted

Use worksheet done for practice, same as in image: Write a COUNTIF FUNCTION IN C12 that will count the number of items In Stock

Use worksheet done for practice, same as in image: Write a COUNTIF FUNCTION IN D13 that will count the number of items that are expensive.

Use worksheet done for practice, same as in image: Write a COUNTIF FUNCTION IN E14 that will count the number of items that displayed ACCEPT.