Senior Macros

Test your Senior-level Spreadsheets Macros skills in Tools Systems. This timed assessment evaluates your expertise in Accounting.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

You need to store key-value pairs, such as account codes and their descriptions, for quick lookup within a macro. Which VBA object is best suited for this purpose?

A. A two-dimensional Array, with one dimension for keys and one for values.

B. A Collection object, using the description as the item and the code as the key.

C. A FileSystemObject instance configured to read from a lookup file.

D. A Scripting.Dictionary object, which is optimized for key-based lookups.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question