Let us worry about your assignment instead!

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

SOLVED
CategoryProgramming
SubjectExcel
DifficultyCollege
StatusSolved
More InfoExcel Assignments
54991

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

GO16_XL_CH08_GRADER_8F_HW - Seafood Chowder 1.1

 

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

GO16_XL_CH09_GRADER_9E_HW - Operations 1.0

 

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:

Step

Instructions

Points Possible

1

Start Excel. Verify that the Developer tab is enabled and the Macro Settings are set to Disable all macros with notification. From your student files, open the file go16_xl_ch09_grader_9e_hw.xlsx. Display the Save As dialog box, navigate to your Excel Chapter 9 folder, set the Save as type to Excel Macro-Enabled Workbook, and as the file name, type Lastname_Firstname_9E_Operations

0.000

2

With cell A1 active, record a macro with the name Operations_Header and the shortcut key CTRL+O. Store the macro in this workbook. As the description, type Fills in Operations report heading and then click OK to begin recording the macro.

20.000

3

Insert two blank rows at the top of the worksheet, and then click cell A1. Type WPHRC Operations Department and then Merge & Center the text you typed across the range A1:E1. Apply the Title cell style. In cell A2, type Quarterly Report and then Merge & Center the text you typed across the range A2:E2. Apply the Heading 1 cell style. Center the worksheet Horizontally, click cell A1, and then stop recording the macro.

46.000

4

Delete rows 1:2, click cell A1, and then test the macro.

0.000

5

On the Developer tab, in the Code group, click Macros. Verify that the Operations_Header macro is selected, and then click Edit. Scroll down and locate the first instance of End With, and then in the fourth line following End With, edit Quarterly Report to indicate Quarterly Operations Report.

0.000

6

Click File, and then click Close and Return to Microsoft Excel. Delete rows 1:2, click cell A1, and then use the keyboard shortcut to run the macro to test that Quarterly Operations Report displays as the subtitle of the report.

5.000

7

Insert the file name in the left section of the footer. Display the worksheet in Print Preview and verify that the worksheet is centered horizontally. Display the file properties. As the Tags, type operations department report and as the Subject, type your course name and section number. Under Related People, be sure that your name displays as Author.

13.000

8

On the Developer tab, in the Code group, click Macros. Select your Operations_Header macro, and then click Edit. Press CTRL+A to select all of the code. Press CTRL+C to copy the code to the clipboard. Close and Return to Microsoft Excel.

In the sheet tab area, click New sheet to insert a new worksheet. Rename the inserted sheet Macro Code In the Macro Code sheet, with cell A1 active, on the Home tab, in the Clipboard group, click Paste to paste the code to the new worksheet.

16.000

9

Click the File tab, and then click Save As. Navigate to your Excel Chapter 9 folder, and then click the Save as type arrow. Click Excel workbook. In the File name box, type Lastname_Firstname_9E_Operations_MyITLab and then click Save. In the displayed message box, click Yes.

Close your file and submit your Lastname_Firstname_9E_Operations_MyITLab.xlsx file as directed.

0.000

 

Total Points

100.000

 

 

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On

soc fb soc insta


Paypal supported