When we create a worksheet model using a spreadsheet program such as Excel, we instruct the computer by providing steps it can take to solve the problem at hand.
computer science
Description
When we create a worksheet model using a spreadsheet program such as Excel, we instruct the computer by providing steps it can take to solve the problem at hand. Problem-solving in this context is how best to achieve the desired results using appropriate formulas and functions. In this assignment, you 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 than once. STEP 2: Strategize -- begin by thinking roughly as to how the problem can be solved -- write your ideas out in words. STEP 3: Design solutions-- write a more structured algorithm or draw a flowchart of the ordered 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: Construct a Web site presenting your solutions to the seven (7) problems presented below. You may use any HTML code generating tool at your disposal as long as you know how to use it; code validation is not required for this assignment. Be sure to include all required components for each problem solution. The main page named “index.html” should introduce your website and provide descriptive links to the 7 separate solution pages, i.e., your site will have 8 HTML pages. Edit the index page’s
