USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) ____ reference.
|
bad
|
|
mixed
|
|
absolute
|
|
relative
|
Explanation:
Detailed explanation-1: -Click the tab for the first worksheet that you want to reference. Hold down the Shift key then click the tab for the last worksheet that you want to reference. Select the cell or range of cells that you want to reference. Complete the formula, and then press Enter.
Detailed explanation-2: -The Undo and Redo buttons on the standard toolbar allow you to quickly correct mistakes without repeating the steps again. Both these buttons include drop-down lists to allow you to perform multiple undos and redos. It is possible to undo and redo up to the last 16 consecutive actions.
There is 1 question to complete.