Excel exercises on CONDITIONAL FORMULAE

This page lists the 16 exercises about Conditional formulae in Excel on our website:

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use IF functions in Microsoft Excel 2007 to rate movies as a flop or success based on their profit.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to rate the players in a game of poohsticks.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using If to display different size text messages.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to calculate total values based on different charge rates.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate conditional counts and sums of data using Excel functions.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to calculate a bonus based on whether targets have been met.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Pracises using nested =IF to decide on the fine a player gets.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate commission using conditional formulae.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate parking fees using an IF function.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: If functions to calculate different order discounts.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using IF to calculate different voucher rates.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using If to Calculate different parking charges.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use an If function in Microsoft Excel 2007 to calculate different order totals based on the quantity of items ordered.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Conditional formulae
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Using =IF and Concatenation to display different text messages.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use a nested If function in Microsoft Excel 2007 to translate codes into full text descriptions.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Conditional formulae
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create nested If functions in Microsoft Excel 2007 to categorise lists of data.

Go to exercise ...

You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?

This page has 0 threads Add post