EXERCISE TOPIC▼
EXCEL EXERCISES▼
EXCEL EXERCISES▼
- Creating formulae (5)
- Formatting worksheets (7)
- Basic printing (8)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (17)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (6)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (2)
- Pivot tables (3)
- Advanced pivot tables (3)
- Scenarios (2)
- Data tables (2)
- Array formulae (2)
- Building models (2)
- Masking (2)
- Cashflow calculations (1)
- Investment appraisal (1)
Excel exercises on CONDITIONAL FORMULAE
This page lists the 17 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. |
| 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. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Conditional formulae |
| Level: | Relatively easy |
| Courses: | Excel Business ModellingExcel Intermediate |
| Exercise: | Single IF simple to calculate engineer callout charge at 2 different rates. |
| 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. |
| Software: | Excel |
| Version: | Excel 2016 and later |
| Topic: | Conditional formulae |
| Level: | Relatively easy |
| Courses: | Excel Business ModellingExcel Intermediate |
| Exercise: | Uses single =IF. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
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