new to excel and need help

Each part must be on a separate worksheet. You will probably have to use the AND function and OR function in some of your formulas. Part A: Curtiss Hardware sells battery powered drills for $99.00 each. If the customer purchases 3,4 , or 5 drills, then the price is reduced to $95.00 each. If the customer purchases 6 or more drills, then the price is reduced to $89.99 each. Sales tax is 10%. Create a worksheet that allows the customer (user) to input the number of drills that they are purchasing. Pretend that you are the user and input the number of drills that you wish to purchase. The worksheet must then calculate the following items: - The price for a single drill based on the quantity entered by the user. You MUST use the IF function to determine the price per drill in Part A. - The total price of the drills purchased before the sales tax - The amount of the sales tax - The total price of the order including the sales tax Part B: Warhawk Company sells two types of computers, Laptops and TabletsI Laptops sell for \$699, and Tablets sell for \$499. AUM alumni receive a discount of \$25 on their purchase. Create a worksheet that allows the customer (user) to input the following two items: - The type of computer they want to purchase - Whether or not they are an AUM alumni by entering Yes or No Pretend that you are the customer and input the type of computer that you wish to purchase and whether or not you are an AUM alumnus. The worksheet must then display the correct price of the computer based on the user inputs. (ignore sales tax). You must determine the price of the computer by using an IFS function. Next, create a nested function in a single cell using IFERROR and IFS so that if the IFS function results in an error, then the cell displays "Please check your inputs and fix any errors." Remember to follow the Excel Requirements document