The beverage commission the total sale the customer buys beverage

Logic and Reference Functions

This assignment has a total of 100 points.

Task #	Points	Task Description
1	9	Use the AND function with appropriate arguments in cell H11 to determine if there is a force out at third base. There is a force out at third base if "Runner on 1st" and "Runner on 2nd" are both "Yes".
2	1
3	7
4	1
5	7
6	1	Copy your function in cell J11 and paste it down to complete the "Not 2 Outs" column of the table.

	Points	Task Description
1	5	Use an IF function in cell E18 to calculate the price to charge per donut for order 1. A customer is charged $.50 per donut unless they buy a dozen or more. In this case, they are charged $.40 a donut. Refer to the appropriate price in cells C11 and C12 for your "value_if_true" and "value_if_false" arguments. Use absolute and relative references when appropriate.
2	1
3	5
4	1

	Points	Task Description
1	6	Use the VLOOKUP function in cell F9 to determine the number of days it will take to ship order 1. Use the distance in cell E9 to lookup the appropriate value on the "Delivery Information" reference table (range K10:M15). Make sure to use relative and absolute references appropriately.
2	1	Copy your formula in cell F9 and paste it down to complete the "# Days" column of the table.
3	5
4	1

Conditional

The athletic department is sponsoring a free throw contest before tonight's game to give away free t-shirts. They have recorded the hair and eye color of each participant. Each participant shoots ten free throws. The hair and eye color groups with the highest average number of free throws made will get a t-shirt. Complete the summary tables below to determine which groups made the most free throws. Then complete the table to determine which students get a shirt. How many students will get a t-shirt?

	Points	Task Description
1	3
2	1
3	3
4	1	Copy your function in cell I17 and paste it down to complete the "Count" column of the "Eye Color Summary" table.
5	3	Use the SUMIF function in cell J10 to determine the total number of free throws made by students with black hair. Be sure to build a formula can be reused by copying down.
6	1
7	3
8	1