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