6: Creating Charts, Diagrams, and Templates A NA Project Files For Project 6K, you will need the following file: 406K_Time_Card You will save your workbook as: Lastname_Firstname_6K_Time_Template Open the file c06K_Time_Card and save it as a template in your chapter folder with the name Lastname_Firstname_6K_Time_Template Insert a formula to calculate daily pay (Regular Hours x Rate Per Hour using an absolute cell reference), a formula to total the hours for the week, and a formula to calculate the total pay. Apply appropriate number and financial formatting. Reposition the WordArt above the Time Card chart. Unlock the cells in which an individual would enter variable data, and then protect the sheet with the password goseries Insert the file name in the footer, add appropriate information to the document properties including the tags timecard, payroll and submit as directed by your instructor. Place WordArt Object and Apply Appropriate formulas, cell formatting, and Appropriate formulas, cell formatting, and WordArt placement are partially applied. Appropriate formulas, cell formatting, and WordArt Financial WordArt Formatting placement are applied placement are not applied Lock Formula cells Only one of the Formula cells are unlocked and Formulas are locked and formula cells or variable data variable data Performance Criteria cells are cells are locked unlocked variable data cells has the locked or unlocked feature applied appropriately Protect The worksheet is The worksheet is protected Worksheet not protected The worksheet is protected but not with the password goseries. with the with a password password goseries. D G M 2 3 4 Dallas Ft. Worth JOB FAIR 2900 33rd Avenue Dallas, TX 75204 214.555.0177 5 6 7 8 9 Employees Position Date regular Yotal 10 11 12 13 14 Day 15 Monday 16 Tuesday 17 Wednesday 18 Thursday 19 Friday 20 Saturday 21 Sunday 22 Total Hours 23 Rate Per Hour 24 Total Pay 25 26 Payroll Time Card help me step me to do execl project