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) WaterMark
Guess Paper 2: Computer Applications Spring – 2020 Past Papers
University Name – Confidential
Time Allowed: 3 hours
Total Marks: 70, Passing Marks (35)
Q1. Define the following terms:
a) System Software and Application
b) Command Line Interface
c) Desktop and Shortcut
d) Drop down and Pop up Menu
e) Compute and Computer
Q2. Give a detailed discussion on the impact of computer ages and their uses in offices and education.
Q3. Explain in detail the role of MS-Word in Office Automation and also explain its environment.
Q4. Write a detailed discussion on the “Concept of Spreadsheet”. Also, explain at least 4 different excel formulas
using examples.
Q5. Do the following.
a. Write steps to show all hidden files and folders of the system.
b. Write steps to sort desktop icons by date modified.
c. Write steps to change the screen resolution.
Q6. Explain in detail Visual Basic Macros with suitable examples.
Q7. Write short notes on the following.
i. MS Office SUIT
ii. Microsoft PowerPoint
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) WaterMark
Guess 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