USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
FieldName
|
|
formulas
|
|
name ranges
|
|
n
|
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: -In computer programming, a nested function (or nested procedure or subroutine) is a function which is defined within another function, the enclosing function.
Detailed explanation-3: -The VLOOKUP or Vertical Lookup function is used when data is listed in columns. This function searches for a value in the left-most column and matches it with data in a specified column in the same row. You can use VLOOKUP to find data in a sorted or unsorted table.
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.