DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
columns
|
|
rows
|
|
active cells
|
|
cells
|
Detailed explanation-1: -Each row is identified by row number, which runs vertically at the left side of the sheet. Each column is identified by column header, which runs horizontally at the top of the sheet. A column is a vertical series of cells in a chart, table, or spreadsheet.
Detailed explanation-2: -Bars run horizontally and columns run vertically. Cell: A cell is a rectangular area formed by the intersection of a column and a row.
Detailed explanation-3: -Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.
Detailed explanation-4: -Rows are referenced by numbers that appear on the left and then run down the Excel screen. The first row is named row 1, while the last row is named 65536.
Detailed explanation-5: -The key difference between columns and rows is that a column arranges data vertically from top to bottom, while a row arranges data horizontally from left to right.