USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell reference
|
|
|
Named range
|
|
|
Operand
|
|
|
Scope
|
Detailed explanation-1: -The column letter and row number that identify a cell; also called the cell reference.
Detailed explanation-2: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.
Detailed explanation-3: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
Detailed explanation-4: -A cell reference is the set of coordinates that a cell occupies on a worksheet. It identifies the location of a cell in the spreadsheet. A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1.
Detailed explanation-5: -To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.