+
GO! - Excel Chapter 4: Homework Project 3 Warehouse Loan and Lookup Form

GO! - Excel Chapter 4: Homework Project 3 Warehouse Loan and Lookup Form

Rating:
Rating
(0)
Author: matthew stock
Description:

http://homework.plus/go-excel-chapter-4-homework-project-3-warehouse-loan-and-lookup-form/

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

Start Excel. Download and open the workbook namedGO_e04_Grader_h3.xlsx.

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.

3

5

Apply the cell style Note to the payment in cell E9.

2

6

On the Job Information sheet, select the range A4:C11. Sort the range by the Job Code column in ascending order.

5

7

Create a range named Job_Code using the data in cells A5:A11 on the Job Information worksheet.

5

8

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

9

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


(more)
See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

25 Sophia partners guarantee credit transfer.

221 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 20 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.

Tutorial