Assignment related to excel

Assignment Help Basic Computer Science
Reference no: EM13725371

Problem: The computer-consulting firm you and a friend started recently on a part-time basis has received its first contract. The client has specified in the contract, that you are to build a monthly sales analysis worksheet that is capable of monitoring the sales performance of each sales person on their staff. Sales performance includes keeping track of each sales person's sales but also keeping in mind that some customers return items so net sales, (sales less returns) are very important. The client also wants you to graphically show the relationship between net sales and individual net sales. All salespeople have a minimum quota of $9,500. There are four sales people. You must determine their first and last names. Give your company a Name.

Sales person #1 had sales of $19,789 with returns of $1,345.00 and a number of items sold of 9674. Sales person #2 had sales of $11,550.00 with returns of $500 and a number of items sold of 6441. Sales person #3 had sales of $10,295 with returns of $1,276 and a number of items sold of 3214 and Sales person #4 had sales of $10,955 with returns of $650 and for the number of items sold, 4000. Each salesperson had a sales quota of $9,500.00. Use the concepts and techniques presented in this class to create a worksheet and charts.

Part I Instructions:

1. Use the "Select All" button and the "bold" buttons to bold the entire worksheet.

2. Design and create your own Company name and worksheet title

3. Enter column titles (Sales Person, Sales, Returns, Number of Items Sold, Net Sales, Sales Quota and Above Quota) and the row titles below that (Sales people names).

4. Enter the sales and sales returns in the columns.

Part II Instructions

1. Increase the widths of each column so all content in appropriately displayed.

2. Obtain the Net Sales of each sales person in the appropriate column of the worksheet by subtracting the sales returns from the sales amount.

3. Obtain the above quota amounts by subtracting the sales quota from the net sales.

4. Enter the row title Total and find the total of each column except the Number of items sold, and Sales Quota. Apply the Total Cell Style.

5. Below Total row enter the row titles:

1. Average of Sales

2. Max,

3. Min

4. Use the appropriate functions to find the values of each column. (Do not find the values for the Number of Items Sold, the SalesQuota, and Above Quota column).

6. Change the worksheet title font (company name and sub-title)to an appropriate font type and size

7. Italicize the column titles and center in bold.

8. Apply a cell style of your choice to the ranges that contain the title of the worksheet and the subtitle.

9. Change the text color of the Worksheet Title (company name and sub-title), to a dark color of your choice. Rotate the column titles at a 45 degree angle and wrap text.

10. Merge and center the Company name and worksheet title that you created in Row one.

11. Apply a heading cell style to the range that contains the column headings.

12. Increase the height of row 1 to 42.00 points and increase the heights of rows 2 and 8 to 24.00 points

13. Use the buttons on the Formatting toolbar to apply the Comma Style with two decimal places in the ranges that contain numeric values.

14. Apply the Comma style with no decimals in the ranges that contains the Number of Items Sold.

15. Select the ranges that have the totals of each column and assign a floating dollar sign.

16. Apply any Cell Style to the range that contains the range A4:G7 and the total cell style to the total row.

17. Using conditional formatting, apply a color pattern of your choice to all sales people who did not meet their sales quotas, in the appropriate Net Sales column.

19. Apply the currency style format with a fixed dollar sign to the range that contains the Net Sales for each employee.

20. Enter Professor's name below the entries in separate cells after your last entry.

21. Add a footer that includes your Name on the left, the page number on the center, and the date and time on the right; make sure that the date is updated automatically.

22. Save the workbook using the filename Excel Exam Your Name.


Part III Instructions:

1. Select the ranges that contain the salesperson's names and their net sales. Use the Chart command on the Insert menu to create a chart on a new sheet.

2. Draw a 3-D Column chart (clustered column with 3-D effect).

3. Do the following to the chart:

(a) The data series for this chart is in columns.

(b) There is no legend on the chart.

(c) The chart does have a title of Net Sales Your Name

(d) Change the color of the chart walls to a light color pattern of your choice and change the color of the columns to a dark color pattern.

(e) Change the font size of the chart title to 24 points and the color of the text to the same color as the columns.

(f) Change the font of the data labels to 12 point, bold, same color as title.

Part IV Instructions:

Following the above conditions, create a 3-D Pie chart with 3-D visual effect on a separate sheet using the same ranges you used for the 3-D Column Chart, with the same title.
Do not change the colors of the pie, but create it without a legend and with leader lines, labels and percents. Show the leader lines and change the font in the title to Garamond Bold 24 dark color pattern, and each label to Garamond 12, bold, the same color as title.

Reference no: EM13725371

Questions Cloud

Select a government regulation : Select a Government Regulation. Identify a particular government regulation of your choosing that in your opinion has either been successful or a failure. Briefly state the original purpose of this regulation and whether it has changed over t..
Explian promotional strategy for your product or service : Your promotional strategy for your product or service, including how you may use the following: Advertising, Public relations, Digital marketing
What criteria must be met for a binomial probability : Describe and discuss the difference between the various types of discrete probability distributions. What criteria must be met for a binomial probability distribution? Which of the characteristics would be the most difficult to satisfy? Why?
Explain the three main channels : Explain the three main channels (not the Fed's tools: omo, rr, dr) through which the Fed can influence economic activity. Specifically explain the ways that Fed policy can influence consumption and investment.
Assignment related to excel : 1. Use the "Select All" button and the "bold" buttons to bold the entire worksheet. 2. Design and create your own Company name and worksheet title 3. Enter column titles (Sales Person, Sales, Returns, Number of Items Sold, Net Sales, Sales Quota an..
Produce an identical product : There are two firms in a market that produce an identical product. Each firm has either one or zero units to sell. The probability of having a unit to sell is q and the probability of having no units to sell is 1-q. There is a single consumer ..
Write an essay on the civil rights movement : The Civil Rights Movement of 1960's. A Short Paper Assignment allows you, early in the course, to demonstrate your research skills to your instructor and to receive feedback that will benefit you when you write your research paper.
Compare and contrast the major microeconomic failures : Essay Topic: Compare and contrast the major microeconomic failures and macroeconomic failures that you learned this semester.To get you started concentrate on two distinct chapters in the Schiller textbook. See chapter 4 for an analysis of the prob..
Child abilities to learn and interact with others : Briefly discuss how this illness might affect the child's abilities to learn and interact with others, and how it might affect his/her peers or the climate of his/her surrounding environment. (Feel free to share any experiences and/or insights you..

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Describe how the system will identify and authenticate

Describe how the system will identify and authenticate all the users who attempt to access ABC Healthcare information resources

  Critique website that is different to rest of our friends

Web devolving assignment - Critique a website that is different to the rest of our friends-classmates.

  Examine and analyze the principles of inheritance

Examine and analyze the principles of inheritance. Use the Library to get started on finding resources.

  What would be the best choice of the degree

A B+ - tree index is to be built on the name attribute of the relation student. Assume that all the student names are o length 8bytes, disk blocks are of size 512 bytes , and index pointer are of size 4bytes. Given this scenariom, what would be th..

  Error detection-correction facility-interpreters- compilers

Compare error detection and correction facilities of interpreters and compilers. Compare static and dynamic linking. With respect to the requirements of modern applications, what are the shortcomings of 3GLs?

  Realize the policy covered before

What are two items that you didn't realize the policy covered before?

  Swing gui to translate test this is input in english

Design and code a SWING GUI to translate test this is input in English into Pig Latin.You can assume that the sentence contains no punctuation. The rules for Pig Latin are

  How to make sure that written work is free of grammar

How do you make sure that written work is free of grammar and spelling errors? Write down tools or secrets do you use?

  Cost per server

cost per server

  Define electronic monitoring and employee productivity

Your task is to prepare a concise report that considers the relevant issues in electronic monitoring, employee productivity, and makes a recommendation. Your report should include a discussion of the current trend to use electronic monitoring to m..

  Summarize by outlining the sequence of operations

Explain how an operating system can temporarily pass control of the CPU over to user code without risking an indefinite loss of control. Discuss the roles of timer interrupts, privileged mode operation, and memory protection and explain why all of..

  Describe an algorithm

Describe an algorithm for determining if a given list contains a cycle using only constant additional space. The runtime should be O(N), where N is the (unknown) number of elements in the list. (Hint: use two iterators that advance at different sp..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd