Answer of the Q5 Practise exam 2
As you can see in the above screen shot column C uses E5:E7 as a source but it is still marked incorrect. Can someone clarify it if It is my misunderstanding or error in the text.
As the answer states - the values used by the dropdown are hard-coded. This means that the user has not pointed to cells in the sheet but typed them directly.