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