# E CH04 GOV2 H3 Instructions

Good Essays
566 Words
Grammar
Plagiarism
Writing
Score
E CH04 GOV2 H3 Instructions
Warehouse Loan and Lookup Form

Project Description:
In this project, you will create a named range and use it to set data validation. You will use a PMT function to calculate a value and then use it in a two-variable data table. You will also enter VLOOKUP functions to return values from a table, and format cells in the workbook. You will also audit a worksheet and correct errors.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
0
2
Click the Warehouse Payment Table sheet. In cell B8, enter a PMT function using cell B4 divided by 12 as the rate, B3 as the number of payment periods, and B2 as the present value of the loan. Display the result as a positive number.
10
3
In the range B8:H16, create a two-variable data table. Set B3 as the row input cell, and B4 as the column input cell.
10
4
Apply the Currency number format to cells C9:H16. Apply the cell style Note to the payment in cell E9.
5
5
On the Job Information sheet, select the range A4:C11. Sort the range by the Job Code column in ascending order.
5
6
Create a range named Job_Code using the data in cells A5:A11 on the Job Information worksheet.
5
7
On the Staffing Plan worksheet, in cells A9:A18, set a Data Validation rule that allows values from a list to be entered in this cell. Set the source to =Job_Code. From the newly created Data Validation list in cell A9, select M-MG.
10
8
On the Staffing Plan worksheet, in cell B9, create a VLOOKUP function that will look up the Description from the Job Information sheet using the Job Code. Use absolute cell references as necessary.
10
9
Copy the function in B9 down through cell B18.
3
10
In cell C9, enter 1 as the # of Positions; in D9, enter Management as the Type.
4
11
On the Staffing Plan worksheet, in cell E9, create a VLOOKUP function that will look up the Salary from the Job Information sheet

## You May Also Find These Documents Helpful

• Satisfactory Essays

Hiredate DATE No No Job VARCHAR2(15) No No Mgrno number(4) no no yes ( to emp.empno) Salary number(8,2) no no Comm number(8,2) no no Deptno number(2) no no yes ( to…

• 1169 Words
• 5 Pages
Satisfactory Essays
• Satisfactory Essays

1. Update the employee table, add a salary column (Number type with 7 length) into the employee table. Use a number format with a 2 digit decimal from the right.…

• 438 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

2. List employees name, job, and salary that is a manager and has a salary > \$1,000…

• 2384 Words
• 33 Pages
Satisfactory Essays
• Satisfactory Essays

The company will need to combine current staffing levels with anticipated staffing gains and losses and compare to an estimate of the supply of labor for the target position at a certain point in the future. Anticipated gains and losses are based on historical data combined with managerial estimates of future changes. There are many techniques a company can use I am going to talk about Ratio Analysis.…

• 303 Words
• 2 Pages
Satisfactory Essays
• Good Essays

Data validation is a tool on excel which makes it possible to control the values input into a given cell. I used this tool to prevent negative numbers entering into the duration column of my COST worksheet. I think I used this tool effectively because if negative number is input, an error alert message appears informing the user of their mistake, therefore increasing the reliability of the data. This is shown in the image below.…

• 921 Words
• 4 Pages
Good Essays
• Good Essays

For the purpose of grading the project you are required to perform the following tasks:…

• 520 Words
• 3 Pages
Good Essays
• Better Essays

With the powerful data tools included within Microsoft Excel you have the ability to analyze large amounts of data that will influence decisions. Data Validation is a great way to limit what a user can enter into a worksheet cell. It may not stop a cell from being left empty, however. This tip explores why this is and how you can make sure that a cell contains a value. Microsoft Excel’s data consolidate capabilities allows you to summarize your data enhancing your ability to organize and structure your data. Remove Duplicates tool makes your data uniform by removing duplicate records.…

• 2002 Words
• 9 Pages
Better Essays
• Satisfactory Essays

7) Create a formula to calculate the total sales for all fruit items for the year to date…

• 681 Words
• 3 Pages
Satisfactory Essays
• Powerful Essays

The solution has to take care of the calculation of salary as per rules of the company, income tax calculation and various deductions to be done from the salary including statutory deductions like Income tax and provident fund deductions which the Payroll system will base on the attendance records.…

• 1441 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

Batch Header showing Job Code Input Type Code Job Description Week number Total Number of Records Total Number of Hours worked Total Amount Paid * Commission Rates Batch <50 Batch Header showing Job code Input Type Code Job Description Period Number Total Number of Records Total Sales Total Commission Pay 3. Validation of data at the data preparation stage * Clock cards Payroll number check digit…

• 513 Words
• 3 Pages
Satisfactory Essays
• Good Essays

For the purpose of grading the project you are required to perform the following tasks:…

• 831 Words
• 4 Pages
Good Essays
• Good Essays

a = acceleration v = final velocity u = initial velocity t =time for the velocity change…

• 2243 Words
• 9 Pages
Good Essays
• Satisfactory Essays

* Sort the trainers worksheet (s) in ascending order by gym members Last name (primary sort), and then by Total Sessions (secondary sort) formulae…

• 700 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

LAB 4 STUDENT NAME: Rajendhar Dayalan Student ID:12667690 Q1 Please write down the modified script for creating the add_jobs procedure into your report. CREATE OR REPLACE PROCEDURE ADD_JOBS (p_jobid IN jobs.job_id%TYPE, p_jobtitle IN jobs.job_title%TYPE, p_minsal IN jobs.min_salary%TYPE ) is v_maxsal jobs.max_salary%TYPE; BEGIN v_maxsal:= 2* p_minsal; Insert into jobs values(p_jobid,p_jobtitle,p_minsal,v_maxsal); DBMS_OUTPUT.PUT_LINE ('Added the following row into the JOBS table ...'); DBMS_OUTPUT.PUT_LINE (p_jobid || ' ' || p_jobtitle || ' '|| p_minsal || ' ' || v_maxsal); END ADD_JOBS; Q2 Please write down the modified script for creating the get_service_days function into your report. (2 pts) CREATE OR REPLACE FUNCTION GET_SERVICE_DAYS (p_empid IN employees.employee_id%TYPE)…

• 311 Words
• 2 Pages
Satisfactory Essays
• Good Essays

data collected were manually entered into MS Excel for tabulation and created nine tables, which…

• 9251 Words
• 38 Pages
Good Essays