Enter a formula in cell c8 that divides the sum of cells c5 through c7 by cell c4. write the formula so that when you copy it to cells d8: f8, excel adjusts all the cell references according to the destination cells. verify your formula by checking it with the values found in cells c8, d8, e8 and f8 in figure 3-81. enter a formula in cell g5 that divides the sum of cells c5 through f5 by cell b5. write the formula so that when you copy the formula to cells g6 and g7, excel adjusts all the cell references according to the destination cells. verify your formula by checking it with the values found in cells g5, g6, and g7 in figure 3- 81. enter a formula in cell c9 that divides the sum of cells c5 through c7 by cell c4. write the formula using an absolute cell reference so that when you copy the formula to cells d9 f9, cell c4 remains absolute. verify your formula by checking it with the values found in cells c9, d9, e9 and f9 in figure 3-81. enter a formula in cell h5 that divides the sum of cells c5: f5 by cell b5. write the formula using an absolute cell reference so that when you copy the formula to cells h6 and h7, cell b5 remains absolute. verify your formula by checking it with the values found in cells h5, h6, and h7 in figure 3- 81. apply the worksheet name, cell references, to the sheet tab and apply the blue standard color to the sheet tab. if requested by your instructor, add a dash followed by your name to the worksheet title in cell a1. save the workbook using the file name, apply 3-1 absolute cell references complete. submit the revised workbook as specified by your instructor. how would you rewrite the formula in cell h5 using relative and mixed cell references only, to come up with the same result as showing in figure 3- 81, and to produce the results currently showing in cells g6 and g7 in cells h6 and h7 when the formula in cell h5 is copied to those cells?

step-by-step explanation:

to find if any function is an inverse of the other, put the first equation in as x in the next one. then simplify and solve. if at the end you get the statement y = x, then it is an inverse. if you get anything else, it is not.

a.   we have two

lines:   y = 4-x   and  

y = 8-x^-1

given two simultaneous equations that are both to be

true, then the solution is the points where the lines cross. the intersection is

where the two equations are equal. therefore the solution that works for both

equations is when

4-x = 8-x^-1

this is where the two lines will cross and that is the

common point that satisfies both equations.

b.   4-x = 8-x^-1

  x           4-x       8-x^-1

-3           7        

8.33

-2           6         8.5

-1           5         9

  0           4        

-

  1           3        

7

  2           2        

7.5

  3           1         7.67

the table shows that none of the x values from -3 to 3 is

the solution because in no case does

4-x = 8-x^-1

to find the solution we need to rearrange the equation to

find for x:

4-x = 8-x^-1

multiply both sides with x:

4x-x^2 = 8x-1

x^2+4x-1=0

x= -4.236, 0.236

therefore there are two points that satisfies the

equation.

find y:  

x=-4.236

y = 4-x   = 4 – (-4.236)

= 8.236

y = 8-x^-1 =   .236)^-1

= 8.236

x=0.236

  y = 4-x   = 4 – (0.236) = 3.764

y = 8-x^-1 =   8-(0.236)^-1

= 3.764

thus the two lines cross at 2 points:

(-4.236, 8.236) & (0.236, 3.764)

c.   to solve

graphically the equation 4-x = 8-x^-1

we would graph both lines: y = 4-x   and   y

= 8-x^-1

the point on the graph where the lines cross is the

solution to the system of equations.

just graph the points on part b on a cartesian coordinate

system and extend the two lines.   the

solution is, as stated, the point where the two lines cross on the graph.

step-by-step explanation:

mark brainliest!

hc ghfrfgb

step-by-step explanation:

gedfgb nbgfrezrdfgbn bgfderdfgbvn bvfdsvcb bvfdfgb gfdgb gfr