Chapter 10, Problem 1ICA

	A	B	C	D	E	F
1
2	45
3	meters
4	horses
5	canoes
6	99
7	four
8	equator
9	Dabo
10	33.3333

The worksheet displayed was designed to reflect on our understanding of the use of cell references.

Answer the following questions using the worksheet.

1. a. What is the cell address of the word “Dabo”?
2. b. Using cell concatenation with the ampersand operator, what formula would you type into a cell to create the word “fourequator”?
3. c. Using cell concatenation with the CONCAT function, what formula would you type into a cell to create the word “Dabocanoes”?

To determine

Find the cell address of the word “Dabo” in the given worksheet.

Answer to Problem 1ICA

The cell address of the word “Dabo” in the given worksheet is $\underset{\_}{\text{A}9}$.

Explanation of Solution

Given data:

The worksheet is given as follows.

Description:

Intersection between row and column on a spread sheet is called as a cell. Alphabets are used to represent column and numbers are used to represent row. Cell address is the selected cell in the spread sheet.

In the given worksheet, “Dabo” is typed in a cell, which is the intersection of column A and 9^th row of the spread sheet. Therefore, the cell address of the word “Dabo” in the given worksheet is $\text{A}9$.

Conclusion:

Hence, the cell address of the word “Dabo” in the given worksheet is $\underset{\_}{\text{A}9}$.

To determine

Write the required formula to create the word “fourequator” using cell concatenation with the ampersand operator.

Answer to Problem 1ICA

The required formula to create the word “fourequator” using cell concatenation with the ampersand operator is $\underset{\_}{\text{=\$A\$7\&\$A\$8}}$.

Explanation of Solution

Follow the steps to concatenate two cells with the ampersand operator.

Step 1:

Enter the given data in new worksheet as shown in Figure 1.

Step 2:

Type the formula “$\text{=\$A\$7\&\$A\$8}$” in cell B8 to concatenate cell A7 and A8 as shown in Figure 2.

From Figure 2, the desired result (that is fourequator) is obtained by using the formula $\text{=\$A\$7\&\$A\$8}$ in cell B8.

Conclusion:

Hence, the required formula to create the word “fourequator” using cell concatenation with the ampersand operator is $\underset{\_}{\text{=\$A\$7\&\$A\$8}}$.

To determine

Write the required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function.

Answer to Problem 1ICA

The required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function is $\underset{\_}{\text{=CONCATENATE}\left(\text{A9},\text{A5}\right)}$.

Explanation of Solution

Follow the below steps to concatenate two cells with the CONCAT function.

Step 2:

Type the formula “$\text{=CONCATENATE}\left(\text{A9},\text{A5}\right)$” in cell B9 to concatenate cell A9 and A5 as shown in Figure 3.

From Figure 3, the desired result (that is Dabocanoes) is obtained by using the formula $\text{=CONCATENATE}\left(\text{A9},\text{A5}\right)$ in cell B9.

Conclusion:

Hence, the required formula to create the word “Dabocanoes” using cell concatenation with the CONCAT function is $\underset{\_}{\text{=CONCATENATE}\left(\text{A9},\text{A5}\right)}$.