Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what formula do I use for question 14? Layout References Mailings Review View Help Iby Microsoft Defender Advanced Threat Protection and it hasnit detected any

what formula do I use for question 14? image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Layout References Mailings Review View Help Iby Microsoft Defender Advanced Threat Protection and it hasnit detected any threats. If youneed to ed it this file, clict \begin{tabular}{|c|c|} \hline Step & Instructions \\ \hline 14 & Nowthatwehavedeterminedwhichstudentsaregoingonthetrip,youneedtohelpcalculatehowmucheachofthemmustpayfortheiruniforms.Theuniformshophasofferedaslidingpricescale,themoreuniformsyoubuyofaparticularsize,thelessexpensiveitisperperson.IncellI11,enteranINDEXfunctiontoretrievetheperunilformpricefromtheUniform.Feesnamedrange.YoullneedtouseaMATCHfunctionthatlooksupthenumberofunilformsneededtodeterminetherownumberandanotherMATCHfunctionthatlooksuptheuniformsizetodeterminethecolumnnumber.CopytheformuladownthroughI16. \\ \hline 15 & ThesecondhalftotheStudentReportwillretrievethespecificfeesforwhichthestudentwhoseIDisincellB2isresponsible.IncellE5,enteraVLOOKUPfunctionthatwillretrievethestudentsUniformSizefromtherangeA12:E36ontheStudentReportworksheet.IncorporateanIFERRORfunctionsothatifthereisnoStudentIDincellB2,ablankvalue("")isreturnedinsteadofaANVAerror. \\ \hline 16 & IncellE6,useaVLOOKUPfunctiontoretrievetheperuniformpricefromtherangeG11:i16fortheuniliormsizeincellE5. \\ \hline 17 & \( \begin{array}{l}\text { In cell E7, use a HLOOKUP function to retrieve the Registration foe from the Entry_Fees } \\ \text { named range based on the Registration Type in cell E3. }\end{array} \) \\ \hline 18 & \( \begin{array}{l}\text { In cell E8, use an INDEX function to retrieve the Transportation Fee from the Trans_Fees } \\ \text { named range based on the total number of students ready to go in cell E38 and the } \\ \text { transportation mode in cell E4. }\end{array} \) \\ \hline 19 & In cell E9, use a SUM function to calculate the total costs for which the student is responsible. \\ \hline 20 & \( \begin{array}{l}\text { Save and close Excel_Ch05_Assessment_MusicLessons.xisx. Exit Excel. Submit the fle as } \\ \text { directed. }\end{array} \) \\ \hline \end{tabular} Total Points Layout References Mailings Review View Help Iby Microsoft Defender Advanced Threat Protection and it hasnit detected any threats. If youneed to ed it this file, clict \begin{tabular}{|c|c|} \hline Step & Instructions \\ \hline 14 & Nowthatwehavedeterminedwhichstudentsaregoingonthetrip,youneedtohelpcalculatehowmucheachofthemmustpayfortheiruniforms.Theuniformshophasofferedaslidingpricescale,themoreuniformsyoubuyofaparticularsize,thelessexpensiveitisperperson.IncellI11,enteranINDEXfunctiontoretrievetheperunilformpricefromtheUniform.Feesnamedrange.YoullneedtouseaMATCHfunctionthatlooksupthenumberofunilformsneededtodeterminetherownumberandanotherMATCHfunctionthatlooksuptheuniformsizetodeterminethecolumnnumber.CopytheformuladownthroughI16. \\ \hline 15 & ThesecondhalftotheStudentReportwillretrievethespecificfeesforwhichthestudentwhoseIDisincellB2isresponsible.IncellE5,enteraVLOOKUPfunctionthatwillretrievethestudentsUniformSizefromtherangeA12:E36ontheStudentReportworksheet.IncorporateanIFERRORfunctionsothatifthereisnoStudentIDincellB2,ablankvalue("")isreturnedinsteadofaANVAerror. \\ \hline 16 & IncellE6,useaVLOOKUPfunctiontoretrievetheperuniformpricefromtherangeG11:i16fortheuniliormsizeincellE5. \\ \hline 17 & \( \begin{array}{l}\text { In cell E7, use a HLOOKUP function to retrieve the Registration foe from the Entry_Fees } \\ \text { named range based on the Registration Type in cell E3. }\end{array} \) \\ \hline 18 & \( \begin{array}{l}\text { In cell E8, use an INDEX function to retrieve the Transportation Fee from the Trans_Fees } \\ \text { named range based on the total number of students ready to go in cell E38 and the } \\ \text { transportation mode in cell E4. }\end{array} \) \\ \hline 19 & In cell E9, use a SUM function to calculate the total costs for which the student is responsible. \\ \hline 20 & \( \begin{array}{l}\text { Save and close Excel_Ch05_Assessment_MusicLessons.xisx. Exit Excel. Submit the fle as } \\ \text { directed. }\end{array} \) \\ \hline \end{tabular}

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

Financial Accounting

Authors: Charles T. Horngren, Jr. Harrison, Walter T.

2nd Edition

0133118207, 978-0133118209

More Books

Students also viewed these Accounting questions

Question

Is the sample selected related to the target population?

Answered: 1 week ago