$4$

Homework #$1$

Note: The F$4$ key is a shoricut that will make row and column references absolutc$.$ Take a ceil containing a formula, such as $B9+B10.$ Put your cursor by the $B9$ portion of the equation, and click F$4.$ You will get $$B$$$9.$

Copy cell B$14$ to the range $C14-H14.$ This will give you the total cost of producing the ladders at each production level.

Step $7$: Now make the range A$8-$H$14$ look a bit more polished. All of the following commands are on the "Home" ribbon in Excel.

Alignment: select cell B$8,$ which contains the text "Total $($$$)"$ and right align this cell. You can select the cell and click the Align Right button in the Alignment group $($if you are not sure which button to use, just move your cursor over the buttons and look at the tool tips$).$

Borders: select the range of cells A$8-$H$8$ and underline them by clicking on the borders button in the Font group. This icon should appear directly below the font size icon. The borders button has a dropdown arrow... you should use the dropdown arrow and select the button labeled "Bottom Border". Next, apply the same type of bottom border to the cell range A$13-$H$13.$ Now select the entire range, A$8-$H$14,$ and use the border button again, applying the "Thick Box Border".

Highlighting: select the range A$8-$H$8$ and click the "Fill Color" button in the Font group, which looks like a bucket and is just to the right of the border button. Fill this range of cells with yellow highlighting. Next fill the range A$14-$H$14$ with yellow highlighting. Select A$14-$H$14$ and format these cells with bold font. You can use the Bold toolbar button or you can use the keyboard shortcut Ctrl$+$B$.$

Number format: the numbers are a bit hard to read. One standard technique used to make numbers more readable is to add commas to separate thousands $($e$.$g$.,70000$ becomes $70,000).$ Select C$8-$H$14,$ right$-$click and select "Format Cells". Under "category" click on "Number" which is the second one on the list. After "decimal places" you will see a number box with a drop arrow. Change this number to zero and check the box directly below it that is called "use $1000$ separator $(,)"$ and then press OK$.$ All of your numbers should contain commas and have zero decimal places.

Q$3$: What is the projected total cost of parts if Janet assembles $8,500$ ladders? As you answer this question, use the paste$-$special function so that the Excel table looks nice in your output. For this paste, copy the cell range A$8-$H$14,$ and then in your Word document go to the Home ribbon and select the Paste Icon $($with the triangle pointing down$)$and then Paste Special..., select Picture, and then click OK$.$

Now is a good time to experiment with various ways to paste information from Excel into a report. After selecting Paste Special, you will see that several options exist. Also, when you print the Picture, your output may not contain all of the gridlines that are helpful to see when reading a report. The rows and columns in your report should be shown with all gridlines. If gridlines did not print, go back to Excel. Click on the Page Layout ribbon on the top of the page. In the

HW$1-4$