Excel Ch 1.A – Grader Project - Training Workshops Step Instructions Points 1 Start Excel. Download and Open the file named e01_grader_a1.xlsx . SAVE AS Lastname.Firstname-ExcelCh1-TrainingWorkshops.xlsx (Remember to SAVE AS to your S:\ drive) 0 2 Copy the range A5:G5 and Paste the data below the Big Data Analytics row. For the Pasted data, change the Start Date to 6/25/2018 and the End Date to 6/29/2018 . Change the # of Corporate Attendees to 10 and the # of Education Attendees to 10 . 7 3 Merge and Center the cells F3 and G3. Merge and Center the range H3:J3 Hint: select H3,I3,J3 5 4 Apply Bold and Green Font Color to the range F3:J3 Hint: select: F3,G3,H3,I3,J3 5 5 For the range A4:J4, apply the Good Cell Style, Wrap Text, and Center Horizontally. 6 6 Insert a Column to the Right of the End Date Column. Type # of Days in cell D4.
You've reached the end of your free preview.
Want to read all 3 pages?
- Spring '08
- #, 90%