If we have 8, 9 and 6 in the cells D3, D4 and D5 respectively, what will this macro do? Sub test() Sheet2.Range("A3:A6") = Sheet2.Range("D3:D5").Value End Sub %3D a) The code places 8 in cell A3, 9 in...

Extracted text: If we have 8, 9 and 6 in the cells D3, D4 and D5 respectively, what will this macro do? Sub test() Sheet2.Range("A3:A6") = Sheet2.Range("D3:D5").Value End Sub %3D a) The code places 8 in cell A3, 9 in cell A4, 6 in cell A5 and #N/A in cell A6. b) The code places 8 in cell A3, 9 in cell A4, 6 in cell A4 c) It sets the range of cells A3 to A5 to be blank. d) Display error