Per the school district’s request, your program will be able to test students’ knowledge of the metric prefixes (milli-, mega-, etc.), for as long as each student desires.
The spreadsheet (.xlsx) can be downloaded from the main "Your Own Program - Metric Flash Cards" assignment. This file MUST be present for your program to function, and should not be renamed. You do not need to upload the spreadsheet to this assignment.
In the Initial Check function, you will test the user's guess for a single prefix.
Algorithm
Write a fuction MetricCheck:
Inputs: Row number in the spreadsheet of the prefix being checked (rowNumber), student guess of the prefix's abbreviation (abbrevGuess), student guess of the prefix's exponent (exponentGuess), number of abbreviations they have guessed correctly so far (numCorrectAbbrev), and number of exponents they have guessed correctly so far (numCorrectExponent) P
Output: Name of the prefix (prefixName), and updated numbers of correct abbreviations and exponents (numCorrectAbbrev and numCorrectExponent)
Procedure:
Pull data from the given Excel Sheet into a table object variable using readtable. This table will contain the prefixes, exponents, and abbreviations of the metric prefixes.
Create two separate string arrays for the names and abbreviations of the prefixes, and a numeric array for the exponents. It is important that prefixes remain in their original order! See the "Hints and Useful Information" section of the main assignment for instructions on how to do steps 1 and 2.
Find the name, abbreviation, and exponent of the rowNumber-th prefix, and store all three as variables.
Report the prefix’s name to the user and assign it to the prefixName output variable.
If the abbrevGuess is correct, display a message of congratulations, and add 1 to numCorrectAbbrev
Otherwise, display the correct answer.
If the exponentGuess is correct, display a message of congratulations, and add 1 to numCorrectExponent
Otherwise, display the correct answer.

Example Outputs:
>> [Prefix, numCorrectAbbrev, numCorrectExponent] = MetricCheck(5, "T",12, 2, 4)
The metric prefix is: tera
Abbreviation is correct!
Exponent is correct!
Prefix =
"tera"
numCorrectAbbrev =
3
numCorrectExponent =
5
>> [Prefix, numCorrectAbbrev, numCorrectExponent] = MetricCheck(6, "T",12, 2, 4)
The metric prefix is: giga
The correct abbreviation is: G
The correct exponent is: 9
Prefix =
"giga"
numCorrectAbbrev =
2
numCorrectExponent =
4