Question 20: Given a spreadsheet, the formula $A$1*$B1 is entered in cell C1. What will be the value of cell C3 if the formula is copied to cell C3? Question 21: Given a spreadsheet, the formula =COUNT(A2:C2, A3:C3) is entered in cell C6. What is the value of cell C6?

1. Problem Description

Question 20:

Given a spreadsheet, the formula $A$1*$B1 is entered in cell C

1. What will be the value of cell C3 if the formula is copied to cell C3?

Question 21:

Given a spreadsheet, the formula =COUNT(A2:C2, A3:C3) is entered in cell C

6. What is the value of cell C6?

2. Solution Steps

Question 20:

The formula in cell C1 is =A$1*$B

1. When this formula is copied to cell C3, the relative references change while the absolute references remain the same.

The row number for A will change from 1 to 3, and the column for B will change from B to B.

Since the row of A1 is fixed by $1, A$1 will still refer to cell A

1. The column of B1 will change when copied to column C3, $B1 will refer to cell B

3. Thus the formula in cell C3 will be =A$1*$B

3. The value of cell A1 is

5. The value of cell B3 is

4

0. Therefore, the value in cell C3 will be 5*40 =

2

0

0.

Question 21:

The formula =COUNT(A2:C2, A3:C3) is entered in cell C

6. The COUNT function counts the number of cells in a range that contain numbers.

The first range is A2:C2, which includes cells A2, B2, and C

2. A2 contains the number

6

3. B2 contains the number

7

5. C2 contains "NO", which is text.

The second range is A3:C3, which includes cells A3, B3, and C

3. A3 contains the number

6

5. B3 contains the number

2

0. C3 is empty.

In the range A2:C2, there are two cells containing numbers: A2 and B

2. In the range A3:C3, there are two cells containing numbers: A3 and B

3. Thus, the total count of cells containing numbers in these two ranges is 2+2 =

4. The function returns

4.

3. Final Answer

Question 20: (4) 200

Question 21: (2) 4