What is a pivot table in Excel, and what is its primary use?
Describe how you would use the VLOOKUP function to find data in an Excel spreadsheet. Provide an example.
Describe the general structure of a Python program. What are the key components that make up a Python script?
Explain the difference between a list and a dictionary in Python. Provide an example of each.
Explain how branching (conditional statements) and loops (cycles) are implemented in Python. Provide an example of each.
Write a Python function that takes an integer as input and returns whether the number is prime. Use a loop in your implementation.