Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the Assessment Code for Task 4 in cell G 9 9 ? Note that this will only work in the English version of
What is the Assessment Code for Task in cell G
Note that this will only work in the English version of Excel or newer. If you are using Excel in a different language, please set it to English while doing this assessment task.
Task INDEX and MATCH
An outdoor clothing and accessories store placed prices on items according to the colours in demand for the item as per table in Data Task
Using the INDEX and MATCH functions, find the prices on these three items
The data is available in the 'Data' sheet. Here you will need to click the "plus" icon near 'Task to reveal the relevant data.
Now, using the data in Task use INDEX and MATCH to fill the green cells D:D
Everytime you enter something in the green cells, the 'Assessment Code for Task will change.
This code has been programmed by us for the purposes of checking your answers.
When you have the correct answers, and if you have correctly used INDEX and MATCH, the 'Assessment Code' that is generated will let us know this.
Please do not try to type anything into the yellow cell as that would disrupt the assessment code. If you do type into the yellow cell, redownload the XLS file from Coursera.
You will be required to enter the data in the green cells, as well as the data in the yellow cell onto the Coursera platform so that we can mark you.
tableItemColour,Price,,Ski Jacket,red,,,Raincoatorange,,,Umbrellaviolet,,,Task Total,
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started