USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You can click a cell or select a range to enter its address in the formula.
|
T
|
|
F
|
|
Either A or B
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Click on a cell to select it. Or use the keyboard to navigate to it and select it. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range.
Detailed explanation-2: -Note that the cell address also appears in the Name box in the top-left corner, and that a cell’s column and row headings are highlighted when the cell is selected.
Detailed explanation-3: -Enter the formula =SMALL(A1:A10) into cell B1. In cell B2, enter the formula =LARGE(A1:A10). Subtract the two formulas by entering =B2-B1 into cell C1. You now have the range of your data.
There is 1 question to complete.