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