Answer of the Q5 Practise exam 2
As
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.
2 answers ( 0 marked as helpful)
Hi Nighat,
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.
Best,
Ned
Thank you Ned for the prompt reply. Yes, in the explaination of the answer it is written that the value are hard coded but I couldnt see any where in the question or in the excel file that these values are typed manually.
Nighat