DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Formulas are usually based on functions.
|
|
|
Formulas are usually based on location.
|
|
|
Formulas are usually based on using an equal sign.
|
|
|
Formulas are usually based on equations.
|
Detailed explanation-1: -In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.
Detailed explanation-2: -A reference identifies a cell or a range of cells on a worksheet, and tells Excel for the web where to look for the values or data you want to use in a formula. You can use references to use data contained in different parts of a worksheet in one formula or use the value from one cell in several formulas.
Detailed explanation-3: -Show Formulas option on the Excel ribbon In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away.