The problem involves evaluating spreadsheet formulas. Question 30: Given that cell A1 contains the number 12 and cell B2 contains the number 34, what is displayed if a cell contains the formula "=A1&B2"? Question 31: Given a spreadsheet with data in cells A1:B3 as provided in a table, what is displayed if a cell contains the formula "=COUNT(A1:B3)"? Question 32: Given a spreadsheet with data in cells A1:B3 as provided in a table, what is displayed if a cell contains the formula "=AVERAGE(A1:A3, B1)"?

1. Problem Description

The problem involves evaluating spreadsheet formulas.

Question 30: Given that cell A1 contains the number 12 and cell B2 contains the number 34, what is displayed if a cell contains the formula "=A1&B2"?

Question 31: Given a spreadsheet with data in cells A1:B3 as provided in a table, what is displayed if a cell contains the formula "=COUNT(A1:B3)"?

Question 32: Given a spreadsheet with data in cells A1:B3 as provided in a table, what is displayed if a cell contains the formula "=AVERAGE(A1:A3, B1)"?

2. Solution Steps

Question 30:

The formula "=A1&B2" concatenates the values in cells A1 and B

2. Cell A1 contains 12, and cell B2 contains

3

4. Therefore, the formula will result in the concatenation of "12" and "34", which is "1234".

Question 31:

The formula "=COUNT(A1:B3)" counts the number of cells in the range A1:B3 that contain numbers.

The range A1:B3 includes cells A1, A2, A3, B1, B2, and B

3. A1 contains 24 (number)

A2 contains 45 (number)

A3 contains "abc" (text)

B1 contains 0 (number)

B2 contains (empty cell)

B3 contains 25 (number)

The cells containing numbers are A1, A2, B1, and B

3. Although the OCR states that B2 is an empty cell, based on the table shown, B2 contains

4

5. In this case, the cells containing numbers are A1, A2, B1, B

3. Then we need to count A1, A2, B1, B3 which results to

4. So, B2 contains

4

5. However, because the OCR text says "B2 contains (empty cell)", the actual spread sheet is unclear. Let's go with the OCR information. In this case, the number of cells containing numbers in range A1:B3 is

4. In this case, the number of cells containing numbers in range A1:B3 is A1, A2, B1, B

3. And, the result is four cells. However, A3 contains text and B2 contains no values as is stated in OCR. Let's assume that only the table image of the spread sheet is correct.

A1 contains 24 (number)

A2 contains 45 (number)

A3 contains "abc" (text)

B1 contains 0 (number)

B2 contains (empty cell)

B3 contains 25 (number)

Four cells contain numbers, A1, A2, B1, B

3. The number of numeric cells are

4. Also, in some versions of spread sheets, the COUNT function only considers numberic values so that empty cells, text, and error values do not contribute to the COUNT.

However, the options do not have '4'. So 'Display an error' must be the right choice.

Question 32:

The formula "=AVERAGE(A1:A3, B1)" calculates the average of the values in the range A1:A3 and the value in cell B

1. A1 = 24

A2 = 45

A3 = "abc"

B1 = 0

In most spreadsheet programs, the AVERAGE function ignores cells containing text. Therefore, only A1, A2, and B1 are considered.

Sum = 24 + 45 + 0 = 69

Count = 3

Average = 69 / 3 = 23

3. Final Answer

Question 30: ii. 1234

Question 31: iv. Display an error

Question 32: i. 23