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