Computers and Technology, 23.09.2020 14:01 samiam61

Using the excel spreadsheet provided to you, create a series of Pivot Tables (or Pivot Charts) to answer the following questions. 1. What are the averages for purchases in each region?
2. What form of payment is most common?
3. Do our customers shop at work (most likely between 8:00 and 17:00) or at home? Include a printout of the pivot tables you used to answer each question.
You can type your answer and insert pivot tables right after each question, but highlighted it with different fonts or format.
Note: To answer number 3, I created a new column in the spreadsheet labeled ""Hour of Day"" and set it to just the hour instead of hour and minutes. In other words =hour(G8). The students who are excel power users should use an ""if"" formula to create a value of either day (time between 8:00 and 17:00) or night (not between 8:00 and 17:00).

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 02:00

Alocal reaction will occur at the site of the exposure such as irritation or damage to the skin eye or local reaction will occur at the site of the exposure such as irritation or damage to the skin ireland lounges

Answers: 3

Answer

Computers and Technology, 22.06.2019 17:00

Annie is creating a corporate report for a company’s annual meeting. in the report, she wants to add the signature of various department heads. which device can annie use to capture signatures to include in the report? a. printer b. monitor c. e-reader d. digitizing tablet

Answers: 1

Answer

Computers and Technology, 23.06.2019 04:31

Which of the following is not a way in which trees benefit the environment? a. they remove a significant amount of carbon dioxide from the atmosphere. b. they remove a significant amount of oxygen from the atmosphere. c. their roots hold soil in place, reducing rates of erosion. d. they remove ozone and particulates from the atmosphere. select the best answer from the choices provided a b c d

Answers: 1

Answer

Computers and Technology, 23.06.2019 19:30

2. fluorine and chlorine molecules are blamed fora trapping the sun's energyob forming acid rainoc producing smogod destroying ozone molecules

Answers: 2

Answer

You know the right answer?

Using the excel spreadsheet provided to you, create a series of Pivot Tables (or Pivot Charts) to an...

Questions