22,895 views
33 votes
33 votes
Help me to answer this​

Help me to answer this​-example-1
User Parameter
by
3.0k points

1 Answer

11 votes
11 votes

Answers are in bold

  1. 1*2; C2
  2. 7+A6-5; undefined
  3. (5*3)-8; D2
  4. 9/3; C1
  5. 7+10-9+8; undefined

Ignore the non-bold values because they are there to number each problem 1 through 5 (rather than be part of the numeric answers).

=======================================================

Step-by-step explanation:

Problem 1

The notation =C3*C2 means we multiply the numbers in cells C3 and C2. A cell like C3 means we look at column C and row 3. The value 1 is in cell C3. The value 2 is in C2. Therefore =C3*C2 becomes 1*2 = 2. The result 2 is in cell C2.

----------------------

Problem 2

According to the table:

  • D2 = 7
  • A6 = undefined
  • D1 = 5

I mentioned A6 is undefined because the table only goes to row 3, and not row 6. I'm not sure if this is a typo or intentional. Since A6 is undefined, the result of =D2+A6-D1 is also undefined.

----------------------

Problem 3

The table shows

  • D1 = 5
  • C1 = 3
  • B3 = 8

So, =(D1*C1) - B3 becomes (5*3)-8 and that fully simplifies to 7, which is found in cell D2.

----------------------

Problem 4

We have

  • D3 = 9
  • C1 = 3

Therefore, =D3/C1 = 9/3 = 3 which is found in cell C1

----------------------

Problem 5

  • D2 = 7
  • B1 = 10
  • D3 = 9
  • B3 = 8

So,

=D2+B1-D3+B3 = 7+10-9+8 = 16

which unfortunately is not found in any of the cells of the table.

The location of 16 is undefined.

User Serdmanczyk
by
2.4k points