Mr. Brown has given a test to his class. He would like to have the average score for the class as well as the student name of the highest and lowest scores. Develop a solution to calculate and print out these values. (Use a trip value to stop the processing of the loop.)

Drag the tiles to the correct boxes to complete the pairs. match the errors with their definitions. #name #value #ref when a formula produces output that is too lengthy to fit in the spreadsheet cell arrowright when you enter an invalid cell reference in a formula arrowright when you type text in cells that accept numeric data arrowright when you type in a cell reference that doesn’t exist arrowright reset next