USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ranges
|
|
|
values
|
|
|
indices
|
|
|
borders
|
Detailed explanation-1: -Understanding cells Every worksheet is made up of thousands of rectangles, which are called 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-2: -Click Home > the Borders arrow, and then pick the border option you want. Add a border line style-Click the Borders arrow > Border Style, and then pick a line style option.
Detailed explanation-3: -Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.
Detailed explanation-4: -What are cell borders in Excel? Border is a line around a cell or a block of cells in Excel. Generally, cell borders are used to accent a specific section of a spreadsheet to make it stand out. For example, you can insert a border to draw attention of viewers to totals or other important data on the sheet.