| Function | Execution | Desired Result | Correct? | Notes |
| ASC | 87 | |||
| ASC | 87 | |||
| ASC | 120 | |||
| CHAR | v | |||
| CHAR | @ | |||
| CHAR | H | |||
| CHAR | m | |||
| CLEAN | test | |||
| CODE | 116 | t | ||
| CONCATENATE | a complete string | |||
| DOLLAR | 12312.23 | |||
| DOLLAR | 12312.23 | |||
| DOLLAR | 12312.23 | |||
| FIXED | 12312.2 | |||
| FIXED | 12312.2 | |||
| FIXED | 35124 | |||
| LEFT | AaBbC | |||
| LEFT | A | |||
| LEN | 52 | |||
| LOWER | aabbccddeeffgghhiijjkkllmmnnooppqqrrssttuuvvwwxxyyzz | |||
| MID | CcDd | |||
| REPLACE | AaBb:)EeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz | |||
| REPT | abcdabcdabcd | |||
| REPT | abcdabcdabcd | |||
| RIGHT | xYyZz | |||
| SEARCH | 21 | |||
| SEARCH | 21 | |||
| SEARCH | #VALUE! | |||
| SUBSTITUTE | AABBCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz | |||
| SUBSTITUTE | AABBCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz | |||
| SUBSTITUTE | AaBbCcDdEeFfGgHhIiJjKkLlMmNnOoPpQqRrSsTtUuVvWwXxYyZz | |||
| UPPER | AABBCCDDEEFFGGHHIIJJKKLLMMNNOOPPQQRRSSTTUUVVWWXXYYZZ | |||
| VALUE | 987.65 | |||
| VALUE | #VALUE! | |||
| VALUE | 9 |