Past Papers Computer Applications

By: Prof. Fazal Rehman Shamil

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

Prof. Fazal Rehman Shamil