O'Reilly logo

A Guide to Microsoft Excel 2007 for Scientists and Engineers by Bernard Liengme

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Answers

Chapter 2

4. Some possible improvements include:

• Unlocking the input cells, then protecting the worksheet so that formulas are not accidentally changed or deleted. See Exercise 5 in Chapter 5.

• Having output cells not display zeros. This can be done with custom formatting. Alternatively, use Office to open the Excel Options dialog, locate the Advanced tab and in Display options for this worksheet, uncheck the box Show zeros in cells that have zero values.

• Using the ROUND function to have integer values displayed for Packages Needed.

• Write VBA code (Chapter 10) that would clear all the input cells when a control on the worksheet was clicked.

5. The formulas are shown in the following table. The factor 24 converts time in days to time ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required