DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
line
|
|
Column
|
|
Sel
|
|
Sheet
|
|
Range
|
Detailed explanation-1: -Gridlines: Gridlines are the horizontal and vertical lines on the screen that separate cells in a spreadsheet. Gridlines typically do not print unless the option is set in the layout options of the spreadsheet. Labels: Labels refer to text that is typed into the cells of a spreadsheet.
Detailed explanation-2: -Gridlines in Excel[1] are the horizontal and vertical gray lines that differentiate between cells in a worksheet. The gridlines guide users to differentiate between the specific cells and read the data in an organized manner.
Detailed explanation-3: -A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns. Rows are typically labeled using numbers (1, 2, 3, etc.), while columns are labeled with letters (A, B, C, etc). Individual row/column locations, such as C3 or B12, are referred to as cells.
Detailed explanation-4: -Row. Horizontal sections of a spreadsheet. Identified by a number. Column. Vertical sections of a spreadsheet.
Detailed explanation-5: -Rows are the horizontal lines in the worksheet, and columns are the vertical lines in the worksheet. In the worksheet, the total rows are 10, 48, 576, while the total columns are 16, 384. In the worksheet, rows range from 1 to 1, 048, 576, while columns range from A to XFD.