Reference no: EM133093623
1 Start Excel. Open Exp19_Excel_AppCapstone_Comp.xlsx. Grader has automatically added your last name to the beginning of the filename.
2 Fill the range A1:E1 from the Employee_Info worksheet across all worksheets, maintaining the formatting.
3 Make the New_Construction worksheet active and create Range Names based on the data in the range A6:B9.
4 Ungroup the worksheets and ensure the Employee_Info worksheet is active. Click cell G6 and enter a nested logical function that calculates employee 401K eligibility. If the employee is full time (FT) and was hired before the 401k cutoff date 1/1/19, then he or she is eligible and Y should be displayed, non-eligible employees should be indicated with a N. Be sure to utilize the date located in cell H3 as a reference in the formula. Use the fill handle to copy the function down completing the range G6:G25.
5 Apply conditional formatting to the range G6:G25 that highlights eligible employees with Green Fill with Dark Green text. Eligible employees are denoted with a Y in column G.
6 Create a Data Validation list in cell J7 based on the employee IDs located in the range A6:A25. Add the Input Message Select Employee ID and use the Stop Style Error Alert.
7 Enter a nested INDEX and MATCH function in cell K7 that examines the range B6:H25 and returns the corresponding employee information based on the match values in cell J7 and cell K6. Note K6 contains a validation list that can be used to select various lookup categories. Use the Data Validation list in cell J7 to select Employee_ID 31461 and select Salary in cell K6 to test the function.
8 Enter a conditional statistical function in cell K14 that calculates the total number of PT employees. Use the range E6:E25 to complete the function.
9 Enter a conditional statistical function in cell K15 that calculates the total value of PT employee salaries. Use the range E6:E25 to complete the function.
10 Enter a conditional statistical function in cell K16 that calculates the average value of PT employee salaries. Use the range E6:E25 to complete the function.
|
At what discount rate is the npv equal to zero
: It has an installed cost (at time period zero) of $412,670. At what discount rate is the NPV equal to zero
|
|
Economies of scope imply that cost complementarities exist
: Economies of scope imply that cost complementarities exist, but cost complementarities do not imply the existence of economies of scope. Do you agree? Explain i
|
|
Differentiate windows, linux, unix, mac, and mobile operatin
: A table that compares the following operating systems: Windows, IOS, Android, OS X, Linux, and Unix. A table that has six criteria to compare operating systems.
|
|
Overview of compensation and benefits
: Heading 1) Compare and contrast compensation and benefits strategy of the "people department" of Southwest Airlines to overall strategies of two other airlines
|
|
Conditional formatting to the range
: 1 Start Excel. Open Exp19_Excel_AppCapstone_Comp.xlsx. Grader has automatically added your last name to the beginning of the filename.
|
|
Cloud-based service for software control
: You are the team leader for a software development project. What are some of the advantages of using a cloud-based service for software control
|
|
Types of reward systems
: As you reflect on what happened with Marina and Ervin in the video and apply what you know about situational leadership, did Andy and Naomi effectively handle t
|
|
Potential negative outcomes
: What are the risks (potential negative outcomes) to employees, executives, or organizational cultures when data are collected covertly? Are there benefits to co
|
|
Osteoarthritis-describe the pathophysiology
: Osteoarthritis (OA) is a common, age-related disorder of synovial joints. Describe the pathophysiology and provide the treatment options.
|