Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this excel problem f M AutoSum Calibri 11 A A ab Wrap Text General H Insert Delete Format Fill Paste BIU

I need help with this excel problemimage text in transcribedimage text in transcribed

f M AutoSum Calibri 11 A A ab Wrap Text General H Insert Delete Format Fill Paste BIU Uv .00 A $ % Merge & Center 60 .00 Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Cells Editing A1 fic Reason2Go H I J K L M N 0 P Q R A B C D E F G 1 Reason2Go Week 35 2 Project Leader Division 3 4 Name Hours O/T Hrs pay Hrly Rate Reg payo/T Pay Gross Pay 5 Brucker, Pieter 40 4 16.75 6 Cucci, Lucia 35 12 7 Klimt, Gustave , 40 2 13.25 8 Lafontaine, Jeanne 29 15.25 9 Martinez, Juan 37 13.2 10 Mioshi, Keiko 39 21 11 Shernwood, Burt 40 0 16.75 12 Strano, Riccardo 40 8 16.25 13 Wadsworth, Alice 40 5 13.25 14 Yamamoto, Johji 38 0 15.5 15 16 17 18 19 20 21 Sheet1 + - 00 O OOONOA A M Summary of Excel Module 1 1. Change file name to EX 1-Project Leader Payroll Calculator 2. Put a formula in cell E5 to calculate pay (pay = number of hours * hourly rate). Copy it all the way down column E through E14. 3. Put a formula in cell F5 to calculate overtime pay (O/T pay = number of O/T hours * (2*hourly rate)). Copy it all the way down column F through F14. 4. Add the word "Total" in A15 5. Use AutoSum in B15 6. Change cell C13 from 5 to 6, and see the change in cell F13 7. Add the phrase "Average Gross Pay" in C18 8. Copy the formula in cell B15 all the way through cell G15 9. Change "Pieter" to "Peter" in cell A5 10. Change cell B6 from 35 to 38, and see the change in cell E6 11. Change "Juan" to "Javier" in cell A9 12. Change cell C12 from 8 to 4, and see the change in cell F12 13. Put a formula in cell G5 to calculate gross pay (gross pay = regular pay + O/T pay). Copy it all the way down to row 14 (even though the book doesn't ask you to). 14. Put a formula in cell F5 to change the O/T pay (the current O/T pay is O/T hours * (2*hourly rate), the new O/T pay is O/T hours * (2.5*hourly rate)).Copy it all the way down to row 14 (even though the book doesn't ask you to). 15. Add headers a. Left header text box, type "Reason2Go b. Center header text box, type "Project Leader Payroll Calculator" C. Right header text box, type "Week 35" 16. Delete the content in the range A1:G2 by selecting the range and pressing "delete" button (don't delete the entire rows)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Changing Face Of American BankingDeregulation, Reregulation, And The Global Financial System

Authors: Ranajoy Ray Chaudhuri

3rd Edition

1137365811, 9781137365811

More Books

Students also viewed these Accounting questions

Question

Review the determinants of direct financial compensation.

Answered: 1 week ago