DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
constant
|
|
|
variable
|
|
|
formula
|
|
|
relative cell reference
|
Detailed explanation-1: -Constants: Numbers or text values entered directly into a formula, such as 2. 4. Operators: The ^ (caret) operator raises a number to a power, and the * (asterisk) operator multiplies numbers.
Detailed explanation-2: -Values: Values are numeric data that is entered into a cell. When data is formatted as the value type, it can be referred to in formulas and functions and used in calculations.
Detailed explanation-3: -Text data in a cell; also called a text value.
Detailed explanation-4: -There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.