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