![]() Save PR1 Medical Office Budget workbook.Add a footer to the Budget worksheet that shows the page number in the lower right corner.Add a header to the Budget worksheet that shows the date in the upper left corner and your name in the center.Use Fit to 1 page so the Budget worksheet prints on one piece of paper, if it does not already.Change the orientation of the Budget worksheet so it prints landscape instead of portrait.Double click the Sheet1 worksheet tab to change the name of Sheet1 to the word Budget, and press the ENTER key.Select the All Borders option from the drop-down list. Highlight the range A1:F8 and click the down arrow next to the Borders button in the Home tab of the Ribbon.Format the range B3:F8 with Accounting format and zero decimal places.Copy the formula in cell B3 and paste them into the range B4:B8.Then, highlight the range C3:F3 and press the ENTER key on your keyboard. Click the Sum option from the drop-down list. Activate cell B3 and click the down arrow on the AutoSum button in the Formulas tab of the Ribbon. Calculate the total budget for all four quarters for the salaries.Then, highlight the range D6:F8 and click the Paste button in the Home tab of the Ribbon. Copy the contents in the range C6:C8 by highlighting the range and clicking the Copy button in the Home tab of the Ribbon.Copy cell C3 and paste the contents into the range D3:F3.Select B2 and choose the Wrap Text button in the Home tab of the Ribbon. ![]() Set the alignment in cell B2 to Wrap Text.Center the column titles so that they are horizontally centered in each cell. Make the following format adjustment to the range A2:F2: bold and change the cell fill color to Tan, Background 2, Darker 10%.Increase the height of Row 1 to approximately 24.75 points.Make the following format adjustments to the range A1:F1: bold italics change the font size to 14 points change the cell fill color to Aqua, Accent 5, Darker 50% and change the font color to white.Highlight the range A1:F1 and click the Merge & Center button in the Home tab of the Ribbon to merge the cells in that range.Adjust the width of Column B to approximately 13.29 characters. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |