Excel exercises on RANGE NAMES

This page lists the 13 exercises about Range names in Excel on our website:

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names instead of cell references in your Microsoft Excel 2007 formulae to make your spreadsheets much easier to understand.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names in Excel 2007 movies workbook to make calculations much easier to create and use.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names in a Microsoft Excel 2007 Poohsticks workbooks to make calculations easier.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create easy to read Microsoft Excel 2007 spreadsheets by using range names in your formulae.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Relatively easy
Courses: Excel Business ModellingExcel Intermediate
Exercise: Create easy to read formulae in Microsoft Excel 2007 by using range names instead of cell references.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creates Range names and uses them in formulae.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Uses a range name in the formula to calculate the holiday costs in UK £.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creates 3 range names and uses them to calculate the revenue, costs and profit.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate part time pay rates using range names in Excel.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Range names
Level: Average difficulty
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creating range names for input cells.

Go to exercise ...

Software: Excel
Version: Excel 2013 and later
Topic: Range names
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Creates range names for the archery scoring and uses them in the formula.

Go to exercise ...

Software: Excel
Version: Excel 2016 and later
Topic: Range names
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Calculate ticket prices bands using range names in Excel.

Go to exercise ...

Software: Excel
Version: Excel 2010 and later
Topic: Range names
Level: Harder than average
Courses: Excel Business ModellingExcel Intermediate
Exercise: Use range names instead of absolute references in Microsoft Excel 2007 to make creating formulae easier.

Go to exercise ...

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