Microsoft Excel 2010 training exercises | Advanced lookup functions

Showing exercises 1-6 (out of 6)

Category: Excel 2010
Topic: Advanced lookup functions
Level: Relatively easy
Course:
Exercise: Add an input field to an Excel 2007 model saying what sort of celebrity you are, and use this to calculate income using a lookup formula.

Go to exercise ...

Category: Excel 2010
Topic: Advanced lookup functions
Level: Average difficulty
Course:
Exercise: Use the MATCH/INDEX functions to work out when a drawdown fee is exceeded in an Excel 2007 model.

Go to exercise ...

Category: Excel 2010
Topic: Advanced lookup functions
Level: Harder than average
Course:
Exercise: Show a cash position at the end of every second month for an Excel 2007 model in 3 different ways, using INDEX, OFFSET and INDIRECT.

Go to exercise ...

Category: Excel 2010
Topic: Advanced lookup functions
Level: Harder than average
Course:
Exercise: Use the INDIRECT function in an Excel 2007 model to allow a user to specify a line item and show its total.

Go to exercise ...

Category: Excel 2010
Topic: Advanced lookup functions
Level: Harder than average
Course:
Exercise: When a user looks up a month and week number in an Excel 2007 spreadsheet, show the corresponding value by using MATCH and INDEX.

Go to exercise ...

Category: Excel 2010
Topic: Advanced lookup functions
Level: Harder than average
Course:
Exercise: Create INDEX array functions to show rows and columns from a table for a choice of row/column.

Go to exercise ...

This page has 0 threads Add post