\n

\n MS Excel: Sales Worksheet Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment. NOTE: You\n <\/p>\n

\n MS Excel: Sales Worksheet\n <\/p>\n

\n Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment.\n <\/p>\n

\n NOTE:\u00a0\u00a0You will not need to use files from the textbook for the assignment\n <\/p>\n

\n Sales Summary Worksheet\n <\/p>\n

\n Problem:\u00a0You have been asked to build a worksheet for International Moving Company that analyzes the financing needs for the company\u2019s first year in business. The company plans to begin operations in January with an initial investment of $750,000.00. The expected revenue and costs for the company\u2019s first year are shown in Table 2\u20137. The desired worksheet is shown in Figure 2\u201373. The initial investment is shown as the starting balance for January (cell B4). The amount of financing required by the company is shown as the lowest ending balance (cell F18).\n <\/p>\n

\n https:\/\/www.mediafire.com\/file\/dz4h9dx88pfow4c\/Week_5_Computer_Assignment.docx\/file\n <\/p>\n<\/div>\n

MS Excel: Sales Worksheet Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment. NOTE: You M
\n MS Excel: Sales Worksheet Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment. NOTE:\u00a0\u00a0You will not need to use files from the textbook for the assignment Sales Summary Worksheet Problem:\u00a0You have been asked to build a worksheet for International Moving Company that analyzes the financing needs for the company\u2019s first year in business. The company plans to begin operations in January with an initial investment of $750,000.00. The expected revenue and costs for the company\u2019s first year are shown in Table 2\u20137. The desired worksheet is shown in Figure 2\u201373. The initial investment is shown as the starting balance for January (cell B4). The amount of financing required by the company is shown as the lowest ending balance (cell F18).\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0Figure 2-73 \u00a0 \u00a0 \u00a0\u00a0 1.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Increase the width of column A to 12.00 and the width of columns B through F to 14.50.3.\u00a0\u00a0 2.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Enter the worksheet title\u00a0International Moving Company\u00a0in cell A1 and the worksheet subtitle\u00a0Financing Needs\u00a0in cell A2. Enter the column titles in row 3, as shown in Figure 2\u201373. In row 3, use\u00a0ALT+ENTER\u00a0to start a new line in a cell.4.\u00a0\u00a0 3.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Enter the financing needs data described in\u00a0Table 2-7\u00a0in columns A, C, and D in rows 4 through 15. Enter the initial starting balance (cell B4) of 750000.00. Enter the row titles in the range A16:A18, as shown in\u00a0Figure 2\u201373.5.\u00a0\u00a0 4.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0For the months of February through December, the starting balance is equal to the previous month\u2019s ending balance. Obtain the starting balance for February by setting the starting balance of February to the ending balance of January. Use a cell reference rather than typing in the data. Copy the formula for February to the remaining months.6.\u00a0\u00a0 5.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Obtain the net amounts in column E by subtracting the expenses in column D from the incomes in column C. Enter the formula in cell E4 and copy it to the range E5:E15. Obtain the ending balance amounts in column F by adding the starting balance in column B to the net in column E. Enter the formula in cell F4 and copy it to the range F5:F15.7.\u00a0\u00a0 6.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0In the range B16:B18, use the AVERAGE, MAX, and MIN functions to determine the average value, highest value, and lowest value in the range B4:B15. Copy the range B16:B18 to the range C16:F18.8.\u00a0\u00a0 7.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Change the word \u201cinternational\u201d in cell A1 to your\u00a0lastname. One at a time, merge and center the worksheet title and subtitle across columns A through F. Select cells A1 and A2 and change the background color to a color of your choice. Change the worksheet title in cell A1 to 26-point and the subtitle in A2 to 20 point. . Bold both the title and subtitle. Draw a thick outside border around the range A1:A2.9.\u00a0\u00a0 8.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Center the titles in row 3, columns A through F. Italicize and bold the row titles in the range A16:A18.10.\u00a0\u00a0 9.\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Draw a thick outside border around the range A16:F18. Change the background color for cell F18 to the same colors applied to the worksheet title in Step 7.11.\u00a0\u00a0 10.\u00a0\u00a0Change the row heights of row 3 to 42.00 points and row 16 to 33.00 points.12.\u00a0\u00a0 11.\u00a0\u00a0Assign the accounting number format to the range B4:F4. Assign the comma style format to the range B5:F15. Assign a currency format with a floating dollar sign to the range B16:F18.13.\u00a0\u00a0 12.\u00a0\u00a0Rename the sheet tab as\u00a0Financing Needs. Apply the Orange color from the standard colors (column 3) to the sheet tab.14.\u00a0\u00a0 13.\u00a0\u00a0In cell\u00a0A20\u00a0\u00a0student\u00a0types their\u00a0full name, in Cell A21\u00a0\u00a0CS 155 and in cell A22\u00a0\u00a0class section.\u00a0\u00a0 14.\u00a0\u00a0Save the file as CS155Week5LastnameFirstname. .\u00a0\u00a0Ensure that you use\u00a0your\u00a0lastname\u00a0and firstname.16.\u00a0\u00a0 15.\u00a0\u00a0Display the formulas version by pressing\u00a0CTRL+ACCENT MARK\u00a0(`).Change the display from the formulas version to the values version by pressing\u00a0CTRL+ACCENT MARK\u00a0(`).\u00a08.\u00a0\u00a0 16.\u00a0\u00a0In reviewing the worksheet you created, how do you think the company could obtain a positive result without increasing income or decreasing expenses?\u00a0Answer these questions asked in comments or submission text area when submitting<\/p>\n","protected":false},"excerpt":{"rendered":"

MS Excel: Sales Worksheet Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. A template is not allowed for assignment. NOTE: You MS Excel: Sales Worksheet Start with a new spreadsheet in Microsoft Excel online or installed version of Microsoft Excel with no template applied. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_joinchat":[]},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/281826"}],"collection":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/comments?post=281826"}],"version-history":[{"count":0,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/posts\/281826\/revisions"}],"wp:attachment":[{"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/media?parent=281826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/categories?post=281826"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qualityassignments.net\/wp-json\/wp\/v2\/tags?post=281826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}