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