DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
method
|
|
|
function
|
|
|
exponent
|
|
|
None of the above
|
Detailed explanation-1: -Excel has prewritten formulas called functions to help simplify making complicated calculations. A function takes a value or values, performs an operation, and returns a result to a cell. The values that you use with a function are called arguments.
Detailed explanation-2: -A function is a prewritten formula. A function takes a value (or values), performs an operation, and returns a new value (or values.) Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.
Detailed explanation-3: -The values used in a formula can be values you type into the formula, or values that reside in other table cells, which you identify using cell references. Formulas use operators and functions to perform the calculations. An equal sign (=) always precedes a formula.