Input 1. Press the A button in the input area to do anything. Deleting text 1. Press the spacebar and left arrow key simultaneously. 2. If there's no text in the formula bar, this will delete everything. Copying and pasting cells 1. Copy | SPACE+C 2. Paste | SPACE+V 3. Cut | SPACE+T Moving cells 1. If there's no text in the formula bar, use the arrow keys or mouse. 2. If there's text in the formula bar, use the arrow keys (using the mouse will embed the reference). Design 1. The design tab, from left to right, has the following controls: Color, Saturation, Brightness, and Transparency. 2. Conditional formatting (changes cell color based on value). 3. You can add conditional formatting. Functions Logic | IF AND NOT OR Data | SUM MAX MIN AVERAGE COUNT COUNTIF HLOOKUP VLOOKUP LEN Math | RANDBETWEEN ROUND ABS SQRT CEILING FLOOR SIN ASIN COS ACOS TAN ATAN LN LOG Date & Time | YEAR MONTH WEEKDAY DAY HOUR MINUTE SECOND Operators () is also supported + - * / ^ % ! = < > <= >= =! Symbols = | Indicates a formula (enter first) : | Specifies a cell range , | When entering multiple function arguments $ | Absolute reference & | String concatenation " " | Converts numbers and other data to strings
