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