1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Luba_88 [7]
4 years ago
4

Create lookup functions to complete the summary section. In cell I6, 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 I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
Computers and Technology
1 answer:
alexandr1967 [171]4 years ago
4 0

Answer:

The vlookup formula is given below

(Vlookup,I5,A17:G20,9,1)

Please mark brainliest

Explanation:

In cell I6 write this formula (=Vlookup,I5,A17:G20,9,1)

While writing the formula press tab to select vlookup then select the value you want to look then add a comma then select the range of the data you want to look in then add comma then write the number of the column number you want the data from then add comma then there will be a choice of approximate or exact, select 1 or 2 accordingly and press enter.

You might be interested in
What can i use to erase data off computer and what name of it and steps
swat32
Is it mac i know how
5 0
3 years ago
How many Megabytes are there in a Gigabyte?
Tju [1.3M]
<span>
In quantities of data,
"kilo" = 2^10 = 1,024
"mega" = 2^20 = 1,048,576,
"giga" = 2^30 = 1,073,741,824 .

<span> <span /></span></span> <span>1 gig = 1,024 megs<span><span /></span></span>


7 0
4 years ago
Help plz its do today
TiliK225 [7]

Answer:

It is a good idea to consider supply and demand when considering your future career. This will give us an idea of how easy or difficult it is to enter the area and make a living from it.

Explanation:

8 0
3 years ago
Data validation is the process of a. preventing errors due to invalid data b. preventing errors due to incorrect Transact-SQL sy
professor190 [17]

Answer:

The correct answer to the following question will be "Option A".

Explanation:

Data validation seems to be an important part of every data managing mission unless you are in that area of information or data collection, data processing or planning to deliver the information to stakeholders.

  • Validation could be viewed as something of an integral component of your process instead of as a further move.
  • If your data set isn't correct from the beginning, then your outcomes will undoubtedly not be correct either. That's why the data needs to be checked or tested until it becomes used.

The other three options are not related to the given topic. So Option A is the right answer.

6 0
4 years ago
When you take the exit ramp off the expressway and merge onto the next road, you see yellow lines dividing the roadway. What do
viktelen [127]
<span>The yellow lines you see dividing the roadway is a indicator to divide the road for oncoming traffic. You shouldn't pass other cars because the flow of traffic is coming the other direction. Broken yellow lines in the middle of a roadway, means that you can pass. Double yellow lines in the middle of a roadway means that you can't pass on the road. </span>
4 0
4 years ago
Other questions:
  • Assume the following rules of associativity and precedence for expressions:
    7·1 answer
  • Are the advantages of a climate control in a vehicle
    10·2 answers
  • List three components of a computer system​
    10·1 answer
  • What does phishing mean?
    9·2 answers
  • I need help in creating a Java Program; To calculate the chapter from which you solve the programming exercise, below are the re
    7·1 answer
  • IOS 0R ANDR0ID ???
    13·1 answer
  • If a laptop is getting no power while plugged in, which hardware part often needs to be replaced?
    5·1 answer
  • If a computer truncatesall numbers to two decimal places, compute the error forthe following: 23.345+222.34911)0.12)0.01413)0.14
    15·1 answer
  • A file with a com extension is most likely to be a(n) ___ file.
    13·2 answers
  • A vpn is used primarily for which purpose?
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!