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
Get step-by-step solutions from verified subject matter experts
