Guess Paper 1: Computer Applications Fall – 2020 Past Papers
University Name – Confidential
Time Allowed: 3 hours Total Marks: 70, Passing Marks (35) Q1: Select the correct option for the given statement i. Software that performs Multi-task is called a) Operating system b) SUITE c) Special-purpose Software d) General Purpose Software ii Which one is an example of Operating System a) Windows b) Package c) General Purpose Software d) All of the above iii MS-Excel is an example of a) Accounting Software b) Special Purpose Software c) General Purpose Software d) All of the above iv Which statement is true for Information System a) A System that takes inputs, processes it and gives output b) A System that takes inputs, processes it and gives output with feedback c) A System that takes inputs, processes it and gives output with feedback with a storage capacity d) All of the above v The functionality of FORMAT Painter in MS-Word is a)To record certain statement/s b) To create a database c) Copying formatting from one place and apply it on another d) All of the above vi The simplest definition of Database can be a) Rows and Columns of a spreadsheet b) Tables of table c) MS-Access d) All of the above vii Quick Access bar in MS-Word can be used for a) To view and edit b) To approach and manage certain tools with ease c) To create tools for future use d) All of the above Q2: How computer has increased the efficiency in the working environment, explain with suitable example Q3: Write a detail note on System Software Q4: Explain the purpose and functionality of MACROS in MS-Word Q5: What is SUMIF function explain its advantages? Q6: What is Microsoft Access, what are its advantages? Q7: Write Short notes on the following a) Application Software b) WaterMarkGuess Paper 2: Computer Applications Spring – 2020 Past Papers
University Name – Confidential
Guess Paper 3: Computer Applications Spring – 2019 Past Papers
University Name – Confidential
Time Allowed: 3 hours Total Marks: 70, Passing Marks (35) Q1: Select the correct option for the given statement i. Software that performs a specific task is called a) Operating system b) SUITE c) Special-purpose Software d) None of the Above ii. Windows is an example of a) System Software b) Special Purpose Software c) General Purpose Software d) All of the above iii. MS-Office is an example of a) Accounting Software b) Special Purpose Software c) General Purpose Software d) All of the above iv. Which system is true for Information System a) A System that takes inputs, processes it and gives output b) A System that takes inputs, processes it and gives output with feedback c) A System that takes inputs, processes it and gives output with feedback with the storage capacity d) All of the above v. The functionality of MACROS in MS-Word is a) To record certain statement/s b) To create a database c) To create comments for a file d) All of the above vi. Excel spreadsheet is a simple form of a) System software b) Database c) Package d) All of the above vii. To find things easily on the top of the Ribbon of MS-Word one has to create a) Access b) Database c) Package d) Quick Access Bar Q2: Explain the Custom Software; also elaborate its features and Characteristics Q3: Differentiate between System Software and Application Software with example/s. Q4: What is the VLookup Function? Explain its purpose Q5: What is SUMIF function explain its advantages? Q 6: How Computer has changed the traditional manual system to the digital system? Explain the advantages of computer system over the manual system; explain with any suitable example/s Q7: Write Short notes on the following a) Freeware Software b) WaterMarkGuess Paper 4: Computer Applications Fall – 2019 Past Papers
University Name – Confidential
Time Allowed: 3 hours Total Marks: 70, Passing Marks (35) Q1. Define the following terms: a) GUI and CLI b) Data and Information c) File and Folder d) Drop down and Pop up Menu e) Hardware and Software Q2. Give detail discussion on MS Office SUIT and also explains its various applications. Q3. Explain in detail the role of MS-Word in Office Automation and also explain its environment. Q4. Write a detail discussion on “Solving optimization problem using Excel”. Q5. Do the following. a. Write steps to place a bullet mark at the beginning of each line. b. Write step to create a 3D border on the page. c. Write steps to insert a page number at the bottom of each page. Q6. Explain in detail the purpose of Information system along its types and various tools. Q7. Write short notes on the following. a. Application of learn skills b. Uses of Graphs and Charts in Excel.Guess Paper 5: Computer Applications Fall – 2018 Past Papers
University Name – Confidential
Time Allowed: 3 hours Total Marks: 70, Passing Marks (35) Q1. Define the following terms: i. Data ii. Hardware iii. Soft copy iv. Memory v. Section break Q2. Write a comprehensive note on the Information system and its types. Q3. Explain in detail the role of PowerPoint in Office Automation and also explain its features and environment. Q4. Write a detail discussion on social impact of computer and industry and education. Q5. Do the following. i. Write steps to merge two columns of a table. ii. How to import clip arts in MS-word iii. Sorting and filtering in MS-Excel Q6. Write a comprehensive notes on “solving optimization problems in MS-Excel”. Q7. Write short notes on the following. i. Computer applications ii. Office automation system and tools