3.5 Chapter Practice
Alt & VE Log
Download Data File: PR3 Data
- Open the file name PR3 Data, then Save As PR3 Alt & VE Log.
- Select cell A1 and enter your First and Last name after “Project Name”.
- Change cell A3 to read, “Date of Issue for Baseline Estimate:”. Then put 1/25/2020.
- Enter the current date in cell A4 after, “Date of Issue:”.
- For cells D7, D9, D11, D13, and D15, enter 1/5/2020.
- For cells D8, D10, D12, D14, and D16, enter 1/12/2020.
- Center data for D7:D16.
- In Column C, click on the arrow to the right of the cell to Approved the following Item #’s: 001, 004, 009, and 010.
- In Column C, Rejected the following Item #’s: 002, 005, and 008 using the arrow to select Reject.
- In Column C, select Item # 003 as Pending.
- In Column C, select Item #’s 006 and 007 as Add Alt.
- Enter an IF FUNCTION for Cell H7. IF C7 = Approved, then the quantity from G7 will appear in H7; otherwise use “” to leave the cell blank. Use copy/fill and select “fill without formatting” for cells H8:H16.
- Use the same method from #12 but and create an IF function “Pending” and “Add Alt” for columns I and J, respectfully.
- Bold cells H7:J16. Also, bold cells H17:J17, H19, H21, H25, H26, and H29.
- Merge & Center cells A1:B1. Do the same for A2:B2, A3:B3, and A4:B4.
- Change the recent Merged & Centered cells to Light Orange, 40% – Accent2. Bold these same cells.
- Select the range C7:C16 and click on Conditional Formatting to create Highlight Cell Rule for Text that Contains “Approved“. Use “Green Fill with Dark Green Text“
- Save the file and confirm that all content fits on a single page.
- Go to File, then Print, change the orientation to Landscape, change the scaling to Fit Sheet on One Page
- Save your file; close Excel.
- Submit file as directed by instructor.