Create a name for restaurant and a company logo

Assignment Help HR Management

Reference no: EM133498756

You need to format the titles and numeric data in the ChickenSales sheet. In addition, you want to freeze the column labels so that they do not scroll offscreen. You also want to apply conditional formatting to emphasize values above the average value.

Create a name for this restaurant and a company logo (image file). Insert your company logo (image file) into the ChickenSales and PoultryLoan worksheets and place the top-right corner of the logo in cell A1. Ensure the logo does not overlap other content. Ensure the logo is the same size on both worksheets.
On the ChickenSales worksheet, merge and center the main title Chicken Sales Analysis, across the Menu Item table. Format the title in a larger font and fill the cell with colour.
Move the date cells (C4:D4) to H1:I1.
Apply the "Currency" number format to the monetary values in columns E and F.
Format the Avg Monthly Qty Sold values with one decimal place.
Freeze column A so it does on scroll offscreen.
Apply conditional formatting to values in the Total Revenue column. When a cell's value is greater than the average of the values in the column the cell fills with colour.
Change the dark purple formatting on the column headings on the ChickenSales worksheet to some other colour(s) that better suit your company logo and company colours. Ensure the cell contents fit the cell and are clearly visible.
Click on the PoultryLoan worksheet. You would like to use the repayment option that keeps the quarterly payment amount under $2000, has the shortest term, and the lowest interest rate. Locate the ONE cell that meets these conditions and add a Comment saying Winner! (or something of that sort).

Reference no: EM133498756

Questions Cloud

How that particular institution goes about controlling : Analyze, in your essay, how that particular institution goes about controlling and organizing the human beings that are a part of it.

Describe your feelings about that issue : Describe your feelings about that issue or your emotional response Evaluate the response: was it a good response, a bad response, or something

What was unexpected or surprising in your use of the concept : SOCW 6002- What was unexpected or surprising in your use of this concept? What did you learn from your attempt to use or incorporate this into your work?

How would you address albert beliefs : How would you address Albert's beliefs? What learning would be needed in each domain? What learning theories would you consider? How might his family concern

Create a name for restaurant and a company logo : Create a name for restaurant and a company logo (image file). Insert your company logo (image file) into the ChickenSales and PoultryLoan worksheets

Explain why these worker variables affect : What are the worker variables that the authors found to affect the pay-for-performance structure that firms use?

Examine the reason for the development of lingua francas : Illustrate the development of language as a means of communicating concepts. - Examine the reason for the development of lingua francas.

What did you learn about your own leadership : What did you learn about your own leadership, your development or the development process? Capture this in Part 10 of your Development Summary.

What is due process and what does it require : What is due process and what does it require? What is the legal source for public employee due process? When are public employees entitled to due process

User Account

All Pages