Free Educational Resources

• > Excel Project Ch 12 Grader Project Exam
+

Excel Project Ch 12 Grader Project Exam

Rating:
(0)
Author: matthew stock
Description:

Project Description:
You’ve been asked to automate a time sheet, and to automatically record a log of the weekly payments using Excel 2013. You have made great progress on the Time Card, and now need to add data validation, VLOOKUPs to automate Employee data entry, an IF function to calculate the daily payments, and a macro to copy the time card data to a payment log.

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

Instructions

Points Possible

1

Open the TIA_Ch10_Start.xlsx file, and save asTIA_Ch10_LastFirst. Display the DEVELOPER tab, if necessary.

0.000

2

On the Time Card worksheet, in cell B3 type Ted Hoyt. In cell B4, use the VLOOKUP function to lookup up the value of cell B3 in the range A2:C16 on the Employee Data worksheet, and return the value in the third column of that range. UseFALSE as the Range_Lookup argument.

10.000

3

In cell B5, create a VLOOKUP function to look up the value of cell B3 in the range A2:C16 on the Employee Data worksheet, and return the value from the second column. UseFALSE as the Range_Lookup argument.

10.000

4

On the Time Card worksheet, click cell C9, enter 4/11/2016, and then use the Fill Handle to complete the series of dates in cells C10:C13.

6.000

5

Select range D9:D13. On the DATA tab, select Data Validation. In the Data Validation dialog box, on the Settings tab, click the Allow arrow and select Decimal. Click the Data arrow, and select between; then enter 0 in the Minimum box and 12 in the Maximum box. Add a Stop Error Alert, with the title: Invalid Entry, and an Error message: Total hours worked cannot exceed 12 hours.

12.000

(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.*

No credit card required

26 Sophia partners guarantee credit transfer.

226 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 21 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