Computer & IT Applications Questions

Application Package

1. Why is excel also known as spreadsheet or worksheet? Explain it with respect to the following: worksheet, graphics, and database management system.
2. What is meant by word processing and slide presentation?
3. Discuss the difference between word processing and data processing.
4. Why mail merge is considered as an important feature in MS word? Explain with its advantages.
5. Why MS Access is considered as RDBMS? Explain different objects of MS ACCESS.
6. Explain importance and use of Hyperlinks in Ms-Word documents.
7. What are workbooks and worksheets in Ms-excel?
8. What is pivot table? What role does it play in spreadsheet management?
9. Write any five mathematical functions in Ms-excel with example.
10. What do you mean by presentation? Why Ms PowerPoint is considered as powerful tools for this purpose in comparison to Ms-word or Ms-excel.
11. Why Ms-access is considered as RDBMS? Explain how we create a report.
12. Explain about the features of word processing software.
13. Define worksheet? Explain how excel helps in data analysis.
14. What do you mean by pivot table? What are its uses and applications?
15. What is Ms-PowerPoint? Explain the importance of presentation in modern business scenario?
16. Explain about the features of Ms-Word.
17. What is PowerPoint? Mention the types of transition that are usually used in PowerPoint.
18. Explain the importance of templates and hyperlinks in Ms-Word documents.
19. What are relative and absolute cell references in Ms-Excel? Define formula and function in MS-Excel.
20. What is pivot table in Ms-Excel? How can MS-Excel be the best software for managers in any business organizations for data management purpose?
21. What is Ms-word? Explain the importance of MS-Power point interactive presentation?
22. Discuss the functions of mail merge in Ms-word.
23. What is master slide? Discuss the application of master slide option in MS PowerPoint.
24. What do you mean by workbook, worksheet and cell in term of spreadsheet? Also, discuss about chart in worksheet.
25. Define header and footer. Why is it important to create header and footer?

Operating System

1. What is operating system? Explain the features of operating systems.
2. What is operating system? Explain different types of operating system with examples.
3. Explain why GUI operating system is more popular than text based (CUI) operating system.
4. What is disk operating system (Dos)? Write its features.
5. What is windows operating system? Write its features.
6. What is booting? Explain different types of booting.
7. What is command? Explain different types of command.
8. Explain the concept of open source operating system?
9. “operating system software is the interface between user and application software.” Justify.
10. Write short notes on: a) UNIX    b) LINUX   c) File and Directory  d) Spooling  e) Buffering  f) Process  

Programming Concepts and Logics

1. What is programming languages? Explain the types of programming languages with merits and demerits.
2. What is language processor? Explain briefly the different language processor.
3. What is programming? Differentiate between compiler and interpreter.
4. Explain the different program control structure with their use and example.
5. What are the program design tools? Describe different types of program design tools.
6. Define program and software? Differ between program and software.
7. What is program logic? What are the symbols used to draw the flowchart.
8. Differ between flowchart and algorithm with suitable example.
9. What is flowchart? Differ between program flowchart and system flowchart.
10. What are the characteristics necessary for programming to be considered as a high-level language?

Database

1. What is data processing? Discuss some operations of data processing.
2. What is sequential file processing? Explain its advantages and limitations. What is random file organization? Explain its advantages and disadvantages.
3. What is database management system? Explain its advantages and disadvantages. Write some applications areas of DBMS.
4. What is data model? Explain its advantages and disadvantages. What is keys? Explain different types of keys with example.
5. What is database language? Explain DDL and DML.
6. What is RDBMS? Explain.
7. What is differ between a database and DBMS?
8. In a database table, what does each column represent?
9. Explain the various steps in data processing.
10. What do you mean by ER diagram? Explain the various symbols used in ER model.
11. Describe the various functions of DBMS.
12. What do you mean by DBMS? Explain the components of a DBMS.