Wall Street Prep; Excel Crash Course Formulas Explained questions with accurate answers (verified)Graded A+

VLOOKUP Function - Answers-Definition: This functions searches for a value in the leftmost column of a table, and then returns a value om the same row from a column you specify in the table/array. Explanation: Begin by providing the desired lookup_value, then provide the table array followed by the XMATCH function to make the column index number dynamic, and lastly lookup/reference function a range lookup argument may be required to be inputted as a FALSE for lookup values that are text or numbers in a non-ascending order. INDEX Function - Answers-Definition: A lookup/reference function that uses the entire array and two other arguments that contain the row number of the desired cell (starting at the top of the array), and then a column number as the last argument (starting at the leftmost column of the array/table). Explanation: Begin by inputting the array/table to reference from, and then use XMATCH for both the row_num and Col_num arguments to make the function dynamic. OFFSET Function - Answers-Definition: Another lookup/reference function that uses a pivot point as the first argument and then has two more arguments for the number of rows after the pivot point where the desired cell is, and then an argument for the number of columns after the pivot point in which the desired cell is.