i need answer it , i but the excel file  and the dominant..?

 

qatachmenTs_e0b06f2c50c03ec7c44F7762ca89986b2cb879a.xlsxStudentsInstrumentTeacherCompe±±on?Uniform SizePianoYesTeacherJennyChuckMarkTotal StudentsStudentIDFirst NameLast NameInstrumentTeacherCompe±±on?Uniform Size000001ZiaWhiTePianoJennyYesXL000002PandoraBrockDrumsChuckYesM000003InezClemenTsViolaChuckYesL000004JaelBoyerBassChuckNoM000005MinervaBurTon±rumpeTMarkNoL000006SummerSweeneyDrumsAnneYesXL000007QuynOr²z±rumboneChuckNoXS000008VioleTWardGuiTarChuckYesXL000009ClarkWardViolaMarkXL000010HyatWaTersDrumsJennyYesXL

Ofce 2013 – myitlab:grader – InstructionsExcel ProjectYOF EWS05 H1 - Managing Students at a Local Music Studio 1.1Project Description:Managers at the hotel have been using a simple dashboard to keep track of revenues and roomreservations. You have been asked to enhance the dashboard by adding some form controls, a Bingmap, and VBA.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Start Excel. Open the downloaded Excel file namede03ws05_grader_h1.xlsx. Save the file with thenamee03ws05Lessons_LastFirstreplacingLastFirstwith your name. In the Security Warning bar,click Enable Content.0.0002On the Student Data worksheet, select the range A7:K17, and then name the rangeStudent_Data. Withrange A7:K17 selected, create a named range for each column in the Student_Data named range usingthe top row as the range values.3.0003Click the Data Inputs worksheet tab. Select the range A3:B3, and then create a named range using theleft column as the name. Select the range A6:E10, and then create a named range usingLesson_Pricingas the name. Select the range A13:E17, and then create a named range usingTrans_Feesas the name.Select the range A20:G24, and then create a named range usingUniform_Feesas the name. Select therange D3:F4, and then create a named range usingEntry_Feeas the name.5.0004Click the Student Data worksheet tab. In cell E5, use the COUNTIF function to count theTeacherfieldin the Student_Data table that meets the filter criteria in cellE4. Copy the formula in cell E5 over to cellI5. In cell K5, use the DCOUNTA function to count the StudentID field in theStudent_Datatable thatmeets the filter criteria in the range D1:K2.8.0005In cell K8, use the VLOOKUP function nested in an IFERROR function to retrieve the price per hourlocated in column C in theLesson_Pricingnamed range for each student based on the student’s skilllevel located in the Skill_level field. The value should be looking for an exact match. To prevent anerror from being displayed when the skill level is not known, use the IFERROR function to leave thecell blank. Copy the formula in cell K8 down to K17.8.0006Click the Lesson Data worksheet tab. In cell F3, add a MATCH function nested in an INDEX functionto retrieve the skill level of each student listed in column B. To prevent zeros from displaying when theskill level is not known, nest the INDEX and MATCH functions in an IF function to leave the cell blankwhen the skill level equals 0. Copy the formula down to F17.8.0007In cell G3, add a MATCH function nested in an INDEX function to retrieve the total fee located in theLesson_Pricing table on the Data Inputs worksheet for each student listed in column B. To prevent anerror from being displayed when the skill level is not known, nest the INDEX and MATCH functionsinside an IFERROR function and display the default total fee of $50. Copy the formula in cell G3 downto G17.8.0008Click the Report worksheet tab. In cell B3, use the VLOOKUP function to look up the teacher’s name intheStudent_Datatable for the student listed in cellB2. The value should be looking for an exactmatch. In cell B4, use the AVERAGEIF function to calculate the teacher’s average fee in thePrice_Per_Hourfield for the teacher listed in cellB3.In cell B5, use the VLOOKUP function to lookup the student’s skill level in theStudent_Datatable for the student listed in cellB2. The value shouldbe looking for an exact match.10.0009In cell B6, use the COUNTIF function to count the StudentID field on theLesson Dataworksheet thatmeet the filter criteria in cellB2.In cell B7, use the SUMIF function to sum the Total Fee field on theLesson Dataworksheet that meet the filter criteria in cellB2.In cell B8, use a nested IF function todetermine how many free lessons the student has earned. If the student has had less than 5 total lessons,display0 earned. If the student has had between 5 and 10 lessons, display1 earned; otherwise, display2 earned.10.000Updated: 03/11/20151Current_Instruction.docx

• 1495176265-e03ws05Lessons_AlmotairiNasser.xlsx
• 1495176266-YOF_EWS05_H1_-_Managing_Students_at_a_Local_Music_Studio_11_Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 19 May 2017 06:05 AM My Price 9.00

-----------

Attachments

file 1495176273-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer