DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Circles
|
|
|
Letters
|
|
|
Numbers
|
|
|
Stars
|
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. To refer to a cell, type the column letter followed by the row number.
Detailed explanation-2: -Columns are designated by letters while rows are designated by numbers.
Detailed explanation-3: -Use the ROW function to number rows In the first cell of the range that you want to number, type =ROW(A1). The ROW function returns the number of the row that you reference. For example, =ROW(A1) returns the number 1. across the range that you want to fill.
Detailed explanation-4: -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-5: -A row is a horizontal line of cells. A column is a vertical line of cells. Numeric values represent rows. Alphabets represent columns.