WISE OWL EXERCISES
EXCEL EXERCISES
EXCEL EXERCISES
- Creating formulae (5)
- Formatting worksheets (7)
- Basic printing (7)
- Charts (10)
- Absolute references (9)
- Range names (13)
- Conditional formulae (16)
- Conditional formatting (7)
- Basic tables (6)
- Formatting numbers and dates (3)
- Working with dates (1)
- Data validation (6)
- Protection (1)
- Advanced IFs (5)
- Lookup functions (14)
- Advanced lookup functions (9)
- Text functions (1)
- Advanced charts (4)
- Multiple worksheets (1)
- Advanced tables (1)
- Pivot tables (4)
- 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 ABSOLUTE REFERENCES
This page lists the 9 exercises about Absolute references in Excel on our website: p >
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Absolute references |
Level: | Relatively easy |
Course: | Excel Intermediate |
Exercise: | Changing Sterling to Euros Using Absolute References. |
Software: | Excel |
Version: | Excel 2010 and later |
Topic: | Absolute references |
Level: | Relatively easy |
Course: | Excel Intermediate |
Exercise: | Use single cell input values in Microsoft Excel 2007 by using absolute cell references in your formulae. |
Software: | Excel |
Version: | Excel 2013 and later |
Topic: | Absolute references |
Level: | Relatively easy |
Course: | Excel Intermediate |
Exercise: | Cake Friday - uses an absolute cell to always refer to the cakes per child figure. |
Software: | Excel |
Version: | Excel 2010 and later |
Topic: | Absolute references |
Level: | Relatively easy |
Course: | Excel Intermediate |
Exercise: | For a movie tickets spreadsheet use absolute cell references in formulae. |
Software: | Excel |
Version: | Excel 2010 and later |
Topic: | Absolute references |
Level: | Relatively easy |
Course: | Excel Intermediate |
Exercise: | Create absolute cell references for Poohsticks data in Excel. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Absolute references |
Level: | Average difficulty |
Course: | Excel Intermediate |
Exercise: | Calculate salesperson commission using absolute cell references. |
Software: | Excel |
Version: | Excel 2016 and later |
Topic: | Absolute references |
Level: | Average difficulty |
Course: | Excel Intermediate |
Exercise: | Price orders using absolute cell references. |
Software: | Excel |
Version: | Excel 2013 and later |
Topic: | Absolute references |
Level: | Average difficulty |
Course: | Excel Intermediate |
Exercise: | Uses absolute cell references to refer to the ticket prices in the formulae. |
Software: | Excel |
Version: | Excel 2013 and later |
Topic: | Absolute references |
Level: | Average difficulty |
Course: | Excel Intermediate |
Exercise: | Uses absolute cell references to calculate store bonuses. |
You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?