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