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, 23.06.2019 20:10

Leo is a recruitment executive for a large company. he has identified new labor resource requirements in both the marketing and production departments. what should be his first step in recruiting candidates for the positions? a. conduct background checks of candidates b. make job offers c. arrange interviews d. conduct reference checks e. place job ads on job sites

Answers: 1

Answer

Computers and Technology, 24.06.2019 00:00

For the following example of making a peanut butter and jelly sandwich, identify which are inputs, processes, or outputs: bread scooping and spreading peanut butter plate scooping and spreading jelly finished sandwich putting two pieces of covered bread together dirty plate crumbs

Answers: 2

Answer

Computers and Technology, 24.06.2019 02:50

Be sure to answer all parts. synthesize the following compound from benzene. a. b. c. d. e. f. reaction [1] conditions: a b c d e f reaction [1] product: draw structure reaction [2] conditions: a b c d e f reaction [2] product: draw structure reaction [3] conditions: a b c d e f reaction [3] product:

Answers: 3

Answer

Computers and Technology, 24.06.2019 16:00

5.a fishing rod is formed from a composite material of 0.5 kg of glass fibers embedded in a matrix of 0.5 kg of epoxy resin. the glass fibers are assumed to be long, continuous and unidirectional. to achieve a greater stiffness it is proposed to use a different composite that is comprised of long continuous carbon fibers that will be embedded in a matrix of 0.5 kg of epoxy resin. if the modulus of elasticity of the carbon fiber composite is 10% greater than the elastic modulus of the glass fiber composite, estimate the mass of carbon fibers that will be used to make the carbon fiber composite. assume the applied tensile stress is parallel to the direction of the long axis of the fibers. the epoxy resin, glass fiber, and carbon fiber have an elastic modulus of 5, 86, and 350 gpa respectively and a density of 1100, 2500, and 1800 respectively.

Answers: 3

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