PROJECT STEPS Noah Pries is an assistant in the Alumni Office at Lakeside College. He is helping the director with reunion planning for the 5-, 10-, 15-, and 20-year celebrations and needs to analyze the current data for activity information and payment. To make his work easier, he decides to format the existing worksheet data into a table. Switch to the Lakeside Reunion worksheet, and then format the range A8:M38 as a table with headers using the Table Style Dark 11 table style. Instructor Explanation: An Excel Table is an area of data you can format to make managing and analyzing data easier. You start with a range of related cells and use Excel to turn a range into a Microsoft Excel table. Then you can manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet. Here’s How: Click the Lakeside Reunion tab to select the Lakeside Reunion worksheet Select from A8:M38 On the Insert Ribbon, Tables Group, click the Tables Button Check to be sure there is a check next to “My table has headers” Click OK Observe the new structure for the table data area On the Table Ribbon, Tables Styles Group, Select Table Style Dark 11 Noah’s boss has decided that the donor information isn’t necessary in the planning. Delete the Donor column from the table. (Hint: Step 4 must be completed correctly to receive credit on this step.) Here’s How: Select column M by hovering the mouse pointer over the M at the top of the column until you see the dark arrow, then click Right-click in the selected range Click Delete Noah needs to calculate the cost for each person attending the reunion. Recent graduates will receive a discounted price. In cell L9, create a formula using the IF function and structured references to determine the cost based on the following criteria: If the value in the Reunion Year column ([Reunion Year]) is less than or equal to 10, the cost is 210. If not, the cost is 255. If the formula in cell L9 does not automatically fill the table column, fill the remaining cells with the formula you just created. Instructor Explanation: Creating formulas in a table offers several automatic type features.
PROJECT STEPS Noah Pries is an assistant in the Alumni Office at Lakeside College. He is helping the director with reunion planning for the 5-, 10-, 15-, and 20-year celebrations and needs to analyze the current data for activity information and payment. To make his work easier, he decides to format the existing worksheet data into a table. Switch to the Lakeside Reunion worksheet, and then format the range A8:M38 as a table with headers using the Table Style Dark 11 table style. Instructor Explanation: An Excel Table is an area of data you can format to make managing and analyzing data easier. You start with a range of related cells and use Excel to turn a range into a Microsoft Excel table. Then you can manage the data in the table rows and columns independently from the data in other rows and columns on the worksheet. Here’s How: Click the Lakeside Reunion tab to select the Lakeside Reunion worksheet Select from A8:M38 On the Insert Ribbon, Tables Group, click the Tables Button Check to be sure there is a check next to “My table has headers” Click OK Observe the new structure for the table data area On the Table Ribbon, Tables Styles Group, Select Table Style Dark 11 Noah’s boss has decided that the donor information isn’t necessary in the planning. Delete the Donor column from the table. (Hint: Step 4 must be completed correctly to receive credit on this step.) Here’s How: Select column M by hovering the mouse pointer over the M at the top of the column until you see the dark arrow, then click Right-click in the selected range Click Delete Noah needs to calculate the cost for each person attending the reunion. Recent graduates will receive a discounted price. In cell L9, create a formula using the IF function and structured references to determine the cost based on the following criteria: If the value in the Reunion Year column ([Reunion Year]) is less than or equal to 10, the cost is 210. If not, the cost is 255. If the formula in cell L9 does not automatically fill the table column, fill the remaining cells with the formula you just created. Instructor Explanation: Creating formulas in a table offers several automatic type features.
excel-module-7-instructions_il_ex16_7a.docx