FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Letters are used to designate each COLUMN’S location. The highlighted part of the spreadsheet is a column, and it is labeled B. In a spreadsheet the ROW is the horizontal space that is going across the window. Numbers are used to designate each ROW’S location.

Detailed explanation-2: -Worksheet: A worksheet is the grid of columns and rows that information is inputted into. In many spreadsheet applications (such as Microsoft Excel) one file–called a workbook–can contain several worksheets. Worksheets can be named using the sheet tabs of the bottom of the spreadsheet window.

Detailed explanation-3: -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-4: -A cell is the intersection point of a column and a row.

Detailed explanation-5: -(1) A horizontal set of data or components. In a graph, it is called the “x-axis.” Contrast with column. (2) A group of related and adjacent fields of data about a subject or transaction in a database. A collection of rows makes up a database file (table). Also called a “record” or “tuple.” See relational database.