DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Letters
|
|
|
Numbers
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65, 536). These letters and numbers are called row and column headings.
Detailed explanation-2: -How are rows and columns labeled? In all spreadsheet programs including Microsoft Excel, rows are labeled using numbers (e.g., 1 to 1, 048, 576).
Detailed explanation-3: -Row labels allow you to choose the most important columns in a table. Row labels determine which columns are prominently displayed for that table, similar to a title. One image column and one non-image column can be used as labels. All tables have a non-image label.
Detailed explanation-4: -Rows are numbered numerically from top to bottom while Columns are referred by alpha characters from left to right. In Excel 2007, there are 65536 Rows which are numbered as 1, 2, 3, …
Detailed explanation-5: -On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box., and then under Print, select the Row and column headings check box .