W17 ITEC1010 Assignment #2 – Excel SpreadsheetsDue: March 17, 11:30 PM In Class -- No late submissions accepted.When we create a worksheet model using a spreadsheet program such as Excel, we instruct thecomputer by providing steps it can take to solve the problem at hand. Problem solving in this context ishow best to achieve the desired results using appropriate formulas and functions. In this assignmentyou are asked to solve worksheet problems and present them on the Web. All problem solutions should make full use of named ranges. Be sure to read the instructions with care and complete all tasks.TASK A:Solve each assignment problems below by following the 5-step problem-solving strategies below:STEP 1: Understand the problem clearly -- read the problem instruction carefully more thanonce.STEP 2: Strategize -- begin by thinking roughly as to how the problem can be solved -- writeyour ideas out in words.STEP 3: Design solutions-- write a more structured algorithm or draw a flow chart of theordered set of steps required to solve the problem.STEP 4: Implementation -- translate your design algorithm to formulae that Excel can execute --use appropriate functions and name-defined cell ranges for full credit.STEP 5: Verification -- ensure that the results of your formulae match the example values.TASK B: Be sure to include all required components for each problem solution. Problem solution pages must include: Your name and ID# in the header Explain your content for each solution as to the problem(s) addressed. Submit your assignment March 16, 7 PM in class.Problem 1: Invoice Create an invoice worksheet for purchased products of your choosing – see partial examplebelow. Include the Items sold and their List_Prices of your choosing. A Discount of 3% is to be computed if Quantity is at least 10. Note Discount cells remain blank when the discount does not apply. Sale_Price is the List_Price except when discounts are in play. Include at least five exemplary item entries in your invoice; calculate the Subtotal then apply theOntario HST to compute the Amount_Due. Construct well-formed formulas required using named ranges wherever appropriate; formatsensibly for clarity. Print both the data view and the formula view (ensure that there are no cut-off printouts).Example:Problem 2: Grades Create a grades table – see partial example below. Determine the average for each student’s final grade; each item is equally weighted; sort the listby last name. Use the LOOKUP technique according to the following grading scheme and compute the lettergrade for each student. Grading Scheme to be applied is: 90 to 100 is an A+, 80 to 90 is an A, 75 to

https://moodle.yorku.ca/moodle/pluginfile.php/2576138/mod_resource/content/27/1010-a2O.pdf