pls attach steps and how to complete

Perform all calculations using Excel, when calculations are needed: no other source of answers requiring calculation will be permitted. All the answers should automatically appear in the Answer worksheet. After calculating answers on designated worksheet for each problem, if they do not automatically appear in the Answer sheet, Copy and Paste 123 (Values) to the Answer sheet without rounding. Do not type values into the Answer sheet that you calculate elsewhere. Rounded numbers are errors. Only the answers given in the shaded cells will be accepted'. Answer all of the following questions as Excel formulas not numbers (i.e. =sum(A2:A40) instead of the resultfnumber only). Any numbers written directly without formula into the answer cells will get 0. You are given the data on the quantity of keyboards sold within a month (30 days). You are asked the following questions by your manager. a) What is the total number of keyboards sold? b) How many keyboards were sold in the rst week (assume that the rst observation is the rst day of the week)? c) How many keyboards were sold in the third week? d) How many total keyboards were sold on the 5th, 15th and 25th day? You are given the sales data for the month. Your manager wants you to get information on the following. a) What is the monthly revenue for iPhones? b) What is the revenue for keyboards and mouses? c) What is the total revenue for the month? You are given the net worth for 10 fictional companies. a) Create a single Excel formula in cell C2 (that will be propagated downwards) to check if the Net Worth of the company is more than $50,000,000. Note: While you are asked to only make a single Excel formula, propagating downwards will functionally work without changing the formula for the other 9 companies. b) How many companies are worth more than $50,000,000