Practical Example - Hypothesis Testing

Could you please clarify the discrepancy between the use of population variance calculation methods? Specifically, I've noticed that the lecture video utilizes the VARS formula while the excel solution uses the VARPA formula. This has caused some confusion for me when trying to apply these concepts in practice. Could you explain the reasoning behind this difference and help me understand which method is more appropriate in different scenarios?