# Override for incorrect file types discussion

Computer
Applications for Business

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 will not need to use files from the textbook for the
assignment

Sales Summary Worksheet

Problem:You have been asked to build a worksheet for
that analyzes the financing needs for the
companys 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 companys first year are shown in Table 27. The desired
worksheet is shown in Figure 273. 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).

Figure 2-73

Description automatically generated” v:shapes=”Picture_x0020_1″ style=”box-sizing: border-box; outline: none; border: 0px; vertical-align: middle;”>

1. Increase the width of column A to 12.00 and the
width of columns B through F to

14.50.3.

1. Enter the worksheet titleInternational Moving Companyin cell A1 and the worksheet
subtitleFinancing Needsin cell A2. Enter the column titles in row
3, as shown in Figure

273.
In row 3, useALT+ENTERto start a new
line in a cell.4.

1. Enter the financing needs data described
inTable 2-7in 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 inFigure 273.5.

1. For the months of February through December, the
starting balance is equal to the previous months 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.

1. Obtain 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.

1. In 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.

1. Change the word international in cell A1 to
yourlastname. 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.

1. Center the titles in row 3, columns A through F.
Italicize and bold the row titles in the range A16:A18.10.

1. Draw 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.

1. Change the row heights of row 3 to 42.00 points
and row 16 to 33.00 points.12.

1. Assign the 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.

1. Rename the sheet tab asFinancing Needs. Apply the Orange color from the standard colors (column 3) to
the sheet tab.14.

1. In
cellA20studenttypes theirfull name, in
Cell A21CS 155 and in cell A22class section.

1. Save the file as CS155Week5LastnameFirstname.
.Ensure that you useyourlastnameand
firstname.16.

1. Display the formulas version by pressingCTRL+ACCENT MARK(`).Change the display from
the formulas version to the values version by pressingCTRL+ACCENT MARK(`).8.

1. In reviewing the worksheet you created, how do
you think the company could obtain a positive result without increasing income
or decreasing expenses?Answer these questions asked in comments or
submission text area when submitting

Save file after completing and submit work by
attaching file to week 5 assignment submission area.

Note:Review grading criteria in rubric below Grading
Criteria:

 Grading CriteriaAssignment Maximum Points Column A and B widthchanged 3 Worksheet title andsubtitle changed Background (fill)color A1, A2, and F8 all same color 10 Column and row titlesentered. Merge and center worksheet title and subtitle across 10 Data entered Startingbalance completed 12 Net amount formula forcolumn E balance formula for column F 8 Average, Min, Maxfunction and copied range B16:B18 and F16:F18 15 Font size cell A1-26,bold title and subtitle, italicize and bold row titles A16:A18, thick outsideborder A1:A12 and A16:F18 8 Center titles row 3, columns A-F. Row height row 3 to 42 pts, row 16 to 33 pts 4 Assign accountingnumber format, comma style format with floating dollar sign to rangesindicated 6 Rename the sheet tabas Financing Needs. Sheet tab color orange 4 Type name, coursenumber, course section in cells A20, A21 and A22 6 Step 16 questionsanswered 4 FilenameCS155Week5lastnamefirstname 10 Override for incorrectfile type, template used or incorrect content 100

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
• 24/7 support
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
• Expert Proofreading
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

### Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

### Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Need assignment help? You can contact our live agent via WhatsApp using +1 718 717 2861

Feel free to ask questions, clarifications, or discounts available when placing an order.
+1 718 717 2861           + 44 161 818 7126           [email protected]
+1 718 717 2861         [email protected]