Microsoft Excel 2013 training exercises | Range names and absolute references

Showing exercises 1-7 (out of 7)

Category: Excel 2013
Topic: Range names and absolute references
Level: Relatively easy
Course: Advanced Excel 2013
Exercise: Cake Friday - uses an absolute cell to always refer to the cakes per child figure.

Go to exercise ...

Category: Excel 2013
Topic: Range names and absolute references
Level: Average difficulty
Course: Advanced Excel 2013
Exercise: Uses absolute cell references to refer to the ticket prices in the formulae.

Go to exercise ...

Category: Excel 2013
Topic: Range names and absolute references
Level: Average difficulty
Course: Advanced Excel 2013
Exercise: Creates Range names and uses them in formulae.

Go to exercise ...

Category: Excel 2013
Topic: Range names and absolute references
Level: Average difficulty
Course: Advanced Excel 2013
Exercise: Uses a range name in the formula to calculate the holiday costs in UK £.

Go to exercise ...

Category: Excel 2013
Topic: Range names and absolute references
Level: Average difficulty
Course: Advanced Excel 2013
Exercise: Creates 3 range names and uses them to calculate the revenue, costs and profit.

Go to exercise ...

Category: Excel 2013
Topic: Range names and absolute references
Level: Average difficulty
Course: Advanced Excel 2013
Exercise: Uses absolute cell references to calculate store bonuses.

Go to exercise ...

Category: Excel 2013
Topic: Range names and absolute references
Level: Harder than average
Course: Advanced Excel 2013
Exercise: Creates range names for the archery scoring and uses them in the formula.

Go to exercise ...

This page has 0 threads Add post