Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Create a Summary Sheet 1. Make a copy of the “Eggs” spreadsheet. Double click the tab and rename it “Summary.” 2. Change the product from Eggs to All Products and AutoFill Cell B2. 3. Select column C and D, and delete them. We don’t need them. Go to Home ->Cells. Select Delete ->Delete Sheet Columns.   What do you see? The equations in the Revenue column now read: #REF!. The equation doesn’t have the data for Net and Quantity anymore. It has nothing to reference, hence the error message. Go ahead: select those cells and hit the delete key to clear the busted equation. Home ->Cells -> Delete ->Delete Sheet Columns