USING MICROSOFT EXCEL
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: -Understanding cells A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3).
Detailed explanation-4: -These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number. For example, D50 refers to the cell at the intersection of column D and row 50.
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.