tanszek:oktatas:exercises
This is an old revision of the document!
Midterm Exam Questions
- Explain the function of the bus in a computer system.
- Describe a scenario where the bus speed could become a bottleneck in a computer system. What are some possible solutions?
- Describe the Von Neumann architecture and explain how it influences modern computer systems.
- What is the role of libraries in software development?
- Compare and contrast the functions of system software and application software, providing examples of each.
- You are tasked with installing a new operating system on a computer. List the steps you would take to ensure the operating system is installed correctly.
- You have a dataset in Excel containing sales data for the past year. Describe the steps you would take to create a pivot table that shows total sales per month.
- Explain the concept of the Turing machine and its significance in computer science.
- A computer is running slowly even though the CPU usage is low. What other hardware components could be causing the issue, and how would you diagnose them?
- Describe a situation where understanding the Neumann principle would be essential for solving a computer system problem.
- What is the purpose of using conditional formatting in Excel?
- Given a spreadsheet, perform the following tasks:
- a) Create a formula to calculate the total sales.
- b) Use VLOOKUP to find the sales amount for a specific product.
- c) Apply conditional formatting to highlight all sales figures above a certain threshold.
tanszek/oktatas/exercises.1725193869.txt.gz · Last modified: 2024/09/01 12:31 by nasraldeen