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

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 17:20, dylanolmeda9

The thickness of a part is to have an upper specification of 0.925 and a lower specification of 0.870 mm. the average of the process is currently 0.917 with a standard deviation of 0.005. determine the percentage of product above 0.93 mm.

Answers: 3

continue

Computers and Technology, 23.06.2019 09:00, Riddledjam44623

Before you record your own voice, you should a. record other people's voices b. warm up and practice difficult names c. listen to your favorite songs d. read a transcript of a good radio news segment

Answers: 1

continue

Computers and Technology, 23.06.2019 12:00, clevelandjaniya1

Which of these is a benefit of using objects in a powerpoint presentation? a. collaborators can create the external files while you create and edit the slide show. b. you can easily change the theme and design of the presentation. c. you can have older data in the source file while having up-to-date data in the presentation. d. collaborators can easily share the presentation.

Answers: 2

continue

Computers and Technology, 24.06.2019 00:30, Auttyrain3929

Afiling system in which an intermediary source of reference, such as a file card, must be consulted to locate specific files is called a(n) system. a. shelf filing b. direct filing c. indirect filing d. shingling

Answers: 1

continue

Do you know the correct answer?

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