USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1. A range is a group of two or more cells in a worksheet.
Detailed explanation-2: -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-3: -The ADDRESS function returns the address for a cell based on a given row and column number. For example, =ADDRESS(1, 1) returns $A$1. ADDRESS can return a relative, mixed, or absolute reference, and can be used to construct a cell reference inside a formula.
Detailed explanation-4: -The intersection of a row and a column is called a cell. A cell is identified by a combination of a letter and a number corresponding to a particular location within the spreadsheet. For example, the first cell of a worksheet is identified as A1 as it shown in Figure 2.2 at row 1 and column (A).