Large Language Models (LLM) have become sophisticated enough that complex computer programs can be created through interpretation of plain English sentences and implemented in a variety of modern languages such as Python, Java Script, C++ and Spreadsheets. These tools are powerful and relatively accurate and therefore provide broad access to computer programming regardless of the background or knowledge of the individual using them. This paper presents a series of experiments with ChatGPT to explore the tool's ability to produce valid spreadsheet formulae and related computational outputs in situations where ChatGPT has to deduce, infer and problem solve the answer. The results show that in certain circumstances, ChatGPT can produce correct spreadsheet formulae with correct reasoning, deduction and inference. However, when information is limited, uncertain or the problem is too complex, the accuracy of ChatGPT breaks down as does its ability to reason, infer and deduce. This can also result in false statements and "hallucinations" that all subvert the process of creating spreadsheet formulae.

翻译：大型语言模型（LLM）已发展到足够复杂的程度，能够通过解读纯英语句子来创建复杂的计算机程序，并在Python、JavaScript、C++和电子表格等多种现代语言中实现。这些工具功能强大且相对精确，因此为不同背景和知识水平的个人提供了广泛接触计算机编程的途径。本文通过一系列基于ChatGPT的实验，探究该工具在需要推导、推断和解决问题的情况下生成有效电子表格公式及相关计算输出的能力。结果表明，在特定情境下，ChatGPT能够通过正确的推理、演绎和推断生成正确的电子表格公式。然而，当信息有限、不确定或问题过于复杂时，ChatGPT的准确性会下降，其推理、推断和演绎能力也会减弱。这还可能导致错误陈述和"幻觉"现象，从而破坏电子表格公式的生成过程。