WALL STREET PREP EXCEL CRASH COURSE FORMULAS 2024/2025 STUDY EXAM QUESTIONS WITH CORRECT DETAILED ANSWERS GUARANTEED PASS | RATED A+

Document Content and Description Below

YEARFRAC Function - ANSWER-Definition: A function that return the proportion of the year between two given dates, the start_date and the end_date. An optional basis parameter can be used do represen... t the number of days per month/year used to calculate the proportion of the year. Optional Basis Parameters: 1. 0 - or Omitted = U.S. 30/360 2. 1 - Actual/Actual 3. 2 - Actual/360 4. 3 - Actual/365 5. 4 - European 30/360 Explanation: Simply input the start_date and the end_date with the desired basis argument and the function will output the proportion of the year between the two given dates. SUMPRODUCT Function - ANSWER-Definition: This function multiplies corresponding components in two or more arrays, and returns the sum of those products. Explanation: Begin by select the first array in the first argument and then the second array in the second argument in order for the function to do the operation. Extra: Criteria can also be embedded into this function for more specific cases, these are also known as BOOLEANS in which a variety of FALSE and TRUE results will come from the BOOLEAN and cause the operation to be more scenario based. DATE Function - ANSWER-Definition: A function that combines distinct year, month, and day elements into a function that will output the date. Explanation: Input the year, month, and day to get the date. DAY Function - ANSWER-Definition: returns the day portion of a date (a number between 1 and 31) MONTH Function - ANSWER-Definition: Outputs the month based on inputted serial number YEAR Function - ANSWER-Definition: Outputs the year based on inputted serial number. AND Function - ANSWER-Definition: A function that facilitates the type of analysis where you need to evaluate multiple arguments at once. This function evaluates to true if all arguments (logical_tests) and evaluates to false if one or more arguments are false. Typically embedded in IF statements/functions. Explanation: input the arguments you would like evaluated to get a TRUE output from the function or a FALSE output from the function. OR Function - ANSWER-Definition: Similar to the AND Function which evaluates to true if at least one argument (logical_test) is TRUE. Explanation: input the arguments you would like evaluated to get a TRUE output from the function or a FALSE output from the function. HLOOKUP Function - ANSWER-Definition: A lookup & reference function that searches for a value in top ROW of a table or an array of values, and then returns a value in the same column from a row you specify. Explanation: Begin by providing a lookup_value in the first argument of the function, then provide the table_array for function, and lastly use the XMATCH function to make the row_index_num 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. VLOOKUP Function - ANSWER-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. [Show More]

Last updated: 6 months ago

Preview 3 out of 6 pages