USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Named
|
|
|
Consolidated
|
|
|
Name Ranged
|
|
|
Nested
|
Detailed explanation-1: -Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function.
Detailed explanation-2: -To evaluate more than one condition and return different values depending on the results, you nest multiple IFs inside each other. Though very popular, the nested IF statement is not the only way to check multiple conditions in Excel.
Detailed explanation-3: -A nested formula in Excel is a function that uses another function in its calculations. In other words, it’s combining formulas. In this tutorial, we’ll go over examples of nested formulas in Excel.
Detailed explanation-4: -A nested function is a function that is completely contained within a parent function. Any function in a program file can include a nested function.