This website uses cookies to ensure you have the best experience. Learn more

Excel Final Essay

882 words - 4 pages

* A - (TCO 9) The data has been provided to you in one .csv file showing weekly sales for all three stores for the last three years. Explain the tasks you must complete in preparing the data for your analysis.
* B - (TCO 2) Explain, based on material covered in this class, your approach to setting up your worksheet and organizing the data. Remember that you have only weekly sales totals for each store in the data.
* C - (TCO 3) Explain how you will visually represent the comparison of the total annual sales at the individual stores for each of the three years. Describe methods to make your strongest performing store stand out.
* D - (TCO 7) Once you have finished the above ...view middle of the document...

The information that I was given was three years of weekly data for three different stores. I would have the businesses information at the top of the spreadsheet. In large font and in a specific color, let’s say blue. The top row of information would be the column headers East, West and Central. These would be in a lighter blue color and a smaller font that the title information. The Rows would each have a heading in column one which would be either Week 1 of Year 2012 or the date (1/1/10). I would have all of the weeks in the month below each other. At the end of each month I would do a row that would total the data for the entire month. It would be =sum(B2:B5) or something along those lines. The Row title would be Month 1 Total and it would be bold. I would continue down to the bottom of the first year. Then I would do a total for the entire year. This would look something like =sum(B2:B366). The row Title would be Year 1 Total and it would be bold so that it would stick out a bit. This makes all of my data organized and totaled for easy analysis.
C
I would then take all of the yearly information for each of the three stores that I computed and make it into a 3D stacked column graph. In order to do this I would make a new sheet (This would be my third sheet) and name it Yearly...

Other Papers Like Excel Final

Diamonds - Should You Buy? Essay

630 words - 3 pages Data Selection (refer to Excel sheets: Scatter1 and Scatter2) We used Excel to draw a scatter plot to see the relationship between price and carat. The data presented two different groups of data: 1) Diamonds at low prices with low carat and (2) diamonds at high prices with high carat weight. The data with the diamonds at low prices and low carat is irrelevant so we excluded that portion of the data which had prices under $1000. Selected

Itm 442 Module 2 Essay

951 words - 4 pages importing the Excel model, the data used in the decision-making process. Next was setting up the map, the navigational component representing the data to display, and the line chart displaying the data values. The tutorial used comparison charts to facilitate the decision making process. Comparison charts simplify the process of performing detailed analysis during the decision making process. This tutorial used four separate comparison

Math 211 Course Syllabus

2365 words - 10 pages : Week Four Explorations |10 | |Learning Team Assignment: Week Four Excel® Activities | 5 | |Week Five |  | |Individual Assignment: Final Examination

Stock Anlysis

970 words - 4 pages . | | | | 4 - How Excel help with this exercise and other activities with the data provided: This scenario spreadsheet contains a basic formula math, statistic and very easy to understand. It calculation requires several iterations to arrive at an answer only require entering a few basic formula components for Excel to calculate the final answer. In addition, the time needed to get the answer is

IT 206 UOP Tutorial / it206dotcom

955 words - 4 pages IT 206 Entire Course IT 206 Week 1 CheckPoint Formatting Issues IT 206 Week 1 DQ 1 and DQ 2 IT 206 Week 2 CheckPoint Knowing Where You Placed Your Document IT 206 week 2 Assignment Microsoft Word Exercise IT 206 Week 3 CheckPoint Simplifying Your Excel Usage IT 206 week 3 DQ 1 and DQ 2 IT 206 Week 4 CheckPoint The Risk of Macros IT 206 Week 4 Assignment Microsoft Excel Exercise IT 206 Week 5 CheckPoint Mail Merging IT 206 Week 5 DQ 1

Bec Computerized Grading System

850 words - 4 pages Subject see the excel files for demo BEC, for DEMO physics, K+12 , sample 1 for grade school This is the grade format intended for the computation of teacher’s grade. Every teacher will only enter the raw scores taken from the teacher’s class records and all the computations will be done by the computer. The desired output is the unrounded final grades, rounded final grades, students’ individual ranking and subject’s top ten lists. * Summary

Bsb123 Tha 2

753 words - 4 pages : Table [ 3 ]. Descriptive Statistics worked out in excel using 'Data analysis'. Table [ 3 ]. Descriptive Statistics worked out in excel using 'Data analysis'. Figure [ 1 ]. Box-plot of sample Final Exam scores of a Statistic course. Figure [ 1 ]. Box-plot of sample Final Exam scores of a Statistic course. Discussion: The central location of the sample data tends to fall in the higher portion of the data set meaning

Management

1178 words - 5 pages Section –A (10 X 1.5=15) Answer all the questions 1. What is computer? 2. Define operating system. 3. How do you close the word document? 4. State the shortcut Key to copy and paste. 5. Define print preview Ms-Excel. 6. List out the options in view menu. 7. Define Database. 8. What you mean by primary key? 9. How to start the power point? 10. How to move the text in power point? Section-B (5 X 4=20

Quant Analysis

1054 words - 5 pages right track. I will provide feedback on your progress if you ask for it.  3. Flexible situation: Read/understand the case, have some ideas about what method you will use to solve it and how you will set up the Excel model, and have a feasible plan that will help you finish the case by the final deadline. In this case, you can submit a draft or partially-complete Excel worksheet and I will provide feedback based on your submission.  Case: Location

Style Guide

3421 words - 14 pages customers who might be at a lower skill level. | | | |Final Project |Create an application support checklist for each Microsoft® Office application (Microsoft® |10/13 |250 | |Common Microsoft® Office User |Word, Microsoft® Excel®, Microsoft® Access®, Microsoft® PowerPoint®, and Microsoft® Outlook®)| | | |Errors

Request for Proposal

1575 words - 7 pages Access. This will also require regular practical exercises as well as continuous assessment tests. Projectors will be required for use by the trainer in displaying some of the concepts on the wall. A final exam covering the entire course will be done at the end of the course. 4) PROFICIENCY IN MICROSOFT EXCEL This unit will train the students on the concepts of spreadsheet management with special emphasis on Microsoft Excel. The unit will also

Related Essays

Finance 316 Case Essay

673 words - 3 pages front parts. Despite that, the discount rate is 0.077 which is quite important so the final discounted cash flow is being calculated with the formula ( =total cash flow* discount rate). The net present value is 225,428,896 dollars.      Next, the product connected from above is the excel product. From the excel tables, the revenue is 1 billion for each year and expenses is 750 million each year. The pretax profit is equals to revenue minus

Computers Essay

729 words - 3 pages IT206 DQ Questions DQ1 Write a 200- to 300-word short-answer response to the following: * What are some qualitative tools used to analyze data in Microsoft® Excel®? How do these tools assist users with their business decisions? Provide an example from a past or current work experience when the use of these tools would have helped to analyze data in your spreadsheet. How was the data originally analyzed? Explain your answer. You are not

Salary Regression Example Essay

413 words - 2 pages given. Verify the equation and your results by hand. To solve this problem we have to set up the problem in an MS Excel spreadsheet and use the chart Wizard to create the regression line. The solution provided by the Excel is the following. As you can realize the solution provided by the Excel is y= 7935.2 x – 2E +07 while the R2 = 0.9256. Many software, including Excel, truncate the final numbers when these are really long integer or

Bus401 Paper

589 words - 3 pages can figure the net working capital and then finally calculate the free cash flow. F. The terminal cash flow is $5,980,000. This is the final number of free cash flow at the end of the project. G. Please see my excel spreadsheet for the cash flow diagram for this project. H. The net present value for this project is $16,731,096. This was calculated in excel using the NPV formula and inputing a 15% required rate of return and using the 5