This macro-enabled spreadsheet is designed to support learning how different memory addressing modes work in Computing. The addressing modes supported are Immediate, Direct, Indirect and Indexed. Clicking the ‘New question’ button clears any previous answers and generates a new base address and an offset for Indexed Addressing. The learner then enters the data that will be found using each of the addressing modes. Clicking the ‘Show answers’ button then reveals the correct answers.
NOTE: for this spreadsheet to work correctly, the copy of Excel in which it is running must allow macros to execute, and ‘Enable Content’ must be clicked when the spreadsheet is opened.