Remembering all of Excel's various formulas can be a pain, but ChatGPT is capable of producing them for you based on a simple request. Here's what you do.

Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct.

Download a free copy of the How-To Geek Advanced Excel Test workbook. After you click the link, you'll find the download button in the top-right corner of your screen.

Whether you've earned a data-related job promotion or recently learned some new Microsoft Excel skills, take the How-To Geek Intermediate Excel Test to put your expertise under the microscope!