Chapter 2, Problem 3AYK

Create the worksheet shown above, using MS Excel follow the instruction properly given bellow Enter a formula to find sales price. (Sale price =List of price –Discount) Enter a formula to find sales Tax. (Sale tax=sales price *0.05) Enter a formula to Total Price (Total price = Sales Price Sales Tax Enter a formula to find Total, Average, Highest & lowest Price of Top 10 Items & Apply conditional formatting. Create a Header that includes your name in the left section, page number in the center position and your ID number in the Left Section. Create a Footer with date in Left Section & time in the right section.

[ Item3-B ] Instructions: Kindly provide the complete and correct solutions. I won't like it if it is incomplete and incorrect.

Instructions: Circle T if the statement is true, F if the statement is false, or write the best answer in the space provided. TF Dynamic Web pages commonly use databases.