QUESTION 1
SECTION A
1. You are presented with a VBA program containing missing words and commands. Complete
the VBA code by filling in the missing words.
1.1 Const
1.2 Const
1.3 Const
1.4 String
1.5 Double
1.6 Double
1.7 Double
1.8 Double
1.9 Double
1.10 LastRow
1.11 2
1.12 LastRow
1.13 MachineType
1.14 OriginalCost
1.15 OpeningAccDep
1.16 MicrochipsManuf
1.17 OriginalCost
1.18 MaxChipsProduced
1.19 MicrochipsManuf
1.20 OriginalCost
1.21 DeliveryVehicleDeprYrs
1.22 OriginalCost
1.23 OpeningAccDep
1.24 OtherAssetsRate
1.25 End If
1.26 OpeningAccDep
1.27 DepreciationCurrentYear
1.28 6
1.29 7
1.30 Next counter