{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

PracticeExcelExam2KEY

PracticeExcelExam2KEY - State ID MN UT Location ID UT MN MN...

Info icon This preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
State Tax Rate ID 5.50% MN 6.50% UT 6.25% Location Sale Amount Tax Rate Sales Tax Total Price ID $112.25 5.50% $6.17 $118.42 UT $235.25 6.25% $14.70 $249.95 MN $27.25 6.50% $1.77 $29.02 MN $59.58 6.50% $3.87 $63.45 UT $65.12 6.25% $4.07 $69.19 ID $75.21 5.50% $4.14 $79.35
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Item Amount Salesperson Shoes $30.00 Jane Pajamas $30.00 Bob Toy $15.00 Tim Toy $50.00 Tim Snack $1.00 Jane Battery $2.00 Bob Toy $50.00 Jane Shoes $25.00 Jane Shoes $30.00 Tim Bicycle $100.00 Bob Pajamas $20.00 Tim Shoes $30.00 Jane Toy $5.00 Tim Battery $3.00 Jane Toy $1.00 Bob Shoes $15.00 Tim Salesperson # Trans Total Sales Jane 6  $139.00  Bob 4  $133.00  Tim 6  $135.00 
Image of page 2
Feet to Intersection Action 100 Speed Up 150 Stop 140 Speed Up 200 Stop 90 Keep Driving 110 Speed Up
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Principle  $221,495.15  Interest 6.50% Term 360 Payment ($1,400.00) Set Cell D5 To Value  $(1,400.00) By Changing D1
Image of page 4
Candy Bars Twix Milky Way Snickers Nut Roll # Produced 700 900 700 200 Demand 700 900 1000 200 Price/Bar  $0.60   $0.60   $0.60   $0.60  Cost/Bar  $0.23   $0.17   $0.31   $0.25  Profit/Bar  $0.37   $0.43   $0.29   $0.35  Chocolate 1 1 1 0 Caramel 1 1 1 1 Peanuts 0 0 1 1 Chocolate Used 2300 2500 <----- Available Caramel Used 2500 2500 <----- Available Peanuts Used 900 2000 <----- Available Profit  $919.00 
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Date Location Sales Rep Sales Approach Customer ID 01-Sep-08 Salt Lake City Lynn Normal 17 01-Sep-08 Salt Lake City Lynn Normal 17 01-Sep-08 Provo Jeff Normal 3 01-Sep-08 Provo Jeff Normal 3 01-Sep-08 Provo Jeff Normal 3 01-Sep-08 Provo Matt Normal 1 01-Sep-08 Orem Jenny Normal 2 01-Sep-08 Orem Sean Normal 3 02-Sep-08 Salt Lake City Sarah Normal 4 02-Sep-08 Salt Lake City Lynn Normal 5 02-Sep-08 Salt Lake City Lynn Normal 5 02-Sep-08 Salt Lake City Ray Normal 12 02-Sep-08 Provo Jeff Normal 6 02-Sep-08 Provo Jeff Normal 6 02-Sep-08 Provo Jeff Normal 6 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Provo Matt Normal 7 02-Sep-08 Orem David Normal 8 02-Sep-08 Orem Jenny Normal 9 02-Sep-08 Orem Jenny Normal 9 02-Sep-08 Orem Sean Normal 10 03-Sep-08 Salt Lake City Sarah Normal 12 03-Sep-08 Salt Lake City Sarah Normal 12 03-Sep-08 Provo Phil Normal 12 03-Sep-08 Provo Phil Normal 12 03-Sep-08 Provo Phil Normal 12 03-Sep-08 Orem Jenny Normal 11 03-Sep-08 Orem Sean Normal 12 04-Sep-08 Salt Lake City Lynn Normal 17 04-Sep-08 Salt Lake City Lynn Normal 17 04-Sep-08 Salt Lake City Ray Normal 13 04-Sep-08 Provo Jeff Normal 14 04-Sep-08 Provo Jeff Normal 14 04-Sep-08 Provo Matt Normal 15 04-Sep-08 Provo Matt Normal 15 04-Sep-08 Provo Phil Normal 16 04-Sep-08 Orem David Normal 18 04-Sep-08 Orem Jenny Normal 18 04-Sep-08 Orem Sean Normal 3 05-Sep-08 Salt Lake City Sarah Normal 28 05-Sep-08 Salt Lake City Ray Normal 19 05-Sep-08 Provo Jeff Normal 20 05-Sep-08 Provo Phil Normal 21 05-Sep-08 Provo Phil Normal 21 05-Sep-08 Orem David Normal 22 05-Sep-08 Orem Sean Normal 23 06-Sep-08 Salt Lake City Sarah Normal 24
Image of page 6
06-Sep-08 Salt Lake City Sarah Normal 24 06-Sep-08 Provo Jeff Normal 2 06-Sep-08 Provo Matt Normal 28 06-Sep-08 Provo Matt Normal 28 06-Sep-08 Orem David Normal 13 06-Sep-08 Orem Jenny Normal 25 07-Sep-08 Salt Lake City Ray Normal 17 07-Sep-08 Provo Matt Normal 26 07-Sep-08 Orem Jenny Normal 27 08-Sep-08 Salt Lake City Lynn Normal 28 08-Sep-08 Provo Jeff Normal 12 08-Sep-08 Orem David Normal 12 09-Sep-08 Salt Lake City Sarah Normal 12 09-Sep-08 Salt Lake City Ray Normal 19 09-Sep-08 Provo Jeff Normal 1 09-Sep-08 Provo Phil
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '09
  • Salt Lake City, Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Ore, Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City Salt Lake City Provo Provo Provo Provo Provo Orem Orem Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake Cit, Provo Provo Orem Orem Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lak, Salt Lake City Salt Lake City Provo Provo Provo Provo Orem Orem Salt Lake City Salt Lake City Salt Lake City Salt Lake City Provo Provo Provo Provo Provo Provo Provo Orem Orem Orem Orem Salt Lake City Salt Lake City Provo Provo Provo Orem Orem Salt Lake C, Provo Provo Provo Orem Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Provo Orem Salt Lake City Salt Lake City Salt Lake City Salt Lake City Salt Lake City Provo Provo Provo Provo Provo Provo Provo Provo Provo Orem Orem Orem Orem

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern