Differentiate between the use of a function and a formula in a table. When would one be preferable to another? Provide several examples.
What will be an ideal response?
A function is a built-in formula that summarizes a calculation in an abbreviated fashion. For example, the function =SUM(ABOVE) totals all cells in the column above, regardless of how many cells are involved. If a column contains more than a few rows of numeric data, a function is typically preferable to a formula, as the formula would have to list each cell involved. A function does not exist for every possible formula, however, In many cases, a formula is the only alternative to representing a calculation and should be used instead of a function.
You might also like to view...
A domain ____________________ is a unique address used for identifying a computer (often a Web server) on the Internet.
Fill in the blank(s) with the appropriate word(s).
When using the get method to submit form data, the form data is separated from the URL by a colon. (:).
Answer the following statement true (T) or false (F)
Outline six useful policies to minimize computer-related waste and mistakes.
What will be an ideal response?
Make sure to enter all cell reference in upper case when putting them in formulas.
Answer the following statement true (T) or false (F)