USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The column
|
|
|
The cell
|
|
|
The row
|
|
|
None of the above
|
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: -Excel mixed cell reference. A mixed cell reference in Excel is a reference where either the column letter or a row number is fixed. For example, $A1 and A$1 are mixed references.
Detailed explanation-3: -For example, if you want to refer to the top-left cell in a worksheet in Excel, you would use A1 – where A tells us that it’s in column A, and 1 tells us that it’s in the first row. As I mentioned, A1 is the default reference style notation in Excel.
Detailed explanation-4: -1. A column is a vertical series of cells in a chart, table, or spreadsheet. Below is an example of a Microsoft Excel spreadsheet with column headers (column letter) A, B, C, D, E, F, G, and H. As you can see in the image, the last column H is highlighted in red, and the selected cell (D8), is in the D column.