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.
You might also like to view...
At what IRQL does thread scheduling occur?
a) passive b) APC c) DPC/dispatch d) high
Describe the Equal per session policy that comes packaged with WSRM.
What will be an ideal response?
Explain how SYN Flood attacks can be controlled.
What will be an ideal response?
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.