Microsoft Excel
Array formulae exercise
Harder than average exercise

This Microsoft Excel ARRAY FORMULAE exercise is provided to allow potential course delegates to assess their suitability for the Wise Owl EXCEL BUSINESS MODELLING course only, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Exercise: Multiple sheets, arrays and other titbits

1)	Create a spreadsheet to predict total labour costs for a shop per day, given the following information: There will be 3 grades of staff - managers, counter staff and cleaning staff There will be 2 shifts - day and night
2)	Hourly pay rates per grade per shift will be as follows:
	The minimum wage doesn't apply here ...
3)	Total hours per day will be as follows:
	Enter these figures in your spreadsheet also
4)	Create formulae to show the total wages by labour type and time period - your final spreadsheet should have a structure similar to the one shown below:
	Use an array formulae to calculate total wages
5)	The rates and hours for provincial stores (the dark unknown world outside London) will be different:
	These are the equivalent provincial figures
6)	Copy your spreadsheet twice to get spreadsheets for London, Provinces and Total. Create formulae giving the total wage bill for each region, and sum them to get the total wage figure per day.
7)	Save this file with the same name, then close it down.