• Nested IF statement
• Create IFERROR function
• Either a RIGHT, LEFT or MID function (choose one)
• MATCH and INDEX function on the data to choose one record
• Create either a VLOOKUP or CHOOSE function from a named range table.
• Create COUNTIF or COUNTIFS

2. Add a minimum of 20 records to the table.
3. Improve the appearance of the table by using appropriate formatting.
4. Apply conditional formatting to at least one column in the table to visually highlight some aspect of the data that will help you evaluate and solve the problem.
5. Add a comment to the column with the conditional formatting to explain what the conditional formatting shows, and how it will help you to evaluate and solve the problem.
6. Insert a Total row in the table, and then make appropriate summary calculations that you can use to evaluate and solve the problem.
7. Sort the data in a logical way.
8. Create a PivotTable and a PivotChart to analyze the data. Format, filter, and sort the PivotTable appropriately.
9. Create at least one macro with a button to automate a repetitive task you need to perform in the workbook, such as printing or saving a worksheet as a PDF file.
10. Prepare your workbook for printing. Include headers and footers that indicate the filename of your workbook, the workbooks author, and the date on which the report is printed. If a printed worksheet will extend across several pages, repeat appropriate print titles across all of the pages, and include page numbers and the total number of pages on each printed page.

ADD FORMULA