Use of Excel Functions

### Excel Practice & Exercises with SUMIF Function

This article contains 7 practice exercises for the Excel SUMIF function. You will need a basic understanding of accounting and Excel to solve all the ...

### Excel Practice & Exercises with SUM Function

Problem Overview You will get six exercises related to the SUM function. To illustrate the problems, we have used a dataset. This dataset represents ...

### Excel Practice & Exercises with IF Function

This article contains seven Excel practice exercises related to the IF function. The problems are easy to solve, so you will only need a basic level ...

### Excel Exercises with 9 Logical Functions

Download Practice Workbook Exercises for Logical Functions.xlsx Problem Overview Our sample dataset below has 7 columns and 20 rows. ...

### Excel Practice & Exercises with INDEX-MATCH Formula

To solve all the problems given in this article, you should know about the following Excel functions: INDEX, MATCH, CONCAT, CONCATENATE, and ...

### Excel VLOOKUP Exercises: 10 Tricky Problems

In this article are ten Excel VLOOKUP exercises to practice. Most of the problems are easy to solve, however you will need some intermediate level ...

### Nested IF Function Practice Exercises in Excel

Problem Overview Our dataset has three columns for the first exercise: “Name”, “Score”, and “Comment”. We will slightly change the dataset ...

Advanced Excel Exercises with Solutions PDF