Question: Does anyone understand what I'm supposed to do here? Worst instructions ever. -B4 -$B4 Try out various formulas as shown in the online Excel Lab

 Does anyone understand what I'm supposed to do here? Worst instructions

Does anyone understand what I'm supposed to do here? Worst instructions ever.

-B4 -$B4 Try out various formulas as shown in the online Excel Lab session. Remember pressing F4 is the easiest way to enter the $ signs. Please practice to see the impact of dollar sign in each case. Once you enter the formula in cells G4, B9, F9 and J9, then copy across and down to observe the results and effect of $ signs Summary of absolute cell reference uses: $B4: Allows the row reference to change, but not the column reference. B$4: Allows the column reference to change, but not the row reference. B$4: Allows neither the column nor the row reference to change I hope this Lab session has made these cell reference types "absolutely" clear! $B$4 -$B4 Please type an appropriate formula in cell D19 so that when you copy across and down, a 5x5 multiplication table can be constructed 18 34 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!