Question: If you enter a number from 1 to 6 in cell B4, the corresponding colour, based on the table in the worksheet, will be

If you enter a number from 1 to 6 in cell B4,

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:

Step by Step Solution

3.42 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To retrieve the corresponding color based on the number enter... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!