Question: 7. This type of cell reference does not change when copied and remains in a fixed position during operations. a. Relative b. Absolute c. Constant

7. This type of cell reference does not change when copied and remains in a fixed position during operations. a. Relative b. Absolute c. Constant d. Fixed e. Mixed 8. A handy keyboard shortcut that turns a cell address entered in a formula into an absolute cell reference, adding the dollar sign ($) in front of the column and row addresses, is: a. F1 b. F5 C. AS d. Ctrl+* e. F4 A Sign ou acer O A 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 Mathematics Questions!