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 (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 ABSOLUTE REFERENCES
This page lists the 9 exercises about Absolute references in Excel on our website:
| 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?
This page has 0 threads
Add post