USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Formula vs Function in Practice Just know that technically, a function is a piece of code that executes a predefined calculation, while a formula is something you create yourself.
Detailed explanation-2: -All functions have a dependent variable. All functions have an independent variable. The range of a function includes its domain. A vertical line is an example of a functional relationship.
Detailed explanation-3: -You can create a formula to calculate values in your worksheet by using a function. For example, the formulas =SUM(A1:A2) and SUM(A1, A2) both use the SUM function to add the values in cells A1 and A2. Formulas always start with an equal sign (=).
Detailed explanation-4: -The OR function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE. One common use for the OR function is to expand the usefulness of other functions that perform logical tests.