1.Create lookup functions to complete the summary section. In cell 16, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell 15 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell 15 and the range A17:G20. 2.Copy the formula from cell 16 to the range 17:111 and then edit the formula in cell 17 to return the value in the 3rd column, the formula in cell 18 to return the value in the 4th column, the formula in cell 19 to return the value in the 5th column, the formula in cell 110 to return the value in the 6th column, and the formula in cell 111 to return the value in the 7th column.

Primary tech skills are skills that are necessary for success in online education

Fill in the following program so that it will correctly calculate the price of the orange juice the user is buying based on the buy one get one sale.#include //main functionint main() { int cartons; float price, total; //prompt user for input information printf("what is the cost of one container of oj in dollars? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & price); printf("how many containers are you buying? \n"); scanf(" [ select ] ["%d", "%c", "%f", "%lf"] ", & cartons); if ( [ select ] ["cartons / 2", "cartons % 1", "cartons % 2", "cartons % price", "cartons / price", "cartons / total"] [ select ] ["=", "==", "! =", "< =", "> =", "< "] 0) total = [ select ] ["price * cartons", "cartons * price / 2 + price", "(cartons / 2) * price", "cartons / (2.0 * price)", "(cartons / 2.0) * price + price", "((cartons / 2) * price) + price"] ; else total = ((cartons / 2) * price) + price; printf("the total cost is $%.2f.\n", total); return 0; }

Jason works as an accountant in a department store. he needs to keep a daily record of all the invoices issued by the store. which file naming convention would him the most?