AIN2601
Assignment 2 Semester 1 2026
Unique number:
Due Date: 7 April 2026
DISCLAIMER & TERMS OF USE
Educational Aid: These study notes are intended to be used as educational resources and should not be seen as a
replacement for individual research, critical analysis, or professional consultation. Students are encouraged to perform
their own research and seek advice from their instructors or academic advisors for specific assignment guidelines.
Personal Responsibility: While every effort has been made to ensure the accuracy and reliability of the information in
these study notes, the seller does not guarantee the completeness or correctness of all content. The buyer is
responsible for verifying the accuracy of the information and exercising their own judgment when applying it to their
assignments.
Academic Integrity: It is essential for students to maintain academic integrity and follow their institution's policies
regarding plagiarism, citation, and referencing. These study notes should be used as learning tools and sources of
inspiration. Any direct reproduction of the content without proper citation and acknowledgment may be considered
academic misconduct.
Limited Liability: The seller shall not be liable for any direct or indirect damages, losses, or consequences arising from
the use of these notes. This includes, but is not limited to, poor academic performance, penalties, or any other negative
consequences resulting from the application or misuse of the information provided.
, For additional support +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:
, For additional support +27 81 278 3372
=MID(Q14,FIND("_",Q14)+1,FIND("_",Q14,FIND("_",Q14)+1)-FIND("_",Q14)-1)
1.5 City code for Moses Mabhida Stadium in O16
In O16, extract the city code from Q16.
Enter:
=RIGHT(Q16,LEN(Q16)-FIND("_",Q16,FIND("_",Q16)+1))
1.6 Capacity for Royal Bafokeng Stadium in K40
You must use the table in J7:R17 only.
In K40, enter:
=VLOOKUP(J40,$J$8:$P$17,7,FALSE)
Then copy down to:
K41:K49
Why this works:
Column J contains the stadium name
Column P is the 7th column in the lookup range and contains capacity
1.7 Category in R8
Category A stadiums have a capacity of 50 000 or more.
In R8, enter:
=IF(P8>=50000,"A","B")
Then copy it down to:
R9:R17
1.8 Conditional formatting for R8:R17
Apply conditional formatting so that every cell with A gets a purple fill.
Assignment 2 Semester 1 2026
Unique number:
Due Date: 7 April 2026
DISCLAIMER & TERMS OF USE
Educational Aid: These study notes are intended to be used as educational resources and should not be seen as a
replacement for individual research, critical analysis, or professional consultation. Students are encouraged to perform
their own research and seek advice from their instructors or academic advisors for specific assignment guidelines.
Personal Responsibility: While every effort has been made to ensure the accuracy and reliability of the information in
these study notes, the seller does not guarantee the completeness or correctness of all content. The buyer is
responsible for verifying the accuracy of the information and exercising their own judgment when applying it to their
assignments.
Academic Integrity: It is essential for students to maintain academic integrity and follow their institution's policies
regarding plagiarism, citation, and referencing. These study notes should be used as learning tools and sources of
inspiration. Any direct reproduction of the content without proper citation and acknowledgment may be considered
academic misconduct.
Limited Liability: The seller shall not be liable for any direct or indirect damages, losses, or consequences arising from
the use of these notes. This includes, but is not limited to, poor academic performance, penalties, or any other negative
consequences resulting from the application or misuse of the information provided.
, For additional support +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:
, For additional support +27 81 278 3372
=MID(Q14,FIND("_",Q14)+1,FIND("_",Q14,FIND("_",Q14)+1)-FIND("_",Q14)-1)
1.5 City code for Moses Mabhida Stadium in O16
In O16, extract the city code from Q16.
Enter:
=RIGHT(Q16,LEN(Q16)-FIND("_",Q16,FIND("_",Q16)+1))
1.6 Capacity for Royal Bafokeng Stadium in K40
You must use the table in J7:R17 only.
In K40, enter:
=VLOOKUP(J40,$J$8:$P$17,7,FALSE)
Then copy down to:
K41:K49
Why this works:
Column J contains the stadium name
Column P is the 7th column in the lookup range and contains capacity
1.7 Category in R8
Category A stadiums have a capacity of 50 000 or more.
In R8, enter:
=IF(P8>=50000,"A","B")
Then copy it down to:
R9:R17
1.8 Conditional formatting for R8:R17
Apply conditional formatting so that every cell with A gets a purple fill.
