Reference no: EM13556524
(TCO 1) You are the Payroll Manager for your employer. Your payroll clerk has submitted the worksheet displayed here. All employees earn their regular pay rate times the hours worked plus an overtime bonus of 50% of the hours worked in excess of 40 hours.
Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification.
Part 2: You must also calculate the Income Tax which is assessed at an accelerated rate as shown in the Tax Rate Table. Write a formula as if it were in Cell F2 that calculates the income tax for the first employee. Write the formula so that it may be copied to the other employees without modification.
Part 3: Hourly employees must pay union dues of $0.25 per hour on hours worked in excess of 25 hours up to and including 40 hours plus $0.35 per hour on all hours worked in excess of 40 hours. Write a formula as if it were in Cell G2 that calculates the union dues (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification.
Part 4: Salaried and Exempt employees (Pay Codes E and S) are covered by the company's health insurance. The deduction is $10.00 per week. Write a formula as if it were in Cell H2 that calculates the Insurance deduction (if any) for the first employee. Write the formula so that it may be copied to the other employees without modification.
Question 2. 2. (TCO 3) You are a Microsoft Office trainer for DeVry University. The training topic for the current month is charts using Microsoft Excel. During each training session from different departments or cohorts, the following frequently asked questions were asked and you decide to create a document formalizing answers and suggestions.
My supervisor, Sally, likes my charts; however, she instructs me to take more time planning my charts before creating the actual chart itself. Why is planning the creation and development of a chart so important?
My supervisor, John, ask me to chart some comparative data but my first attempt with a column chart did not illustrate the data as well as he would have liked. What type of chart is ideal and best to illustrate comparative data of individual items in a data series and why?
My supervisor, Jessica, asked me to project future data trends using a chart. Most of the data is associated with sales and depending on the nature of what is sold, data either fluctuates or increases quickly. What chart feature added to a column chart can help project these data trends and why?
My supervisor, Thomas, asked me to add some creativity with color and enhancements on all charts used during weekly meetings. What should I consider to avoid being overly creative and why is this important?
Question 3. 3. (TCO 3) You are an analyst for the Vanguard Mortgage Company has been using a spreadsheet created by you in the past which functions well. The current worksheet you created currently contains the customer's account, the cost of the house, down payment, amount financed, mortgage rate, loan years (e.g. 30 year), % financed, date financed and payoff year. You have been tasked with enhancing the worksheet to include noted basic summary statistics. Which sorts of summary statistical methods would you include in the updated workbook? Describe at least six statistical measures that you would use so that you could explain them to your supervisor.
Question 4. 4. (TCO 5) Michael is a Professor of Biology at DeVry University and has collected "30" largemouth bass from "4" separate lakes to get weight distributions, measure of girth, and length. He currently has the data saved in a Microsoft Excel workbook with data from each lake on a separate worksheet. Given the Professor's needs, summarize how he can consolidate this data to output average, minimum, and maximum weight, measure of girth, and length of largemouth bass across all "4" lakes also including visual output and trends.
Question 5. 5. (TCO 9) You have been tasked with analyzing an extremely large amount of data and to ultimately produce a report to share with the Board of Directors. The data is currently in a text file and has over two thousand records of data. Explain how you would use Excel to analyze this data and organize it to prepare a written report. Be very specific on the variety of tools you would use and the steps you would go through to analyze the data and to ultimately prepare a detailed report with recommendations.
Note: This is a one part question.
How long should the rod be
: The pendulum on a small grandfather 's clock is used to regulate how fast the clock ticks. How long should the rod be so that the pendulum has a period of 2.00 second
|
Evaluate what is the tension in the cord
: A 3.1 micro Coulomb charge hangs from a string midway between two sheets and makes an angle of 10 degrees with the vertical, what is the tension in the cord
|
What is her average velocity for the trip
: A bicyclist makes a trip that consists of three parts, each inthe same direction (due north) along a straight road. During thefirst part, she rides for 22 minutes at an average speed of6.50 m/s. During the second part, she rides for 36 minutes ata..
|
Find the horizontal force on the dam just due to the water
: a vertical concrete dam is built in the ravine between two hills. The face of the dam slopes equally on both sides at an angle of 45.0o to the horizontal. Find the horizontal force on the dam just due to the water
|
Cell e2 that will calculate gross pay.
: Part 1: Write a formula as if it were in Cell E2 that will calculate gross pay. Write the formula so that it may be copied to the other employees without modification.
|
Calculate the frequency of the simple harmonic motion
: A mass, hanging at rest froma spring, stretches the spring by 4.00 cm. The mass is thenpulled down until the spring is stretched by 10.0 cm and released andmoves in Simple Harmonic Motion.
|
Acceleration drops to zero for the rest of the race
: A sprinter explodes out of the starting block with an acceleration of+2.14 m/s2 , which she sustains for 1.26 s.Then her acceleration drops to zero for the rest of the race. What is her velocity at t = 1.26 s and at the end of the race?
|
Determine what is the total distance side to side
: he New England Merchants Bank Building in Boston is 152m high. On windy days it sways with a frequency of 0.20Hz, What is the total distance, side to side, that the top of the building moves during such an oscillation
|
What was the overall initial velocity of the baseball
: A baseball is hit at an angle of 27.5 degrees and just clears the right field fence 87 meters away. What was the overall initial velocity of the baseball
|