Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I

PLEASE I NEED HELP WITH MY EXCEL ASSIGNMENT . IF YOU CAN INCLUDE ALL THE FORMULAS YOU USED TO KEY IN THE EXCELL SHEET I WILL REALLY APPRECIATE. THANKS

image text in transcribed
W N Last Name First Name Gender Title Salary Location Performance Bonus Aikman Gary F Account Rep 41,800 Detroit Good Bonus is based on Gender and/or Fishe Bryan F Excellent performance. Senior Account Rep 51,300 Atlanta 1. If the employee is Female (F), and the Felser Cynthia F Account Rep 40,900 Boston Average performance is Excellent the bonus is 5% of Parsley Gwen M Manager 74,200 Atlanta Excellent Salary. 8 Leslie Jean F Account Rep 48,500 Cleveland Excellent 2. If the performance is Excellent (and 9 Imber Cynthia M Senior Account Rep 48,500 Cleveland Good obviously not female) the bonus is 3%. 10 Granger Kevin M Trainee 20,500 Detroit Good 3. If the performance is Good, 1% bonus, 11 Dunes Annette F Senior Account Rep 42,600 Cleveland Good anything else is 0. 12 Cusak Barbara F Account Rep 32,800 Cleveland Average 13 Noble Linda M Account Rep 46,900 Boston Good You are required to use a logic statement to calculate the bonus. 14 Heatley Megan Senior Account Rep 51,900 Cleveland Good 15 Bobbitt Oronzo Account Rep 40,700 Cleveland Good 16 Lobree Cindy F Account Rep 25,800 Cleveland Average 17 Sampieri Maylou M Account Rep 38,400 Cleveland Average

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

Financial Accounting

Authors: Robert Libby, Patricia Libby, Frank Hodge

10th edition

1259964949, 1259964947, 978-1259964947

More Books

Students also viewed these Accounting questions