USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A column letter and a row number (ex:A3, F15..) are referred to as the
|
|
Status Area
|
|
|
Mode Indicator
|
|
|
Cell Address
|
|
|
Formula Bar
|
Explanation:
Detailed explanation-1: -Answer: The correct answer is cell’s column and row. A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet.
Detailed explanation-2: -Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.
Detailed explanation-3: -You can use the ADDRESS function to obtain the address of a cell in a worksheet, given specified row and column numbers. For example, ADDRESS(2, 3) returns $C$2. As another example, ADDRESS(77, 300) returns $KN$77.
There is 1 question to complete.