DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Source area
|
|
|
Destination area
|
|
|
Selection
|
|
|
None of the above
|
Detailed explanation-1: -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. the range of cells receiving the copy is called the paste area or the.
Detailed explanation-2: -Answer: By default when you copy and paste and range of cells, it will copy the data as well as formatting such as font, number format, borders, background color, etc.
Detailed explanation-3: -A cell range in Ms Excel is a collection of chosen cells. It can be referred to in a formula. This is defined in a spreadsheet with the reference of the upper-left cell as the minimum value of the range and the reference of the lower-right cell as the maximum value of the range. Suggest Corrections. Similar questions.
Detailed explanation-4: -The cell being copied is called the source area (or copy area).