USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
rows begin a series of numbers.
|
|
|
rows begin with a column number
|
|
|
rows are placed vertically on your page
|
|
|
None of the above
|
Detailed explanation-1: -The row numbers are arranged vertically on the worksheet, ranging from 1-1, 048, 576 (you can have a total of 1, 048, 576 rows in Excel). The rows themselves run horizontally on a worksheet. Data is placed horizontally in the table, and goes across from left to right.
Detailed explanation-2: -Row runs horizontally while Column runs vertically. Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet.
Detailed explanation-3: -Unlike other Microsoft 365 programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
Detailed explanation-4: -These letters and numbers are called row and column headings. 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.