USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
columns begin with a column letter
|
|
|
columns begin a series of numbers.
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Columns run vertically in the worksheet, and the data goes from up to down. Column A is the first column in Excel. In the example below, you can see that the whole column with header B is selected by pressing/clicking on the letter at the top.
Detailed explanation-2: -How are columns and rows labeled? All spreadsheet programs, including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1, 048, 576). All columns are labeled with letters starting with the letter A and then incrementing by a letter after the final letter Z.
Detailed explanation-3: -Columns run vertically and Bars run horizontally. Data: Data refers to the type of information that can be stored in the cells of a spreadsheet. Spreadsheet data types include values (numbers), labels, formulas and functions.
Detailed explanation-4: -On the Excel menu, click Preferences. Under Authoring, click Calculation . Clear the Use R1C1 reference style check box. The column headings now show A, B, and C, instead of 1, 2, 3, and so on.
Detailed explanation-5: -Understanding cells 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.