Click on the link to download file practice file http://simpletek.ca/files/Pt 2: https://www.youtube.com/watch?v=SBnBO-BFrx0A quick recap of important Q&A for preparing to take an Excel 2007 computer test. Learn all the basics of saving, opening, password protect files. Highlight Cell, select range, select discontinuous cells, add border, create Custom List, Merge¢er, Wrap Text, Add $ signs. Use Sum, Average, CountIf, If, Concatenate, Vlookup functions. Also learn about Sort/Filter, Conditional Formatting, creating a Table. Learn to answer questions about Page Setup - Margins, Orientation, Page Break, Center on Page, Gridlines. Copy/Paste Formula and Values&Absolute Reference in Calculation. Split a text into 2 column. Insert Chart, Pivot Table or Pivot Chart. Freeze Top Row or multiple Rows.