Answered step by step
Verified Expert Solution
Link Copied!

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 4 in cell G99?
Note that this will only work in the English version of Excel 2013 or newer. If you are using Excel in a different language, please set it to English while doing this assessment task.
86 Task 4 INDEX and MATCH
87 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 4
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 4' to reveal the relevant data.
Now, using the data in Task 4, use INDEX and MATCH to fill the green cells D99:D101.
Everytime you enter something in the green cells, the 'Assessment Code for Task 4' 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, re-download 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.
\table[[Item,Colour,Price,,],[Ski Jacket,red,,,],[Raincoat,orange,,,],[Umbrella,violet,,,],[,Task 4 Total,],[,,,,]]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions