# We Helped With This Excel Programming Homework: Have A Similar One?

SOLVED
Category Programming Excel College Solved Excel Assignment Help

## Short Assignment Requirements

I just need a new worksheet created in excel following the attached directions

## Assignment Description

Create a worksheet using Excel

TABLE 1

 Entertainment Room Business Center Banquet Rooms Conference Rooms Gift Shop Bar Restaurant Spa Total Net Revenue 357825 105454 210544 212300 175350 752900 845230 135478 Cost of Sales 35877 13900 38920 12850 86050 275890 275925 48275 Direct Expenses 30154 12550 14750 15300 42670 121500 126340 28100 Square Footage 5780 775 7550 9500 950 6275 8600 3750

Instructions Part # 1:

1.        Apply the Dividend Theme to the worksheet. Bold the entire worksheet.

2.        Change the column widths to best fit.  Continue doing this when necessary until you complete the workbook!

3.        Move row 7 (Square Footage information) to row 16.  Enter the row titles in (Table 2) in the range A7:A15. Right indent the text in the range A8:A13. Copy the row titles in range A8:A13 to the range A18:A23.  Add a column header to cell A17 called Planned Indirect Expenses.

TABLE 2

 Actual Indirect Expenses Administrative Depreciation Utilities Insurance Maintenance Advertising Total Indirect Expenses Net Income

4.       Center and italicize the column headings in the range B3:J3. Add a column header to cell J3 called Total. Add a bottom double border to the range B3:J3. Using the Sum function, create a formula to Sum the individual rows 4, 5, and 6 in the range J4:J6.

5.        Sum row 16 in cell J16. Format the range B16:J16 to the Comma format with no decimal places, use a thousand separator (,), and show negative numbers with a negative sign. Change row 16’s height to 35.  Horizontally and vertically center align range B16:J16 (Square Footage values).  Left-align and vertically center cell A16 (Square Footage title).

6.        Increase the font size in cells A7, A14, and A15 to 14-point.

7.        Enter the numbers shown in (Table 3) in the range B18:B23.  Format the range B18:B23 to the Comma format with no decimal places, use a thousand separator (,), and show negative numbers with a negative sign.

TABLE 3

 82500 49230 56300 13500 42130 68250

8.        Use the following formulas to accomplish the prorating of the indirect expenses (HINT - absolute and mixed cell referencing will be important when writing the below formulas…though, not all formulas require it):

a. Actual Administrative Indirect Expenses (cell B8) = Administrative Planned Indirect Expenses (cell B18) * Entertainment Room Total Net Revenue (cell B4) / Resort Total Net Revenue (cell J4).

b. Actual Depreciation Indirect Expenses (cell B9) = Depreciation Planned Indirect Expenses (cell B19) * Entertainment Room Square Footage (cell B16) / Total Square Footage (cell J16).

c. Actual Utilities Indirect Expenses (cell B10) = Utilities Planned Indirect Expenses (cell B20) * Entertainment Room Total Net Revenue (cell B4) / Resort Total Net Revenue (cell J4).

d. Actual Insurance Indirect Expenses (cell B11) = Insurance Planned Indirect Expenses (cell B21) * Entertainment Room Square Feet (cell B16) / Total Square Footage (cell J16).

e. Actual Maintenance Indirect Expenses (cell B12) = Maintenance Planned Indirect Expenses (cell B22) * Entertainment Room Square Footage (cell B16) / Total Square Footage (cell J16).

f. Actual Advertising Indirect Expenses (cell B13) = Advertising Planned Indirect Expenses (cell B23) * Entertainment Room Total Net Revenue (cell B4) / Resort Total Net Revenue (cell J4).

g. Total Indirect Expenses (cell B14) = Sum all of the Actual Indirect Expenses (range B8:B13).

h. Net Income (cell B15) = Entertainment Room Total Net Revenue - (Entertainment Room Cost of Sales + Entertainment Room Direct Expenses + Entertainment Room Total Indirect Expenses).

i.  Copy the range B8:B15 to the range C8:I15.

j. Sum the individual rows 8 through 15 in the range J8:J15.

9.      Apply conditional formatting to range B8:I13 so that cells with a value greater than \$15,000 appear with a sky blue background and a black text font color.

10.      Add a bottom double border to the range B13:J13.

11.      Assign the Currency style with currency symbol, two decimal places, and show negative numbers with a negative sign to the following ranges: B4:J4; B8:J8; and B14:J15. Assign the Comma style with two decimal places, use a thousand separator (,), and show negative numbers with a negative sign to the following ranges: B5:J6 and B9:J13.

Is it free to get my assignment evaluated?

Yes. No hidden fees. You pay for the solution only, and all the explanations about how to run it are included in the price. It takes up to 24 hours to get a quote from an expert. In some cases, we can help you faster if an expert is available, but you should always order in advance to avoid the risks. You can place a new order here.

How much does it cost?

The cost depends on many factors: how far away the deadline is, how hard/big the task is, if it is code only or a report, etc. We try to give rough estimates here, but it is just for orientation (in USD):

 Regular homework \$20 - \$150 Advanced homework \$100 - \$300 Group project or a report \$200 - \$500 Mid-term or final project \$200 - \$800 Live exam help \$100 - \$300 Full thesis \$1000 - \$3000

How do I pay?

Credit card or PayPal. You don't need to create/have a Payal account in order to pay by a credit card. Paypal offers you "buyer's protection" in case of any issues.

Why do I need to pay in advance?

We have no way to request money after we send you the solution. PayPal works as a middleman, which protects you in case of any disputes, so you should feel safe paying using PayPal.

Do you do essays?

No, unless it is a data analysis essay or report. This is because essays are very personal and it is easy to see when they are written by another person. This is not the case with math and programming.

Why there are no discounts?

It is because we don't want to lie - in such services no discount can be set in advance because we set the price knowing that there is a discount. For example, if we wanted to ask for \$100, we could tell that the price is \$200 and because you are special, we can do a 50% discount. It is the way all scam websites operate. We set honest prices instead, so there is no need for fake discounts.

Do you do live tutoring?

No, it is simply not how we operate. How often do you meet a great programmer who is also a great speaker? Rarely. It is why we encourage our experts to write down explanations instead of having a live call. It is often enough to get you started - analyzing and running the solutions is a big part of learning.

What happens if I am not satisfied with the solution?

Another expert will review the task, and if your claim is reasonable - we refund the payment and often block the freelancer from our platform. Because we are so harsh with our experts - the ones working with us are very trustworthy to deliver high-quality assignment solutions on time.

## Popular Solved Assignments Like This

Customer Feedback

"Thanks for explanations after the assignment was already completed... Emily is such a nice tutor! "

Order #13073

Find Us On