DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell
|
|
|
Function
|
|
|
Relative Reference
|
|
|
Gallery
|
Detailed explanation-1: -Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column “C” in Row “3” would be cell C3.
Detailed explanation-2: -Detailed Solution A intersection of Row and column in a spreadsheet template is known as Cell.
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: -The intersection of row and column is called a cell. A cell is a rectangle that is formed when a column and a row intersect. A cell is formed when a row and a column meet at one point. Each cell in Excel has its own address, which is made up of the column letter and row number.
Detailed explanation-5: -The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells. To name a cell or range, highlight the cell or range you would like to name, type the name in the Name box, and press ENTER.