The formula to put in E176 that will give me the sum of all the units sold by the indicated sales rep and product is:

Question attached

Answer :

There is no such formular

Explanation:

there is no such Formula I'm the options given. However the total product units sold by the sales representative for the period can be calculated in the excel sheet by adding up the cells with the units sold(cells F179,F180... to F186) and inserting the formula in the cell under total units sold by sales representative. So any change of figures in the cells added would reflect in the total units cell E176, if there is an additional figure for units sold in another cell, we could add this cell to formula in E176

none.

step-by-step explanation:

m

1

=

5

m1=5

b

=

−

1

b=-1

find the slope and y-intercept of the second equation.

tap for more

m

2

=

0

m2=0

b

=

−

6

b=-6

compare the slopes

m

m of the two equations.

m

1

=

5

,

m

2

=

0

m1=5,m2=0

compare the two slopes in the decimal form. if the slopes are equal, then the lines are parallel. if the slopes are not equal, then the lines are not parallel.

m

1

=

5

,

m

2

=

0

m1=5,m2=0