DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
volatile
|
|
|
changeable
|
|
|
unstable
|
|
|
None of the above
|
Detailed explanation-1: -Volatile functions are functions in which the value changes each time the cell is calculated. The value can change even if none of the function’s arguments change.
Detailed explanation-2: -a term used to describe an excel function that is subject to change each time the worksheet is reopened, example is the NOW function. A cell address, such as $E$14, referenced in a formula that does not change based on the location of the cell that contains the formula.
Detailed explanation-3: -The INDEX function returns a value or the reference to a value from within a table or range. Play. There are two ways to use the INDEX function: If you want to return the value of a specified cell or array of cells, see Array form.
Detailed explanation-4: -This means that such a function cannot do any of the following: Insert, delete, or format cells on the spreadsheet. Change another cell’s value. Move, rename, delete, or add sheets to a workbook. Change any of the environment options, such as calculation mode or screen views.