USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Cell Range
|
|
combines multiple lines into on cell
|
|
|
A combination of numbers and symbols used to express a calculation
|
|
|
to copy a cell’s contents and formatting into other cells
|
|
|
a block of cells that can be selected (B4:B16)
|
Explanation:
Detailed explanation-1: -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. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.
Detailed explanation-2: -Answer: To select a range of individual cells, hold down CTRL and click on each cell that you want to include in the range.
Detailed explanation-3: -The absolute address of the last cell of the cell range B4: F9 in an MS-Excel worksheet is $F$9. When someone wants a formula to consistently refer to a particular cell, even if he/she copy or move the formula elsewhere on the worksheet, the user needs to use an absolute cell reference.
There is 1 question to complete.