DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
receiver cell
|
|
|
final cell
|
|
|
receiving range
|
|
|
destination area
|
Detailed explanation-1: -The range of cells receiving copied content is called the area. Paste.
Detailed explanation-2: -The range of cells receiving a copy is called the copy area.
Detailed explanation-3: -The cell being copied is called the source area or. data series. A range contains the data that determines the size of the slices in the pie; these entries are called the. destination area.
Detailed explanation-4: -The cell being copied is called the source area (or copy area).
Detailed explanation-5: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).