CISM 2201 EXAM WITH COMPLETE SOLUTIONS
LATEST UPDATE
In cell D5, create a formula that utilizes the VLOOKUP function to return a cost per
participant for the Game Room workshop based on the workshop ID in cell A5. Use the
range H4:I11 as the table array and the cost per participant is located in column 2 of the
table array. Leave the optional argument range_lookup blank. - ANSWER Enter in cell
D5: = VLOOKUP(A5,H4:I11,2)
Create a one-variable data table in range D5:G13. Use cell B4 as the input cell for the
formula in cell D5. Use cell B9 as the formula result value in cell G5. Click the Column
input cell box in the Data Table dialog box and select cell B4 - ANSWER 1. Click cell D5
2. Type =B4 in cell D5
3. Press enter
4. Click cell G5
5. Type =B9 in cell G5
6. Press enter
7. Click and drag to select range D5:G13
8. Click data tab on ribbon
9. Click forecast then what if analysis
10. Click data table
11. Click column input text box and type $B$4
12. Click Ok
Name the table 'Costs' - ANSWER 1. Click anywhere in the table to select it
2.Click Design on the ribbon
3. In the table name box, type 'Costs
Insert table, with headers, using range A3:E11 as the table range Solution 1. Click and
LATEST UPDATE
In cell D5, create a formula that utilizes the VLOOKUP function to return a cost per
participant for the Game Room workshop based on the workshop ID in cell A5. Use the
range H4:I11 as the table array and the cost per participant is located in column 2 of the
table array. Leave the optional argument range_lookup blank. - ANSWER Enter in cell
D5: = VLOOKUP(A5,H4:I11,2)
Create a one-variable data table in range D5:G13. Use cell B4 as the input cell for the
formula in cell D5. Use cell B9 as the formula result value in cell G5. Click the Column
input cell box in the Data Table dialog box and select cell B4 - ANSWER 1. Click cell D5
2. Type =B4 in cell D5
3. Press enter
4. Click cell G5
5. Type =B9 in cell G5
6. Press enter
7. Click and drag to select range D5:G13
8. Click data tab on ribbon
9. Click forecast then what if analysis
10. Click data table
11. Click column input text box and type $B$4
12. Click Ok
Name the table 'Costs' - ANSWER 1. Click anywhere in the table to select it
2.Click Design on the ribbon
3. In the table name box, type 'Costs
Insert table, with headers, using range A3:E11 as the table range Solution 1. Click and