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

Level 13: Practice Spreadsheet

Challenge Exercise for Advanced Excel Open the sample Excel document, Sales When prompted, SAVE to My Documents Go to My Documents and double click on Sales.xls to open the document in Microsoft Excel Create the following Subtotal: For each sales rep Add up the sum of their total sales Summary sheet: Insert a new worksheet and rename it Total Sales Add each sales reps name in column A In column B, create a link to each rep's total sales Calculate the average sale In column C, create a IF statement to indicate if the sales are above or below the average   Challenge: Create lookup table and use VLookup to set up different sales commissions of 5%, 10%,, 15% and 20%