Lisa Kalley-Chapter 2 ACCT106 123 Practical Pbm Template(1)

Lisa Kalley-Chapter 2 ACCT106 123 Practical Pbm Template(1)...

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

Do this sheet prior to starting the practical problems. First review the example starting on line 2; click on each cell. Watch these two short YouTube presentations: 2.1250 6.3250 times 3.6250 times 4.3690 = 7.7000 = 27.6300 35.3300 to add the 7.70 and 27.63 just add; no need to fx round see the answer in cell B7 Explanation of Excel Rounding 9.45 Regular Rate 1.50 OT 14.18 Excel is set to display 2 digits but the answer is actually 14.175 the 14.175 would be used in subsequent calculations and would give a different pay than using the 14.18 9.4500 1.5000 14.1750 Same calculation as above with the display set to 3 9.4500 1.5000 14.1800 Same calculation as above with the display set to 3 and using the Excel fx found function Your turn 9.4500 1.5000 14.1800 follow the directions starting on line 36 below fx round is an easy function and just inputs the normal formula in the first fx round box. This is easy. Let's use the 9.45 times the 1.5 above in cells A27 and A28 with the answer in A29 Step 1 Step 2 or probably above the B or C column indicators The Insert Function Box will be displayed Step 3 Step 4 If the box is over the 9.45 in cell A27; click anywhere on the Box, left mouse click to move the box from on top of 9.45 Step 5 Click in the Number box Step 6 A27 will display in the Number box Step 7 Step 8 Step 9 (to round to 2 digits) Step 10 ok Common reasons fx round may not work: you input = to start your formula: DO NOT input =, Excel knows you are doing a calculation due to the function box Excel automatically inputs the = when you display the final rounding formula you hit ENTER while doing the rounding calculation; you can not hit ENTER while in the Function Arguments Box If you mess it up; ESC and start over where you want the answer by clicking fx and selecting round. Do the following calculations using fx round to 2 decimals in the yellow boxes 8.8500 1.5000 13.2800 Multiply 8.85 by 1.5 The formula displayed in A65 will be =ROUND(A63*A64,2) 8.2500 1.5000 12.3800 Multiply 8.25 by 1.5 642.6000 47.0000 30202.2000 Divide 642.60 by 47 You use / to divide 34500.0000 52.0000 Divide 34500 by 52 1794000.0000 16.5900 1.5000 24.8900 Multiply 16.59 by 1.50 1824252.7500 727.6800 Hash Total Check rounded multiplication answer rounded multiplication answer
Image of page 1

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

Image of page 2
This is the end of the preview. Sign up to access the rest of the document.
  • Spring '14
  • Salary, Double click

{[ 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