Go to:  Level 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Level 12: Practice

Challenge Exercise for Advanced Excel Open the sample Excel spreadsheet, Bug Report Pivot Table When prompted, SAVE to My Documents Go to My Documents and double click on Bug Report Pivot Table.xls to open the spreadsheet. in Microsoft Excel Create the following Pivot Table Graph Use the Department Field in the Columns Use the Application Field in the Rows Use the ComputerID for the Data Filter the Applications in the Pivot Table to Show Equalizer Try It! Test your equations. Do they work?   Challenge Exercise for Advanced Word Open the sample Word document, Bug Report When prompted, SAVE to My Documents Go to My Documents and double click on Bug Report.doc to open the document. in Microsoft Word Add Outlook Express to each of the drop down fields Try It! Test your form fields. Do they work? Remember, you need to unprotect the form before you can edit it.