Important Questions – Computer Applications
Unit 1: Computer Fundamentals
1. Define a computer.
2. Write any two applications of computers in business.
3. List the main components of a computer system.
4. What is the function of the CPU?
5. Differentiate between Input and Output devices with examples.
6. Define primary memory and secondary storage with examples.
7. What do you mean by generations of computers?
8. Write two features of 1st generation computers.
9. Differentiate between microcomputers and mainframe computers.
10. What is Disk Operating System (DOS)?
11. Define GUI with an example.
12. What is meant by file handling?
13. Give examples of two system software.
14. What are utilities in an operating system? Give examples.
15. Write the difference between system software and application software.
Unit 2: MS Word
1. Define word processing.
2. Write the steps to create a new document in MS Word.
3. How do you save a document?
4. What is text formatting? Give two examples.
5. Define paragraph alignment.
6. What is the use of headers and footers in a document?
7. Write the steps to insert a table in MS Word.
8. How do you insert an image into a document?
9. What is a template in MS Word?
10. Differentiate between a memo and a business letter.
11. Define Mail Merge.
12. List two practical uses of Mail Merge.
13. What is spell check?
14. Write the function of grammar check in Word.
15. What is the purpose of Track Changes in a document?
Unit 3: MS Excel
1. What is a spreadsheet?
2. Write the steps to create a new workbook in MS Excel.
3. What is the difference between a cell, row, and column?
4. How do you format cells in Excel? Give two examples.
5. Write the syntax of the SUM function with an example.
6. Define the AVERAGE function.
7. What is the use of the IF function?
8. List two types of charts available in Excel.
9. What is sorting in Excel?
10. Define filtering with an example.
11. Write the steps to print a worksheet.
Unit 4: MS PowerPoint
1. What is a slide in PowerPoint?
2. Define a theme in MS PowerPoint.
3. Write the steps to insert an image in a slide.
4. What are animations in PowerPoint?
5. What is the use of slideshow settings?
Unit 5: DBMS and Networking
1. Define DBMS (Database Management System).
2. Write two importance of DBMS in business applications.
3. What is a data hierarchy?
4. Define field, record, and file with examples.
5. Differentiate between a master file and a transaction file.
6. What is a database?
7. Define database structure.
8. Write two examples of database applications.
9. What is a computer network?
10. Differentiate between LAN and WAN.
11. Define online data processing.
12. Define offline data processing.
13. What is real-time data sharing?
14. Write one advantage of online over offline processing.
15. Give one example of real-time data usage.