EXAM 2 REVIEW BUS 1350 ANCIRA QUESTIONS & ACCURATE CORRECT ANSWERS

EXAM 2 REVIEW BUS 1350 ANCIRA
QUESTIONS & ACCURATE CORRECT
ANSWERS
VLOOKUP - Correct Answer ✔✔ It matches a provided value in the first column of a
data table and returns a value from a specified column in that row.

lookup_value - Correct Answer ✔✔ It represents the 'WHAT' - the specific value you
want Excel to search for in the table.

table_array - Correct Answer ✔✔ It represents the 'WHERE' - the range of cells where
you want Excel to look for the lookup_value.

col_index_num - Correct Answer ✔✔ It is the 'LOCATION OF THE RETURN VALUE' -
the column number within the table_array from which to retrieve the result.

range_lookup - Correct Answer ✔✔ It determines 'HOW' Excel should evaluate the
lookup_value: with either an Exact Match (FALSE) or an Approximate Match (TRUE).

Exact Match (FALSE) - Correct Answer ✔✔ For text values and specific numerical
values where you need an exact match to the lookup_value.

Approximate Match (TRUE) - Correct Answer ✔✔ For ranges of numbers when an
exact match isn't necessary, and values are in ascending order.

First column requirement - Correct Answer ✔✔ VLOOKUP only searches vertically in
the first column to find the lookup_value before returning data from another specified
column.

VLOOKUP is - Correct Answer ✔✔ vertical lookup and is used when your data is
located in the first column of a table

HLOOKUP is - Correct Answer ✔✔ horizontal lookup and is used when your data is
located in the first row of a table

what function can be used in place of a V,Hlookup - Correct Answer ✔✔ index-match

Xlookup can be used in place of what - Correct Answer ✔✔ used in place of an index-
match, Hlookup, and sometimes an Xlookup

Logical test - Correct Answer ✔✔ An equation with comparison operators that can be
evaluated as true or false, also known as a logical expression.

, Decision tree in Excel - Correct Answer ✔✔ A diagramming tool that helps break down
potential decisions in a structured format for entering into Excel.

IF function - Correct Answer ✔✔ Used when you have only one test or condition.

Nested IF function - Correct Answer ✔✔ A function used when there is more than one
test or condition.

Number of IF functions in a nested IF statement - Correct Answer ✔✔ The number of IF
functions is always one less than the number of outcomes.

Closing parentheses in a nested IF function - Correct Answer ✔✔ The number of
parentheses needed to close the function is the same as the number of IF functions
used.

AND function - Correct Answer ✔✔ Used when all conditions must be true for a result to
be true.

AND function return value - Correct Answer ✔✔ Returns TRUE if all conditions are met;
returns FALSE if any condition is not met.

OR function - Correct Answer ✔✔ Used when at least one condition must be true for a
result to be true.

OR function return value - Correct Answer ✔✔ Returns TRUE if at least one condition is
true; returns FALSE if none of the conditions are met.

NOT function - Correct Answer ✔✔ Reverses the logical value of a condition, returning
TRUE if the condition is false, and FALSE if true.

Use of NOT function - Correct Answer ✔✔ When you have multiple options that meet
the criteria but want to exclude just one.

IFS function in Office 365 - Correct Answer ✔✔ A function that checks multiple
conditions and returns a result for the first true condition.

Conditions tested by IFS function - Correct Answer ✔✔ Up to 127 different conditions.

Default outcome in IFS function - Correct Answer ✔✔ Set by making the last
logical_test argument TRUE with a default outcome for when no other conditions are
met.

IFS function return when no conditions met - Correct Answer ✔✔ Returns #N/A if none
of the IFS conditions are met and no default is set.