USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Tyrone would like to use a function that returns a value that meets criteria in the second row of a table in his spreadsheet. Which function should he use?
|
|
INDEX
|
|
|
HLOOKUP
|
|
|
MATCH
|
|
|
VLOOKUP
|
Explanation:
Detailed explanation-1: -IF is one of logical functions that evaluates a certain condition and returns one value if the condition is TRUE, and another value if the condition is FALSE.
Detailed explanation-2: -Syntax. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK")
Detailed explanation-3: -The INDEX function returns a value or the reference to a value from within a table or range.
There is 1 question to complete.