USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
With a capital letter
|
|
|
With a capital letter and a number
|
|
|
with a number
|
|
|
we cannot identify it
|
Detailed explanation-1: -ROW is a function in Excel that returns the row number of a given cell. This function is especially useful when working with large data sets, as it can be used to easily identify the row number of a given cell or range of cells. To use the ROW function, simply enter the following into a cell: =ROW(cell reference).
Detailed explanation-2: -Each row is identified by a number. For example, the first row has an index 1, the second – 2 and the last – 1048576. Similarly, a column is a group of cells that are vertically stacked and appear on the same vertical line.
Detailed explanation-3: -Understanding cells A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
Detailed explanation-4: -Or click on any cell in the column and then press Ctrl + Space. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.