Question: Formatting as Table Styles y Filter Select F.34 fx B C D E F G H L M N 0 3 4 Pivot Table: 5

Formatting as Table Styles y Filter Select F.34

Formatting as Table Styles y Filter Select F.34 fx B C D E F G H L M N 0 3 4 Pivot Table: 5 6 1. Create a Pivot Table to display average Customer Credit by Type of Credit and City. 7 Place pivot table on this sheet below this box. 8 2. Add the average Interest Rate (still by Type of Credit and City) to the display- 9 10 11 12 13 14 Dala 15 Type City Sum of Amount Sum of Interest Rate 16 - Inventory Albuquerque $350,000.00 12.00% 17 Santa Fe $1,800,000.00 41.75% 18 Taos $479,000.00 12.25% 19 Inventory Total $2,629,000.00 66.00% 20 Other Albuquerque $30.500.00 14.38% 21 Taos $35,000.00 6.00% 22 Other Total $65,500.00 20.38% 23 Promotion Albuquerque $290,000.00 $ 12.50% 24 Santa Fe $47.000.00 15.00% 25 Taos $290,000.00 28.70% 26 Promotion Tolal $827.000.0D 56.20% 27 - Shipping Albuquerque $91,000.00 20.50%. 28 Taos $41,000.00 7.50% 29 Shipping Total $132.000.0D 28.00% 30 Grand Total $3,453,500.00 170.58% 31 32 Credit First Name Last Name City 1022 Eileen Cooper Santa Fe 1023 Eileen Cooper Santa Fe 1024 Elloon Cooper Santa Fe 1025 Scott Hunter Tos 1026 Scott Hunter Taos 1027 Ellen Harper Albuquerque 1028 Ellen Harper Albuquerque 1029 Ellen Harper Albuquerque 1030 Ellen Harper Albuquerque 1031 Max Endermann Santa Fe 1032 Max Entermann Santa Fe 1033 Max Entermann Santa Fe 1034 Max Enfermann Santa Fe 1035 Helen Rayus Albuquerque 1036 Helen Rayus Albuquerque 1037 Ted Myerson Santa Fe 1038 Peter Sanger Albuquerque 1039 Peter Sanger Albuquerque 1040 RON Budnick Taos 1041 Rose Budnick Taos 1042 Rose Budnick Taos 1043 Austin Powers Albuquerque 1044 Barbara Ringer Taos 1045 Barbara Ringer Taos 1048 Barbara Ringer Taos Loan Date Amount interest Rate 2128/07 $ 200,000 7.00% 3/21/07 $ 150,000 7.50% 3/22/07 $ 100,000 7.00% 3/1/07 $ 25,000 8.50% 4/1/07 $ 10,000 7.70% 3/11/07 $ 200,000 6.25% 3/31/07 $ 15,000 8.50% 4/15,07 $ 25,000 7.75% 5/1/07 $ 150,000 5.75% 1/15/07 $ 475,000 5.75% 1/23/07 $ 35,000 6.75% 1/31/07 $ 12.000 8.25% 5/3/07 $ 350,000 8.00% 1/25/07 $ 10,000 5.50% 3/1,071 20,000 7.50% 210,07 $ 525,000 8.50% 2/12/07 $ 10,500 6.88% 5/8/07 $ 275,000 6.00% 2/20/07 $ 250,000 5.75% 221,07 $ 5.000 8.75% 4/18,07 $ 41,000 7.50% 3/3/07 $ $ 56,000 7.25% 2/15/07 $ 35,000 6.00% 3/10/07 $ 129,000 5.75% 4122/07 $ 350,000 6.50% Days Type 90 Inventory 90 Inventory 90 Inventory BO Promotion 60 Promotion 90 Inventory 90 Promotion 90 Shipping 120 Inventory 120 Inventory 60 Promotion 60 Promotion 90 Inventory 60 Shipping 60 Other 120 Inventory 120 Other 30 Promotion 30 Promotion 30 Promotion 60 Shipping 60 Shipping 120 Other 90 Inventory 90 Inventory

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 General Management Questions!

- -3 A LD[B v boleto AutoSave OFF SYUODEO ABC A Process Selection Crossover Home Insert Draw Page Layout Formulas Data Review View Tell me what you want to do Calibri (Body) 11 A A E = OU a Wrap...

16 Download the Applying Excel form and enter formulas in all cells that contain question marks. rt 1 of 2 For example, in cell B26 enter the formula "=B5". Check your worksheet by changing the...

Please show excel formulas and answers. Home Insert Draw Page Layout Formulas Data Review View X Cut Calibri (Body) 11 A- A = = Wrap Text General Ly Copy Paste B I U. Merge & Center $ % .00 .00...

X 5 Calculating annuity present values - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri 11 A % M Paste BLU- Alignment Number Cells Editing Conditional Format as Cell...

PLEASE FILL OUT THE GREEN PART OF THE EXCEL BELOW WHILE SHOWING FORMULAS AND ANSWER QUESTION 4 ABOVE. THANK YOU! Formatting as Table Styles F30 fx \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline &...

Exercise: Electronics Inc. buys and sells photocopy equipment that are used in businesses across Ontario. The company follow IFRS. Unit selling prices range from $10,000 to $100,000. Electronic Inc....

The Cleveland Stapler Manufacturing Company forecasts a 5,000-unit demand for its SH model during the next quarter. This stapler is assembled from three major components: base, staple cartridge, and...

AutoSave OFF + 5 = Home Insert Draw Page Layout Paste 115 A BIU MAA363 T3 2020 Tax Assignment Excel proforma-2 Formulas Data Review View Tell me ' ab Wrap Text Insert 28 Delete v Merge & Center %9...

Hello, I need urgent help with this assignment. Thank you. AutoSave O OFF A A . G ... Test 2 802 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 AA =...

The Hamiltonian Ho for a 3-state quantum system is given by the matrix. Ho = [ 1 0 0 , 0 2 0, 0 0 2 ] & Hp= Sigma [0 1 0, 1 0 1, 0 1 0] sigma

Define "battered woman syndrome" and briefly state the controversy associated with it.

Cash audit program procedure Assertion ( s ) Was sufficient and appropriate audit evidence obtained? Was there any issue with audit evidence or workpaper preparation? What additional audit test work,...

https://phet.colorado.edu/sims/html/projectile-motion/latest/projectile-motion_en.html Testable Question: How does changing the vertical displacement of a projectile affect its range and time of...