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