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