USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
VOLATILE
|
|
|
EXPRESSION
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -TODAY() is a volatile function, which means that it updates itself continuously every time a worksheet is opened or changed. If a TODAY formula does not update automatically, most likely automatic recalculation is turned off in your workbook.
Detailed explanation-2: -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-3: -The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.
Detailed explanation-4: -VLOOKUP and HLOOKUP are both slow functions that are possibly volatile, which means that if something ever changes in your spreadsheet, all these functions will recalculate and it will really slow down everything. These are some of the issues with VLOOKUP as well as HLOOKUP.
Detailed explanation-5: -Indirect Function in Excel is considered one of the volatile functions that use a specific cell or string reference to carry out data manipulation operations.