Robyn is using lookup functions in her Excel 2016 worksheet. Which formula uses the correct syntax? =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup) =VLOOKUP(lookup_value, table_array, col_index_num, value) =VLOOKUP(table_array, lookup_value, col_index_num, value)

Write a program that prints the day number of the year, given the date in the form month-day-year. for example, if the input is 1-1-2006, the day number is 1; if the input is 12-25-2006, the day number is 359. the program should check for a leap year. a year is a leap year if it is divisible by 4, but not divisible by 100. for example, 1992 and 2008 are divisible by 4, but not by 100. a year that is divisible by 100 is a leap year if it is also divisible by 400. for example, 1600 and 2000 are divisible by 400. however, 1800 is not a leap year because 1800 is not divisible by 400.