USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The range A1:C5 is defined as a block of cells that includes all the cells in columns A through C in rows 1 through 5.
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The range reference for cells A1 through A5 and cells F1 through G5 is: A1:A5; F1:G5. 12. To force text that extends beyond a cell’s border to fit within the cell, make the cell with truncated text the active cell, and then click the Wrap Text button in the Alignment group on the Home tab.
Detailed explanation-2: -Contiguous and Non-Contiguous Ranges A non-contiguous range consists of two or more separate blocks of cells. These blocks can be separated by rows or columns as shown by the ranges A1 to A5 and C1 to C5.
Detailed explanation-3: -Selection using the interface: click on cell A1, position your mouse over cell C5, press and hold <Shift> and click on cell C5. Your range should be highlighted.
There is 1 question to complete.