Question

Kofi Pharmaceutical company has the following

product materials A, B, C, D and E which sells
for $2 $8 $ 10 $9 and 11 respectively
There are five salesman working for the company
and the following statement gives the sales report
for each product item,
first salesman sold, 10, 5, 6, 7 and 8 respectively
second salesman sold ; 9, 8, 2, 6 and I respectively
Third salesman sold, 6, 3,5,7 and 2 respectively
Fourth salesman sold, 9, 8, 1,5 and to respectively
Firth salesman sold, 15, 20, 7, 9 and 3 respectively
Represent
the
information
above
in
Microsoft Excel​

Answer 1

Step-by-step explanation:

First, we note that there are two incorrectly posted data, namely

1. the last entry for the second salesman is I instead of 1. We assume 1 (one) was intended.

2. the last entry for the fourth salesman is "to". We assume that it is 10.

If they are different, it is only necessary to replace those entries with the correct ones, but the exercise remains valid.

PLEASE VERIFY THE QUESTION WORDING BEFORE POSTING AT ALL TIMES, and do NOT rely on automatic scanner conversions for math related problems.

The completed Excel spreadsheet would look like the attached image, or any similar/equivalent sheet.

The only calculated to be performed that needs to be done are contained in cells G4:G8 where the sum of products is calculated.

There are three ways to fill the calculating cells G4:G8

1. using long-hand

G4 can be written as:

+sum(B2*B4,C2*C4,D2*D4,E2*E4,F2*F4)

G5 can be written as:

+sum(B2*B5,C2*C5,D2*D5,E2*E5,F2*F5)

etc.

2. using repetition

We see that method one is very error-prone, in addition to being cumbersome to enter each formula.

If we rewrite G4 as

+sum(B$2*B4,C$2*C4,D$2*D4,E$2*E4,F$2*F4)

then we can copy and paste G4 to G5:G8, reducing the chances of error by four times. The "$" in B$2 means that when we copy, the address 2 (for price) will remain constant and not shifted by the translation.

3. Using the SUMPRODUCT() function.

Excel provides a specific function SUMPRODUCT() for multiplying arrays, or "inner product" as it is called in linear algebra.

All we need to do is to specify the arrays and Excel will do the multiplication.

We will fill G4 as follows:

+SUMPRODUCT(B$2:F$2,B5:F5)

Again, $2 means using row two even if we copy or move the contents of the cell.

Then cells G5:G8 can be copied and pasted from G4.

Note: one way to copy a cell to adjacent ones is to use dragging.

- highlight cell, note a dot at the right-bottom corner

- click on the dot and drag in the direction desired (down in our case), let go at the last cell.

This will be the equivalent of copy and paste.

There are other options on release of the mouse that you can discover by trying, or reading Excel documentation.