Question

What are the differences between Rows and Columns?

What is the address of a cell which comes at the

intersection of 10th row and 10th column?​

Answer 1

Answer:

Rows are a group of cells arranged horizontally to provide uniformity. Columns are a group of cells aligned vertically, and they run from top to bottom. Although the main reason for both rows and columns is to bifurcate groups, categories and so on, there is a fine line of difference between the two.

The cell ADDRESS function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or absolute format and can be used to construct a cell reference inside a formula.

As a financial analyst, cell ADDRESS can be used to convert a column number to a letter, or vice versa. We can use the function to address the first cell or last cell in a range.

Formula

=ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])

The formula uses the following arguments:

Row_num (required argument) – This is a numeric value specifying the row number to be used in the cell reference.Abs_num Returns this type of reference

1 or omitted Absolute

2 Absolute row; relative column

3 Absolute column; relative row

4 Relative

4. A1(optional argument) – This is a logical value specifying the A1 or R1C1 reference style. In R1C1 reference style, both columns and rows are labeled numerically. It can either be TRUE (reference should be A1) or FALSE (reference should be R1C1).

When omitted, it will take on the default value TRUE (A1 style).

Sheet_text (optional argument) – Specifies the sheet name. If we omit the argument, it will take the current worksheet.

Answer 2

Rows are a group of cells arranged horizontally to provide uniformity. Columns are a group of cells aligned vertically, and they run from top to bottom. Although the main reason for both rows and columns is to bifurcate groups, categories and so on, there is a fine line of difference between the two.

If it really helps you . Please mark me as the brainliest