# We Helped With This Excel Programming Homework: Have A Similar One?

SOLVED
Category Programming Excel College Solved Excel Assignments

## Short Assignment Requirements

I have an assignment due which contains 2 chapters. I will attach the two chapters. Please make sure the instructions match the spreadsheet. I will have to submit the excel spreadsheet for chapter 9 once I submit my order. Only 3 spaces to download files.

## Assignment Description

Project Description:

In this project, you will use Solver to create several scenarios for how much of each of the three seafood ingredients—scallops, shrimp, and fish—to include in the chowder at the new seasonal prices to maintain a profit margin of 35 percent.

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

 Step Instructions Points Possible 1 Start Excel. Download, save, and open the workbook named go16_xl_ch08_grader_8f_hw.xlsx 0.000 2 Ensure that Solver is installed. With the Seafood Chowder Costs sheet selected, open Solver. Set the objective cell as J5 to the Value Of 35% and then set variable cells to the range C4:C6 and click Solve. 12.000 3 Save the scenario as No minimum weight and then restore the original values. 8.000 4 Open Solver. Add a constraint where cell C7 >= 7.5 and then solve. 12.000 5 Save the scenario as Minimum 7.5 pounds and restore the original values. 8.000 6 Add a constraint where cell C6 = c5*2 and then click Solve. 12.000 7 Save the scenario as Twice as much fish as shrimp and restore the original values. 8.000 8 Open the Scenario Manager and create a scenario summary. As the Results cells type =\$j\$5,\$c\$7 to summarize results from cells J5 and C7. 10.000 9 Click the Weekly Sales worksheet. In cell I2, enter a SUMIF function that uses the Named Ranges MENU and CUPS to count the number of cups of soup sold for each menu in column H (use the cell reference H2 as the criteria) and then copy the formula down through cell I4. 10.000 10 In cell J2 enter a SUMIF function that uses the Named Ranges MENU and BOWLS to count the number of bowls of soup sold for each menu in column H (use the cell reference H2 as the criteria). Copy the formula down through cell J4. 10.000 11 In cell F2, enter an IF function with a nested AND function to test for lunch sales (in cell B2) of at least \$100 (cell E2), and that returns the word BEST when both conditions are met and leaves the cell blank for that day if not. Copy the formula down through cell F15. Use the conditional formatting rule Text that Contains to format the cells with a red border for those days that meet both conditions. 10.000 12 Ensure that the worksheets are correctly named and placed in the following order in the workbook:  Scenario Summary, Seafood Chowder Costs, Weekly Sales. Save the workbook. Close Excel. Submit the workbook as directed. 0.000 Total Points 100.000

## Assignment Description

Project Description:

In the following project, you will assist Bill Roman, Project Director, in creating a macro that will assign an operations department heading required on all reports. You will modify the macro by changing the Visual Basic Code.

Instructions:

For the purpose of grading the project you are required to perform the following tasks: