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