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