Question

Q. Consider the following function used in spreadsheet application: getCellByPosition(1,3) What does 3 signify in the function?
a. Row number
b. Column number
c. Sheet number
d. None of these​

Answer 1

Answer:

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.

Answer 2

Answer:

option no. b - Column

Explanation:

please mark me as a brain list answer please and thanks my answer please anyone of u good in this world please mark me as a