2. chapter 7 (40 points)
a. name the worksheet for this problem: sales
b. enter the following information starting in cell f1 (product goes in cell fl):
product selling price
p-40
$25.00
curtis
$75.00
warhawk
$99.95
c. create an input section, starting in cell a1, that allows a customer to enter the
number of each item that they wish to purchase
i. clearly label the input section so that the customer knows in which cell to
enter the quantity for each item
ii. the customer is only to enter the quantity, you must design the
worksheet so that they can enter a quantity for each of the three products
1. enter quantities of your choice for the customer
iii. calculate the total cost for each product
iv. calculate the total cost of the customer's bill (ignore sales tax)
v. use conditional formatting on the cells where the customer enters the
quantity of each product
1. use highlight cell rules to format the cell with red text when
the quantity is equal to seven
d. in cell a10, ask the customer to input the name of their favorite product (the
customer must input their answer in cell b10)
i. you may not turn on "in-cell dropdown" to complete any of the part d
requirements!
ii. use data validation to verify that the customer's favorite product is one
of the three products that you sell
1. use the information style error alert
2. if the product is not one of the products that you sell, then provide
an error message that says: "i am sad that you don't like my
products."
e. protect worksheet c7 so that the only cells the customer can select and change are
the data input cells (there should be 4 data entry cells)
i. do not use a password with your cell protection!