DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
ranges
|
|
|
external references
|
|
|
internal references
|
|
|
active cells
|
Detailed explanation-1: -An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook.
Detailed explanation-2: -For example, to refer to cell A1 in Sheet2, you type Sheet2!A1. For example, to refer to cells A1:A10 in Sheet2, you type Sheet2!A1:A10. Note. If the worksheet name includes spaces or non-alphabetical characters, you must enclose it in single quotation marks.
Detailed explanation-3: -The key difference between internal and external references is that the external reference data type contains an ID for the worksheet and also a description of which cells are referred to. An internal reference contains no reference to the sheet-it is implicit that the sheet is the current sheet.
Detailed explanation-4: -On the Formulas tab, in the Defined Names group, click Name Manager. Check each entry in the list, and look in the Refers To column for external references. External references contain a reference to another workbook, such as [Budget. xlsx].