USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following cell references is read as “cell A1 and D6?”
|
|
A1, D6
|
|
|
A1!D6
|
|
|
A1:D6
|
|
|
A1&D6
|
Explanation:
Detailed explanation-1: -A reference is a cell’s address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.
Detailed explanation-2: -A2:A10 is a cell reference that refers to the values in cells A2 to A10 (nine cells in the first column) and is the argument passed to the function. SUM returns the sum of any numbers included in these cells.
Detailed explanation-3: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
There is 1 question to complete.