Add formulasto complete the table of hours used. In cell B17, create a nested formula with the IFand SUMfunctions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20.

in cell b13, create a formula using the vlookup function that looks up the value from cell a11 in the range a5:b7, returns the value in column 2, and specifies an exact match. copy the formula to cell e13.

Include a formula in the last column on the third row to calculate 75% of the Cost. The formula is =0.75*b3. You do not need to select a number format. Include a formula in the next two rows of the same column, adjusting the row reference as necessary.

Enter a formula in cell C8 that divides the product of cells C5 through C7 by cell C4. Write theformula so that when you copy the formula to cells D8:F8, Excel adjusts all the cell referencesaccording to the destination cells.

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20

The line of code sfosurvey [3,7] will return O a. The entry in the third row and seventh column O b. The entry in the seventh row and third column c. The seventh entry of the thid variable O d. The third entry of the seventh entry O e. Nothing

Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C9 to the range C9:C54. Hide column B that contains the codes.

DO NOT COPY FROM OTHER WEBSITES  Correct and detailed answer will be Upvoted else downvoted. Thank you!

1. Use the VLOOKUP function in MS Excel application to enter the miles flown column by looking up the frequent-flier number. (Hint: If done correctly with absolute references, you should be able to enter the VLOOKUP formula in the first cell in the “miles flown” column and copy it down for all the cells.) 2. Create another VLOOKUP function to fill in the phone number for Mark Dumont automatically in Cell G3. 3. Create any logical function by using one of the following logical operators: AND, OR, NOT. Highlight the data in standard yellow color where this logical function is used on the spreadsheet. 4. Create any “IF” function that uses a simple “named range” in calculation based on the example we covered in class. Please highlight the data in standard blue color on the spreadsheet that uses this “IF” function. 5. Use conditional formatting to highlight top 10 highest-earning frequent fliers with an orange color. 6. Use conditional formatting to highlight all frequent fliers who have…

Update the validateForm() function to verify the phone number is exactly 10 characters long. Display "Phone number is invalid" in the console log if the phone number does not meet the requirements. Use the preventDefault() function to avoid submitting the form when the input is invalid.