Discuss the five guidelines for creating calculations in Excel.

What will be an ideal response?


* Know where the formulas should be. An Excel formula is created in the cell where the formula's results should appear. * Know exactly what cells and arithmetic operations are needed. Don't guess; make sure you know exactly what cells are involved before creating a formula. * Create formulas with care. Make sure you know exactly what you want a formula to accomplish before it is created. An inaccurate formula may have far-reaching effects if the formula or its results are referenced by other formulas. * Use cell references rather than values. The beauty of Excel is that whenever you change a value in a cell, any formula containing a reference to that cell is automatically updated. For this reason, it's important that you use cell references in formulas, rather than actual values whenever possible. * Determine what calculations will be needed. Sometimes it's difficult to predict what data will be needed within a worksheet, but you should try to anticipate what statistical information may be required.

Computer Science & Information Technology

You might also like to view...

At what IRQL does thread scheduling occur?

a) passive b) APC c) DPC/dispatch d) high

Computer Science & Information Technology

Describe the Equal per session policy that comes packaged with WSRM.

What will be an ideal response?

Computer Science & Information Technology

Explain how SYN Flood attacks can be controlled.

What will be an ideal response?

Computer Science & Information Technology

Cheryl has purchased and installed a contct management program on her non-networked laptop. She keeps getting an "Unable to connect to contact database-3256" error message. What should she do next?

a. Check for vendor documentation b. Call the company help desk c. Uninstall/reinstall the program d. Reboot the PC.

Computer Science & Information Technology