USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What will you use to create a formula?
|
|
quick reference toolbar
|
|
|
cell reference
|
|
|
pen and paper
|
|
|
name box
|
Explanation:
Detailed explanation-1: -Create a cell reference to another worksheet Click the cell in which you want to enter the formula., type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.
Detailed explanation-2: -These are called “relative” cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a “$” before the column letter if you want that to always stay the same.
There is 1 question to complete.