Complete Microsoft Excel Activity (FORD)

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

Need help with my Excel question – I’m studying for my class.

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 International Moving Company that analyzes the financing needs for the company’s 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’s first year are shown in Table 2–7. The desired worksheet is shown in Figure 2–73. 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).

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

2.Enter the worksheet title International Moving Company in cell A1 and the worksheet subtitle Financing Needs in cell A2. Enter the column titles in row 3, as shown in Figure 2–74. In row 3, use alt+enter to start a new line in a cell.4.

3.Enter the financing needs data described in Table 2-7 in 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 Figure 2–73.5.

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

5.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.

6.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.

7.Change the word “international” in cell A1 to your lastname. 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.

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

9.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.

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

11.Assign 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.

12.Rename the sheet tab as Financing Needs. Apply the Orange color from the standard colors (column 3) to the sheet tab.14.

13.In cell A20 student types their full name, in Cell A21 CS 155 and in cell A22 class section.

14.Save the file as CS155Week5LastnameFirstname. . Ensure that you use your lastname and firstname.16.

15.Display the formulas version by pressing ctrl+accent mark (`).Change the display from the formulas version to the values version by pressing ctrl+accent mark (`). 8.

16.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 submittingAnswers with no supporting work will receive no credit.
I need help with a Calculus question. All explanations and answers will be used to help me learn.

1) Evaluate the following integral.

2) Evaluate the following integral.

3) Texas was the third fastest growing state in the United States in 2016. Texas grew from 25.1 million in 2010 to 26.47 million in 2016. Use an exponential growth model to predict the population of Texas in 2025.

4) Evaluate the following integral.I need help with 2full pages: online nursing assignment help
I’m stuck on a English question and need an explanation.

Read “French Resistance – The Right to Self-Defense” by Charles de Gaulle and summarize the author’s argument without context with the Toulmin Method and analyze his effectiveness in a 2-page paper.

Remember, this is analysis of regular rhetorical strategies, so it will be very similar to the first 2-page paper on Benatar. My notes that I gave you on that one will be helpful to review in preparing for this one. Remember also that the point of this paper is analysis, not summary. Obviously summary is required, but only enough to then analyze what you’ve just summarized.

As toward the format, you’ll probably want an introductory paragraph with the author’s name (Charles De Gaulle), the pamphlet’s title (“The Right to Self-Defense”), the author’s Main Claim (that the French have a right to defend themselves against their German occupiers), and whether or not you will find it effective.

There should be about two or three body paragraphs, and these body paragraphs will look at two or three Reasonings the author has to support his Main Claim. Summarize the Reasonings, quote where you find them (and cite it), then analyze the effectiveness of the rhetorical strategies being used to make those Reasonings. Remember that it is not enough to simply claim that the strategies are effective or ineffective and then move on. You have to prove to me that the specific use of the rhetorical strategy you are analyzing is either effective or ineffective to the average reader. Your paper will be graded on your ability to convince your reader of the author’s effectiveness or ineffectiveness (and your Grammatical correctness, obviously). For now, avoid any context on the reading or the author, as we’ll add that later in another paper. Analyze the argument in a vacuum of context. (You’ll like Charles de Gaulle, though. He’s awesome.)

You will also want a conclusion paragraph which adds no new information to your analysis, but rather summarizes your body paragraphs and restates your Main Claim about the author’s effectiveness or ineffectiveness.

You do not need a Works Cited for this paper, but you do need:

At least 2 pages of writing.

And standard MLA formatting, including an MLA introduction.math work final: nursing essay help
I don’t understand this Mathematics question and need help to study.

111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111Maths word
I’m stuck on a Mathematics question and need an explanation.

Question 1:

A bakery has been baking 4000 donuts a day for distribution. . The second shift has produced 1000 donuts fewer than two-thirds of the number of donuts produced by the first shift. Determine the number of donuts each shift has produced (5 marks)

Question 2:

Carla is paid a semi-monthly salary of $1870.80. Her regular workweek is 40 hours. Overtime is paid at time and one-half regular pay.

a) What is Carla’s hourly rate of pay?

b) What is Carla’s gross pay if she worked 7 1/2 hours overtime in one pay period? (10 marks)

Question 3:

Tarfex Tech intended to sell a new product in order to keep up with customer demands. The product was to be sold to consumers at $620, creating a contribution margin of $150 per unit. They spent $9800 on advertising and were able to sell 1,200 units on the first day. Determine the resulting profit (5 marks)

Question 4:

Your college newspaper, The Collegiate Investigator, has fixed production costs of $70 per edition, and marginal printing and distribution costs of 40¢/copy. The Collegiate Investigator sells for 50¢/copy. Write down the associated cost, revenue, and profit functions. (10 marks)

Question 5:

Determine the equivalent single rate of discount for each of the following series of discounts. (10 marks)

a) 18 %, 10.0%

b) 50%, 33%, 5.0%

Question 6:

A discount store lists an article for $875.00 less 25% and 20.5%. a competitor carries the same article for $847.90 less 21.5%. What further discount (correct to the nearest of 1%) must the competitor allow so that its net price will be the same as that of the discount store? (5 marks)

Question 7:

A cloth store sells a jacket for $ 550. The store’s cost is $95, and the expenses are 20% of the regular selling price. How much profit will the shop make on each sale? (5 marks)

Question 8:

Calculate the amount of interest that will be charged on $10680.00 borrowed for five months at 6.5%. (5 marks)

Question 9

What rate of interest is paid if the interest on a loan of $55 000.00 is $125000.00 from January 31, 2014 to May 31, 2014? (10 marks)

Question 10:

What principal will have a maturity value of $159 000 at 5.6% p.a. in 14 months? (10 marks)

Question 11:

Debt payments of $500.00 due now and $1400.00 due in five months are to be repaid by a payment of $1500.00 in three months and a final payment in eight months. Calculate the size of the final payment if interest is 5%. (10 marks)

Question 12:

Debt payments of $400.00, $8000.00, $1600.00 are due on March 1, May 1, and December 1 of the same year. If interest is 6% calculate the single payment on August 1 of the same year that would replace the three payments. (10 marks)

Question 13:

Compute the amount of interest on $567.00 at 10% p.a. from May 29, 2013 to August 13, 2013 (5 marks)

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services