DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
By its coordinates
|
|
|
By its cell reference
|
|
|
By the column letter and row number
|
|
|
All the answers
|
Detailed explanation-1: -Select a cell, or a range of cells. If you select one cell, you search the whole worksheet. If you select a range, you search just that range. Click Home > Find & Select > Go To Special.
Detailed explanation-2: -Locate the last cell that contains data or formatting on a worksheet. To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.
Detailed explanation-3: -A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. For example, A1 refers to the cell at the intersection of column A and row 1; B2 refers to the second cell in column B, and so on.
Detailed explanation-4: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell.