Laser Loot cards contain a 10 digit number. The 8th and 9th digits form a check digit number. Four student numbers are provided below. Students: Justin Bara Benjamin Biello Brian Cipolla Victor Collazo Loot Number 8765431131 4588654694 9876543277 3457689591 Test length - Use the reference to your answer above to determine that the length of the card equals the reference to cell D12. If the length is proper return "Valid" or if not "Invalid". (A simple IF statement). Justin Bara Benjamin Biello Brian Cipolla Victor Collazo The following information relates to how Lasell determines if the card is valid. Card criteria Length of card number 10 digits Check digit multiplier Constant 150 Use an Excel parsing function to identify the 2 digit check digits. Justin Bara Benjamin Biello Brian Cipolla Victor Collazo Use an Excel function to determine the length of each card. Your formula should reference Cells E5 to E8. Justin Bara Benjamin Biello Brian Cipolla Victor Collazo Test to determine if check digits (above) multiplied times the check digit multiplier (Cell D13) equals a number less than the constant (Cell D14). Return valid or invalid. (A simple IF Justin Bara Benjamin Biello Brian Cipolla Victor Collazo