John wants to see the formulas he has used in his spreadsheet but he does not want to see the results of

the formulas. How does he display his formulas?

A. Click on Trace Precedents.
B. Click Print Formulas.
C. Click on Show Formulas.
D. Click Evaluate Formulas

from reading my material Im guessing it's C. Show formulas?

It would be much easier for you to open a spread sheet and try it out.

I suggest you do some practical work because it will help you understand how it works, and it will help you recall the procedure in the future.

You are correct! To display formulas in a spreadsheet without seeing the results, John needs to click on "Show Formulas." Here's how he can do it:

1. Open the spreadsheet where the formulas are located.
2. Look for the "Formulas" tab in the ribbon at the top of the Excel window.
3. Click on the "Formulas" tab.
4. In the "Formula Auditing" group, there is a button labeled "Show Formulas." It usually appears as an icon with a set of brackets, similar to [=].
5. Click on the "Show Formulas" button.

Once John clicks on the "Show Formulas" button, the spreadsheet will display the formulas he has used instead of the results. This allows him to review and edit the formulas directly.

Please note that this explanation is based on Microsoft Excel. If John is using a different spreadsheet software, the steps may vary slightly.