Excel Exam 2 – Intermediate level
This is an Excel exam, in which you can practice multiple Excel functions, such as: COUNTIF SUMIF INDEX MATCH WEEKDAY TEXT TRIM You can view the answers in the Solution…
This is an Excel exam, in which you can practice multiple Excel functions, such as: COUNTIF SUMIF INDEX MATCH WEEKDAY TEXT TRIM You can view the answers in the Solution…
This is an Excel exam, in which you can practice multiple Excel functions, such as: LEFT MID VLOOKUP IF IFERROR FIND You can view the answers in the Solution tab!…
In this exercise, you will be able to practice the basics of Pivot Table! You can view the answers in the Answer tab! :) Click here to download Pivot Table…
In this exercise, you will be able to practice the COUNTIFS function, for situations where multiple columns have to be checked! You can view the answers in the Solution tab!…
In this exercise, you will be able to practice the SUMIFS function, for situations where multiple columns have to be checked! You can view the answers in the Solution tab!…
In this exercise, you will be able to practice the COUNTIF function! You can view the answers in the Answer tab! :)
In this exercise, you will be able to practice the SUMIF function! You can view the answers in the Answer tab! :)
In this exercise, you will be able to practice one of the greatest unknown features of VLOOKUP - The Approximate Match method. This method is helpful when you are looking…
In this exercise you will be able to practice the VLOOKUP function! You can view the answers in the Answer tab! :)
In this exercise, you will be able to practice and understand how to use Nested IF in Excel. You can view the answers in the Answer tab! :)