Computers and Technology, 09.11.2021 19:30 fredbear373

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.

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 09:50

Allison and her group have completed the data entry for their spreadsheet project. they are in the process of formatting the data to make it easier to read and understand. the title is located in cell a5. the group has decided to merge cells a3: a7 to attempt to center the title over the data. after the merge, allison points out that it is not centered and looks bad. where would the title appear if allison unmerged the cells in an attempt to fix the title problem?

Answers: 2

Answer

Computers and Technology, 23.06.2019 17:00

The camera still is bad even with the new iphone xr and especially in low light it is even worst because you can see the pixels more if its in low light. if all you apple customers want apple to fix this then lets fill there feedback with complaints about the

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:40

Johnson enterprises uses a computer to handle its sales invoices. lately, business has been so good that it takes an extra 3 hours per night, plus every third saturday, to keep up with the volume of sales invoices. management is considering updating its computer with a faster model that would eliminate all of the overtime processing.

Answers: 2

Answer

Computers and Technology, 23.06.2019 20:00

What software programs are used to to create professional publication? a.) graphics programs b.) word processors c.) page layout programs d.) spreadsheet programs

Answers: 2

Answer

You know the right answer?

1.Create lookup functions to complete the summary section. In cell 16, create a formula using the VL...

Questions