answer.
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
viva [34]
2 years ago
15

On the "Compiled Information" tab, a VLOOKUP formula has been pre-entered into cell E3. This formula was written correctly, and

it uses references to the numbers in cells E1 through G1 to determine the correct index_number parameter. Fill in cells F1 and G1 with the correct index numbers, then copy the formula in cell E3 down to all the rows in columns E, F, and G. What number did you enter into cell G1?
Mathematics
1 answer:
Mashcka [7]2 years ago
6 0

Answer:

3

Step-by-step explanation:

Vlookup is a technique in excel which enables users to search for criterion values. It is vertical lookup function in excel which return a value from a different column. The formula for Vlookup function is:

=Vlookup'select cell you want to look up in' select cell you want to lookup from' select column index number' true/false.

where true is approximate match and false is exact match.

You might be interested in
Find the ratio of black cell phone covers sold to the total number of cell phones covers sold last week. Then explain its meanin
finlep [7]
The ratio here would be 4 to 18, in which 4 represents the number of black covers sold and 18 represents the total of covers sold.
5 0
2 years ago
Read 2 more answers
We can calculate eee, the amount of euros that has the same value as ddd u.S. Dollars, using the equation e=\dfrac{17}{20}de= 20
Cloud [144]

We are given eqaution: e=\frac{17}{20}d , where e the amount of euros and d is the value as U.S. Dollars.

We need to find number of euros for 1 U.S. Dollar.

Plugging d=1 in the given equation

We get

e=\frac{17}{20}(1)

On simplfying , we get

e=\frac{17}{20}

Dividing 17 by 20, we get 0.85.

Therefore, there would be 0.85 euro have the same value as 1 U.S. Dollar.

7 0
2 years ago
Read 2 more answers
The average thickness of books on a library shelf is 8.3 centimeters. The standard deviation is 0.6 centimeter. If 20% of the bo
jeka57 [31]

Answer:

8.8 cm

Step-by-step explanation:

-We know that the top 20% of the books are oversized.

-We therefore find the z-value of the top 20%:

z_{0.1}=8.4

#We substitute the z value in formula to solve X.

z=\frac{\bar  X-\mu}{\sigma}

Where

  • X is the minimum thickness of the book.

-Given \sigma=0.6 \ , \mu=8.3, the minimum thickness,X can be calculated as follows:

z=\frac{\bar  X-\mu}{\sigma}\\\\0.84=\frac{\bar X-8.3}{0.6}\\\\\bar X=0.84\times 0.6+8.3\\\\=8.804\approx 8.8\ cm

Hence, the minimum thickness of the oversized books is 8.8 cm

3 0
2 years ago
What is the value of b in the equation (y Superscript b Baseline) Superscript 4 Baseline = StartFraction 1 Over y Superscript 24
shusha [124]

The value of b is -6.

Explanation:

The expression is \left(y^{b}\right)^{4}=\frac{1}{y^{24}}

To determine the value of b, we shall solve the expression.

Applying exponent rule, \left(a^{b}\right)^{c}=a^{b c}, we get,

y^{4b}=\frac{1}{y^{24}}

Applying exponent rule, \frac{1}{a^{b}}=a^{-b}, we have,

y^{4b}=y^{-24}

The expression is of the form, a^{f(x)}=a^{g(x)} then f(x)=g(x)

Applying this rule, we get,

4b=-24

Dividing both sides by 4, we have,

b=-6

Hence, the value of b is -6.

4 0
2 years ago
Read 2 more answers
Which list correctly orders A, B, and C from least to greatest when A = –8, B = StartAbsoluteValue negative 6 EndAbsoluteValue,
vladimir2022 [97]

Answer:

A, B, C

Step-by-step explanation:

A = -8

B = |-6| = 6

C = |11| = 11

Least to greatest, negatives are the least and between 6 and 11, 11 is the greatest.

3 0
2 years ago
Read 2 more answers
Other questions:
  • Jennifer has a bag of chips that contains 2 red chips and 1 black chips. If she also has a fair die, what is the probability tha
    8·2 answers
  • Identify the relative maximum value of g(x) for the function shown below g(x)=7/x^2+5
    14·2 answers
  • What weight of dry substance is in 150g of a 3% substance solution? What weight of an 8% solution can we have with the same weig
    13·1 answer
  • If f(x) = [ x] -5 , what is f(8.6
    12·1 answer
  • erica is making necklaces and bracelets to se at the craft show. it takes her 3 hours to make a necklace and 2 hours to make a b
    9·2 answers
  • Which statement about proportional relationships is false?
    11·2 answers
  • Un equipo de fútbol se conforma de cuatro líneas de jugadores: portero (9%), defensas (37%), medios (27%) y delanteros (27%), do
    6·1 answer
  • The table represents the function f(x). A 2-column table with 7 rows. The first column is labeled x with entries negative 3, neg
    14·1 answer
  • Deena deposited $48 in a new bank account. After buying groceries, she had $19 left in the account. Then she paid her cell phone
    5·1 answer
  • ZEE సినిమాలు<br>next<br>పండగ చేసో see​
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!