DATABASE FUNDAMENTALS
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: -Formulas are defined as a statement written by any user, either simple or complex whereas a function is a type of formula which is pre-defined. On the other hand, functions are predefined formulas that are already there in the sheet.