| Actual | Answer | Formula | |
| 1 | 1 | 1 | |
| 2 | 2 | A1+1 | |
| 3 | 3 | A2+1 | |
| 4 | 4 | A3+1 | |
| 5 | 5 | A4+1 | |
| 1 | 1 | A5-A4 | |
| 6 | 6 | A5*A4 | |
| 2 | 2 | A6/A4 | |
| Formula | Formula | General!D2 | |
| Common Functions | |||
| 15 | 15 | SUM | |
| 6 | 6 | MAX | |
| 1 | 1 | MIN | |
| 8 | 8 | COUNT | |
| 3 | 3 | AVERAGE | |
| TRUE | Boolean | ||
| FALSE | |||
| Errors | |||
| #DIV/0! | #DIV/0! | A1/0 | Divide by 0 |
| #NAME? | #NAME? | AVG(A3:A7) | Unknown Function |
| #VALUE! | #VALUE! | A5-A2 | Bad Value |
| #NULL! | #NULL! | (SUM(A1:A10 C1:C10)) | Bad Intersection |
| #REF! | #REF! | A3+A13 | Bad Reference |
| #N/A | #N/A | VLOOKUP(0.1,range,2,TRUE) | Not Applicable |
| #NUM! | #NUM! | RATE(0, -200, 8000) | Problem with a Number |
| Special Html Characters | |||
| < | Less Than | ||
| > | Greater Than | ||
| & | Ampersand | ||
| " | Quote | ||
| … | Elipse |
| 1-1-00 | 12-14-95 | 2-28-00 | 12-30-00 | 12-31-00 | Unformatted Dates & | ||||
| 1 | 35047 | 36584 | 36890 | 36891 | their Julian number | ||||
| 9-24-99 | 25-Sep-99 | 4e+04 * | Sep-99 | 4e+04 * | 4e+04 * | 30-Sep | Dates | ||
| 9:00 AM | 10:00:00 AM | 11:00 | 12:00:00 | 01:00 | 1:02:00 | 03:00.5 | Time | ||
| 1 | 1.2 | 1.23 | 1.234 | -1 | -1.2 | -1.23 | -1.234 | General | |
| 1.00 | 1.20 | 1.23 | 1.23 | -1.00 | -1.20 | -1.23 | -1.23 | Number | |
| 1000000.00 | 1000000.20 | 1000000.23 | 1000000.23 | -1000000.00 | -1000000.20 | -1000000.23 | -1000000.23 | Number - Big Numbers | |
| 1,000,000.00 | 1,000,000.20 | 1,000,000.23 | 1,000,000.23 | -1,000,000.00 | -1,000,000.20 | -1,000,000.23 | -1,000,000.23 | Number - Big Numbers with comma | |
| 1 * | 1.2 * | 1.23 * | 1.234 * | -1 * | -1.2 * | -1.23 * | -1.234 * | Currency | |
| 1e+04 * | 1e+04 * | 1e+04 * | 1e+04 * | -1e+04 * | -1e+04 * | -1e+04 * | -1e+04 * | Currency - Big Numbers | |
| 1.00% | 1.20% | 1.23% | 1.23% | -1.00% | -1.20% | -1.23% | -1.23% | Percentage 2 decimals - small numbers | |
| 100.00% | 120.00% | 123.00% | 123.40% | -100.00% | -120.00% | -123.00% | -123.40% | Percentage 2 decimals - bigger numbers | |
| 100% | 120% | 123% | 123% | -100% | -120% | -123% | -123% | Percentage no decimals | |
| 1.00E+00 | 1.20E+00 | 1.23E+00 | 1.23E+00 | -1.00E+00 | -1.20E+00 | -1.23E+00 | -1.23E+00 | Scientific | |
| $ 1.00 | $ 1.20 | $ 1.23 | $ 1.23 | $ (1.00) | $ (1.20) | $ (1.23) | $ (1.23) | Accounting | |
| $ 10,000.00 | $ 10,000.20 | $ 10,000.23 | $ 10,000.23 | $ (10,000.00) | $ (10,000.20) | $ (10,000.23) | $ (10,000.23) | Accounting - Big Numbers | |
| 1 | 1 1/5 | 1 2/9 | 1 2/9 | -1 | -1 1/5 | -1 2/9 | -1 2/9 | Fraction | |
| 1.23456789012345e-21 * | 1234567890.12345 * | Max Precision Numbers | |||||||
| $ 12.34 | $ 123.40 | $ 1,234.00 | $ 12,340.00 | $ 123,400.00 | $ 1,234,000.00 | $ 12,340,000.00 | $ (123.40) | $ (1,234.00) | Accounting |
| Bold | Italics | Underlined | Modifier | |
| Left | Centered | Right | Justification | |
| Arial | Times New Roman | Courier New | Fonts 12 Pts | |
| Comic Sans | Brush Script | Verdana | Fonts 12 Pts | |
| Font Sizing | ||||
| 8 Pts | ||||
| 10 Pts | ||||
| 12 Pts | ||||
| 14 Pts | ||||
| 18 Pts | ||||
| 24 Pts | Superscript | |||
| 36 Pts | Subscript | |||
| 48 Pts | ||||
| Regular Bold Itallics Underlined | ||||
| Cell 1 | ||||||
| Cell 2 | ||||||
| Cell 3 | ||||||
| Cell 4 | ||||||
| Cell 5 | ||||||
| Cell 6 | ||||||
| Cell 7 | ||||||
| Cell 8 | ||||||
| Cell 9 | ||||||
| Cell 10 | ||||||
| Cell 11 | ||||||
| Cell 12 | ||||||
| Cell 13 | ||||||
| Red Blue | Cell 14 | |||||
| Cell 15 | ||||||
| Cell 16 | ||||||
| Cell 17 | ||||||
| Cell 18 | ||||||
| Cell 19 | ||||||
| Cell 20 | ||||||
| Cell 21 | ||||||
| Cell 22 | ||||||
| Cell 23 | ||||||
| Cell 24 | ||||||
| Cell 25 | ||||||
| Cell 26 | ||||||
| Cell 27 | ||||||
| Cell 28 | ||||||
| Cell 29 | ||||||
| Cell 30 | ||||||
| Cell 31 | ||||||
| Cell 32 | ||||||
| Cell 33 | ||||||
| Cell 34 | ||||||
| Cell 35 | ||||||
| Cell 36 | ||||||
| Cell 37 | ||||||
| Cell 38 | ||||||
| Cell 39 | ||||||
| Cell 40 | ||||||
| Colors From Patterns Picker | ||||||
| Link to dump.c |
| www link |
| Ftp link |
| mailto link |
| file protocol |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |