USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -The active cell reference appears in the Formula Bar. To select a group of cells you must click each cell individually until all cells in the range are selected. After you edit the data source in the worksheet, the chart is also updated to reflect the changes.
Detailed explanation-2: -Click the cell, or press the arrow keys to move to the cell. Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection. You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys.
Detailed explanation-3: -To select a larger range, it’s easier to click the first cell and hold down the Shift key while you click the last cell in the range. You can scroll to make the last cell visible.
Detailed explanation-4: -Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard.
Detailed explanation-5: -In MS-Excel, the address of any cell starts with “A1‟. Hence statement 2 is false.