Briefly discuss displaying the formulas version of a worksheet.

What will be an ideal response?


The values versionof the worksheet, shows the results of the formulas you have entered, rather than the actual formulas. Excel also can display and print the formulasversionof the worksheet, which shows the actual formulas you have entered, rather than the resulting values.

The formulas version is useful for debugging a worksheet. Debuggingis the process of finding and correcting errors in the worksheet. Viewing and printing the formulas version instead of the values version makes it easier to see any mistakes in the formulas.

When you change from the values version to the formulas version, Excel increases the width of the columns so that the formulas and text do not overflow into adjacent cells on the right. The formulas version of the worksheet, thus, usually is significantly wider than the values version.

Computer Science & Information Technology

You might also like to view...

Declare a stack template container to hold values of type double using the default container.

What will be an ideal response?

Computer Science & Information Technology

A system operator or a user identifies the program to be launched by issuing one or more __________ directly to the operating system.

a. instructions b. primitives c. commands d. none of the above

Computer Science & Information Technology

The first part of a file, the file ________, is how you identify the file when you save it.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Explain why a printer should be located where a user(s) has convenient access.

What will be an ideal response?

Computer Science & Information Technology