USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A1-A5
|
|
|
A1A5
|
|
|
A1:A5
|
|
|
A1, A5
|
Detailed explanation-1: -When you enter =A1:A5 into any cell in rows 1 to 5, you will get the value from column A, from the same row where you entered that formula-unless you array enter it, in which case you will get 1, which is the first element of the array, returned to the first cell into which the formula is entered.
Detailed explanation-2: -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-3: -A5 is an example of cell reference. 2. The Name box shows the data that you enter in an active cell.