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