- Study guides, Class notes & Summaries
Looking for the best study guides, study notes and summaries about ? On this page you'll find 1 study documents about .
1 results
Exam (elaborations)
Cgs2518 Exam 1, Pt 2, Excel Portion
Insert a function to display the current date: - answer-=TODAY() 
 
Enter a lookup function to display the interest rate of the loan. The function should reference the borrowers credit rating and the table array in range A15:C18. Include the range_lookup argument to ensure an exact match. - answer-=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) 
 
Actual example) 
=VLOOKUP(C7, A15:C18, 3, FALSE) 
 
*only use false if he asks for an EXACT match, if he does not mention it, ju...