Question

Which of the following function keys is used as a toggle key for changing referencing modes? (i) F2 (ii) F8 (iii) F4 (iv) F6

Answer 1

Explanation:

F4 is answer

follow me

mark the answer as branlist

Answer 2

F4 is the function key which is used as a toggle key for changing the referencing modes.  

Explanation:

• The cell coordinates present in the Excel formula is said to be cell references.  
• Two of the references are commonly used in the spreadsheets, namely 1) Absolute referencing and 2) Relative referencing.
• With the absolute referencing, the coordinates of the cell are not changed when a formula is 'copied from one cell to another'. Relative referencing is the default referencing in the Excel spreadsheet.  
• F4 key is the function key used for toggling between the 'absolute and relative modes' of referencing cells.