Solved:
Answered by AI, Verified by Human Experts
In cell C17, create a nested formula using the INDEX and MATCH functions that returns the Number of participants for the Bedroom workshop type.
In cell C17, create a nested formula using the INDEX and MATCH functions that returns the Number of participants for the Bedroom workshop type.
Note that theNestedFormulausing theINDEXandMATCH Functionsthat return the Number of participants for the Bedroom workshop type are given in the attached image.What is a nested Formula?Simply put, anested functionin computer programming or Microsoft Excel is a function that is declared within another function, the enclosing function.In Excel, the INDEX and MATCH functions work together to execute a lookup and return a value from a specified point in a data table. TheINDEXmethod retrieves a value from a defined place in a table, whereas theMATCH functionretrieves the position of a specified item in a range of cells.These functions can be used to look for a value in adatabasedepending on a set of criteria. INDEX and MATCH, for example, may be used to seek a price for a given product in a table of prices based on the product name.Learn mroe aboutnested Formulas;brainly.com/question/14001601#SPJ1...