AIN2601
Assignment 2 Semester 1 2026
Unique number:
Due Date: 7 April 2026 @ 14:00
Terms of use
By making use of this document you agree to:
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
Use this document
Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
QUESTION 1
1.1 Full venue code in Q8
The full venue code is made up of:
stadium code_province code_city code
In Q8, enter:
=K8&"_"&M8&"_"&O8
Then copy it to:
Q9:Q10
Q12:Q13
Q15
Q17
1.2 Enter your details
In F4, type your student number
In D4, type your Name and Surname
Do not skip this.
1.3 Stadium code for Royal Bafokeng Stadium in K11
In K11, use a formula that extracts the stadium code from the full venue code already shown
in Q11.
Enter:
=LEFT(Q11,FIND("_",Q11)-1)
1.4 Province code for Nelson Mandela Bay Stadium in
M14
In M14, use a formula to extract the province code from Q14.
Enter:
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
Assignment 2 Semester 1 2026
Unique number:
Due Date: 7 April 2026 @ 14:00
Terms of use
By making use of this document you agree to:
Use this document as a guide for learning, comparison and reference purpose,
Terms of use
Not to duplicate, reproduce and/or misrepresent the contents of this document as your own work,
By making use of this document you agree to:
Use this document
Fully accept the consequences
solely as a guide forshould you plagiarise
learning, reference,or and
misuse this document.
comparison purposes,
Ensure originality of your own work, and fully accept the consequences should you plagiarise or misuse this document.
Comply with all relevant standards, guidelines, regulations, and legislation governing academic and written work.
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is" without any express or
implied representations or warranties. The author accepts no responsibility or liability for any actions taken based on the
information contained within this document. This document is intended solely for comparison, research, and reference purposes.
Reproduction, resale, or transmission of any part of this document, in any form or by any means, is strictly prohibited.
, +27 81 278 3372
QUESTION 1
1.1 Full venue code in Q8
The full venue code is made up of:
stadium code_province code_city code
In Q8, enter:
=K8&"_"&M8&"_"&O8
Then copy it to:
Q9:Q10
Q12:Q13
Q15
Q17
1.2 Enter your details
In F4, type your student number
In D4, type your Name and Surname
Do not skip this.
1.3 Stadium code for Royal Bafokeng Stadium in K11
In K11, use a formula that extracts the stadium code from the full venue code already shown
in Q11.
Enter:
=LEFT(Q11,FIND("_",Q11)-1)
1.4 Province code for Nelson Mandela Bay Stadium in
M14
In M14, use a formula to extract the province code from Q14.
Enter:
Disclaimer
Great care has been taken in the preparation of this document; however, the contents are provided "as is"
without any express or implied representations or warranties. The author accepts no responsibility or
liability for any actions taken based on the information contained within this document. This document is
intended solely for comparison, research, and reference purposes. Reproduction, resale, or transmission
of any part of this document, in any form or by any means, is strictly prohibited.
