If you enter a number from 1 to 6 in cell B4, the corresponding colour, based...

Transcribed Image Text:

If you enter a number from 1 to 6 in cell B4, the corresponding colour, based on the table in the worksheet, will be shown in cell B5. Here is the formula in cell B5. (84, B1:G2, 2) What is the cell formula function in position X such that the formula will perform correctly as shown above? You need to write the answer clearly in the box below. You only need to write the function name, using capital letters, in the answer. Here is a worksheet. A D E F. G H. 1 Number 1 2 3 5 6 2 Colour Red Orange Yellow Green Blue Purple 3. Enter a number 4 4. between 1 to 6: The colour for the Green 5. number is: If you enter a number from 1 to 6 in cell B4, the corresponding colour, based on the table in the worksheet, will be shown in cell B5. Here is the formula in cell B5. (84, B1:G2, 2) What is the cell formula function in position X such that the formula will perform correctly as shown above? You need to write the answer clearly in the box below. You only need to write the function name, using capital letters, in the answer. Here is a worksheet. A D E F. G H. 1 Number 1 2 3 5 6 2 Colour Red Orange Yellow Green Blue Purple 3. Enter a number 4 4. between 1 to 6: The colour for the Green 5. number is:

Answer rating: 100% (QA)

Answe... View the full answer