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 ...

10 Excel Exercises for Students (with Answers)

Download Practice Workbook Download the Excel file. Exercises for Students with Solutions.xlsx Problem Overview There are ten ...

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

 

 

ExcelDemy
Logo