Management & Information Systems

29/02/2018

week 5 in the seminar we work on the exercises

Score Rating (IFs):

Create an If function to rate the players based on the following criteria: If a player scores more than 15 points the player is ‘Fantastic’. Otherwise the player is ‘Not Good Enough!’

Movies Flop (IFs):

After calculating the ‘Profit’, create an If function to calculate whether each movie was a flop or a success. Use the following criteria:

 If the profit was less than £100,000,000 then the movie is a flop

 Otherwise the movie is a success.

Test Results (Nested Ifs):

Follow the following steps:

1) For the first Pass/Fail Column, write a formula that will display 'pass' if the result in Test 1 is greater or equal to 5 and 'fail' if it is not. Replicate this formula to all cells.

2) For the second Pass/Fail column, write a formula that will display 'pass' if the result in Test 2 is greater or equal to the Pass Mark, and fail if it is not. Replicate this formula to all cells.

3) For the Feedback column, write a formula that will display 'improvement' if the result in Test 2 is greater than the result in Test 1, if not, display 'worse'. Replicate this formula to all cells.

4) Create a new column after the ‘Feedback’ column and call it ‘Decision’. In the Decision column write a formula that will display 'Qualified’ if Test 1 and Test 2 are greater than or equal to 6 and the total must be 15 or more. If it isn't, display 'Withdrawn'. Replicate this formula to all cells.*

This is answer from the exercises