# Exercises

This section includes a list of Excel 2016 exercises with answers. It is a complement to the Excel 2016 Course and the Excel 2016 Functions Course.

You can find more techniques, examples and exercises in our How to do in Excel pages.

Here is the list of proposed exercises:

- Exercise 1 – Formatting
- Exercise 2 – Formatting
- Exercise 1 - Calculation, Formulas and Series
- Exercise 2 - Calculation, Formulas and Series
- Exercise 3 - Calculation, Formulas and Series
- Exercise 4 - Calculation, Formulas and Series
- Exercise - Finding duplicates
- Exercise - Working with spreadsheets
- Exercise - Text Functions
- Exercise - Date functions
- Exercise 1 - Logical functions
- Exercise 2 - Logical functions
- Exercise - Comparison of two lists
- Exercise – COUNTIF, COUNTIFS, SUMIF and SUMIFS functions
- Exercise - COUNTBLANK Function
- Exercise - VLOOKUP and HLOOKUP functions
- Exercise - MATCH and INDEX Functions