How can you display the formulas instead of values in Excel?

To display the formulas instead of their resulting values in Excel, pressing Ctrl + ` (the grave accent key) is the correct method. This shortcut allows you to quickly toggle between viewing the results of formulas and the formulas themselves, making it an efficient way to check and verify the calculations within your spreadsheet.

When you use this shortcut, Excel switches the entire worksheet view to show all formulas. This is particularly useful for auditing or troubleshooting because it lets you see how each formula computes its result directly in the cells, rather than just the final output.

The other options suggest different methods, but they do not provide the same straightforward toggle functionality that the grave accent key offers. For instance, using the View tab or selecting options from the Ribbon may involve more navigation and clicking, which is less efficient than the direct keyboard shortcut.