DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Row heading
|
|
Sheet tab
|
|
Cell reference
|
|
Column heading
|
Detailed explanation-1: -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: -These letters and numbers are called row and column headings.
Detailed explanation-3: -In an Excel worksheet, each small rectangle or box is known as a cell. The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is the cell surrounded by a black border. Data can only be entered into the active cell.
Detailed explanation-4: -Columns are denoted and identified by a unique alphabetical header letter, which is located at the top of the worksheet. Column headers range from A-XFD, as Excel spreadsheets can have 16, 384 columns in total. Columns run vertically in the worksheet, and the data goes from up to down.