Matching Pairs Spreadsheet Matching GameOnline version Terms and functions by Andrew Bleach 1 * 2 / 3 numeric keypad 4 = 5 (A3:A7) 6 =AVG 7 =SUM 8 A1 9 Wednesday, 13 of March 2019 10 Conditional formatting 11 Autosum 12 1, 11, 21, 31, 41, 51 13 $ 14 Hello 15 9:05am 16 =MAX 17 + 18 0.000 19 alphanumeric keypad 20 Sort 21 F1 to F12 22 January 23 numlock 24 =MIN 25 - This will colour code the data according to how high or low it is is an example of filling with a 10 step value is the function for finding the minimum value in a range of cell values is the first cell in a spreadsheet is the range of cells included in a formula from A3 to A7 is the part of the keyboard with numbers and letters indicates it is currency numerical data type is the keypad on the right of the keyboard and is either movement or numeric entry toggles numeric keypad between movement controls and numbers is the first part of every formula is the function for finding the maximum value in a range of cell values is the time data type is a text data type that can be filled to get every month is the date data type divide this function will automatically add up the values in a range is the text data type minus is a number to three decimal places this is a function of a spreadsheet that will allow you to place the values in ascending order Are the function keys at the top of the keyboard Multiplication add is the function for finding the average value in a range of cell values Is the function for adding up a selection or range of cell values