Microsoft Excel 2013 training exercises

Showing exercises 1-10 (out of 10)

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: 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: 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 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: 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: 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 ...

Category: Excel 2013
Topic: Charts
Level: Average difficulty
Courses: Excel 2013 IntroductionAdvanced Excel 2013
Exercise: Selects all the data and creates a line chart which has to be formatted to display time across X axis.

Go to exercise ...

Category: Excel 2013
Topic: Charts
Level: Average difficulty
Courses: Excel 2013 IntroductionAdvanced Excel 2013
Exercise: Selects all the data and creates a 3D pie chart with an exploded segment and labels with %.

Go to exercise ...

Category: Excel 2013
Topic: Charts
Level: Average difficulty
Courses: Excel 2013 IntroductionAdvanced Excel 2013
Exercise: Selects part of the worksheet and creates a basic Column chart that has formats applied.

Go to exercise ...

This page has 0 threads Add post