True or false? In Microsoft Excel, the purpose of the F4 key is to ';lock'; an address in a formula. When you ';l

In Microsoft Excel, the purpose of the F4 key is to ';lock'; an address in a formula. When you ';lock'; an address, that address doesn't change when you copy the formula into a different cell.





Please explain, true or false!!True or false? In Microsoft Excel, the purpose of the F4 key is to ';lock'; an address in a formula. When you ';l
That is true....





If you ';lock'; on say ';B'; ';3'; your formula will stay locked on that cell.True or false? In Microsoft Excel, the purpose of the F4 key is to ';lock'; an address in a formula. When you ';l
Partially true: the F4 key cycles through 4 options


1 Relative address (column and row can change when moved/copied)


2 Absolute address (always refers to particular cell)


3 Relative column absolute row (row never changes, column changes)


4 Absolute column relative row (column never changes, row changes)