Question: I need to get this questions done using the excel in the picture A) show sales (totalcharge) by year and by store, (Hint: to get

I need to get this questions done using the excel in the picture

picture A) show sales (totalcharge) by year and by store, (Hint: to

get year, add another column and use the = YEAR() function to

get the year of the order's date. Now add items sold (items).

Analyze the results. Make a chart which shows items and sales by

A) show sales (totalcharge) by year and by store, (Hint: to get year, add another column and use the = YEAR() function to get the year of the order's date. Now add items sold (items). Analyze the results. Make a chart which shows items and sales by year and location. What inferences can you make from thilsata? B) Do separate analysis to show total sales for each year by store location and category. Make a chart and then Discuss the resuits what does your analysis indicate about sales trends for the company? C) Who were the top 3 sales people (total sold) in 2016? Who were the top 3 in 2017 ? A) show sales (totalcharge) by year and by store. (Hint: to get year, add another column and use the =YEAR0 function to get the year of the order's date. Now add items sold (items). Analyze the results. Make a chart which shows items and sales by year and location. What inferences can you make from this data? B) Do separate analysis to show total sales for each year by store location and category. Make a chart and then Discuss the results what does your analysis indicate about sales trends for the company? C) Who were the top 3 sales people (total sold) in 2016? Who were the top 3 in 2017 ? 11111111111111111111111111111111111111111111111111111111111111 111111111131111111111111111111111111111111111111111,1111111111111 [11111111111111111111111111111111111111111111111111111111111111

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need to get this questions done for excel, I'll leave pictures of the excel and assignment. A) show sales (totalcharge) by year and by store. (Hint: to get year, add another column and use the...

Downtown Office Supply Downtown Office supply is a small family owned store in a small suburb. In order to maintain and grow the business the owners want to do some analysis to see how their sales...

Excel step by step help 1-13 1. Selena Delgado creates and sells jewelry to stores and gift shops in Denver, Colorado, and nearby cities. She is using an Excel workbook to analyze sales from the...

After you have created the data table, name the sheet Table 1 Data , then create a copy of theAfter you have created the data table, name the sheet Table 1 Data , then create a copy of the sheet to...

Berkeley Elementary School is a small private school that has retained your services as a systems analyst to assist in the development of a new information system for the schools administrative...

I need help understanding the formulas. I have to complete the spreadsheet below by filling in the correct formulas into the cells that are green. An image of the Excel item is at the bottom. This...

Engines R Us purchases aluminum castings, which are formed metal parts, from suppliers and then machines these into parts that are sold to the major automotive companies (OEMS). Engine's OEM...

I need a sample outline for the Capstone Project the scenario is the one about the school: ITM4498 Capstone Project Berkeley Elementary Schoolis a small private school that has retained your services...

Solve with graph LJVJT . Using the data given at the end of this project, input the data into Excel. Add another column to your spreadsheet in which you redefine the independent variable so that x...

2009. Using the data given at the end of this project, input the data into Excel. Add another column to your spreadsheet in which you redefine the independent variable so that x represents \"years...

The flux density in the gap of a 1mA (full scale) moving '-coil' ammeter is 0.1 Wb/m^2. the rectangular moving coil is 8mm wide by 1cm deep and is wound with 50turns. calculate the full scale torque...

The total factory overhead for Diva-nation Inc. is budgeted for the year at $180,000. Diva-nation manufactures two types of men's pants: jeans and khakis. The jeans and khakis each require 0.10...

Which of the following are true statements? ( I ) Money market securities are relatively high risk. ( II ) Investors in money market securities use them to store excess funds for short periods of...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

2. Require employees to log in. Required use of company passwords and sign-on credentials limits access to this internal document to those who have a legitimate right to read it. The handbook is not...

7. Remind employees about the process periodically, such as once a year, so that they know it is operational and effective.

6. Notify employees of the change. Announce the change to an online handbook in a way that ensures all employees will know about the new format. Consider a mandatory sign-on within the transition...