#1 data table: On the table worksheet create a data table from the cell range C5:D21 that will calculate relevant interest amounts for the interest variables on the first column of the table. view demo full screen click here
#2 dmax function: enter an appropriate criterion within the cell range A1:D2 and a database function in cell D33 to calculate the maximum sales for the North region of Europe. view demo full screen click here
#3 if function: On the whatif worksheet add a function in cell E2
to calculate the projected sales for Qtr1 2004 using the conditions on
the worksheet (as shown in the grid below). Copy the function in cell E2 to the cell range E3:E82
view demo full screen click here
#4 vlookup function: on the lookup worksheet add a function in cell C4 to input the name of the chief salesperson that deals with the region in cell B4 (West). Copy the function in cell C4 to the cell range C5:C30 view demo full screen click here
#5 index, match function instead of vlookup view demo full screen click here