FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The range of cells to which you are pasting is called the ____
A
Source area
B
Destination area
C
Range
D
None of the above
Explanation: 

Detailed explanation-1: -The range of cells that you select to hold the summarized data in a consolidation. The destination area can be on the same worksheet as the source data or on a different worksheet. A worksheet can contain only one consolidation.

Detailed explanation-2: -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-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.

Detailed explanation-4: -Select the cell or range of cells. Select Copy or press Ctrl + C. Select Paste or press Ctrl + V.

There is 1 question to complete.
Previous
Next