Exercises

Logo Excel 2016

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:
  1. Exercise 1 – Formatting
  2. Exercise 2 – Formatting
  3. Exercise 1 - Calculation, Formulas and Series
  4. Exercise 2 - Calculation, Formulas and Series
  5. Exercise 3 - Calculation, Formulas and Series
  6. Exercise 4 - Calculation, Formulas and Series
  7. Exercise - Finding duplicates
  8. Exercise - Working with spreadsheets
  9. Exercise - Text Functions
  10. Exercise - Date functions
  11. Exercise 1 - Logical functions
  12. Exercise 2 - Logical functions
  13. Exercise - Comparison of two lists
  14. Exercise – COUNTIF, COUNTIFS, SUMIF and SUMIFS functions
  15. Exercise - COUNTBLANK Function
  16. Exercise - VLOOKUP and HLOOKUP functions
  17. Exercise - MATCH and INDEX Functions

1. Exercise 1 – Formatting >>