May June 2023 Level One Application Skills Past Questions

09 Jun 2025
Prince Armstrong
Tech Questions & Answers

Topics: Fundamentals of Computing, Word Processing, Spreadsheet Management, and Database Management.

SECTION A: OBJECTIVES (20 MARKS)

1. A computer is an …………… device
Answer: a. Electronic

2. When an icon on the computer’s desktop is double clicked, it ……. the icon
Answer: c. Opens

3. The background picture of a desktop is termed ……….
Answer: b. Wallpaper

4. The ‘B’ on the formatting toolbar of the MS Word represents…………
Answer: d. Bold

5. The ‘Save As’ command is found under which menu?
Answer: a. File

6. Which of the following is an example of a spreadsheet application?
Answer: b. MS Excel

7. Which device can store the largest amount of data?
Answer: a. Hard disk

8. Function keys on a keyboard begin from …………
Answer: c. F1 to F12

9. To open MS Access on the desktop:
Answer: a. Double click on the icon

10. Instructions that tell the computer what to do are called …………
Answer: c. Software

11. Physical part of the computer:
Answer: b. Hardware

12. Vertical lines in spreadsheets are called:
Answer: a. Column

13. Keyboard shortcut for paste:
Answer: b. Ctrl + V

14. A primary key uniquely identifies a …………
Answer: d. Record

15. The left mouse button is also called ………. Click
Answer: c. Primary

16. Cut/copied item is stored in:
Answer: b. Clipboard

17. A computer program is:
Answer: d. A set of instructions

18. Related data stored in a table is a:
Answer: a. Database

19. Backup means:
Answer: c. Back up

20. Computers use:
Answer: b. 0s and 1s

SECTION B: SPREADSHEET MANAGEMENT

1. Explain the following features or parts of a spreadsheet:

Cell: The intersection of a row and a column.
Active cell: The currently selected cell where data is entered.
Name box: Displays the address of the active cell.
Vertical scrollbar: Allows vertical movement within the worksheet.
AutoSum: A function used to automatically add numbers.

2. Copy and complete the table with cell names (assumed format shown below):

No.   A        B
1     A1       B1
2     A2       B2
3     A3       B3
4     A4       B4
5     A5       B5

SECTION C: DATABASE MANAGEMENT

1. a. A database is a structured collection of data that can be accessed, managed, and updated easily.

b. Steps to open MS Access using Start Menu:

Click on the Start Menu.
Scroll or search for Microsoft Office.
Click on Microsoft Access.

2. Terminologies in Database Management:

Primary key: A field that uniquely identifies each record in a table.
Foreign key: A field in one table that links to the primary key in another table.
Composite key: A key made up of two or more fields to uniquely identify a record.
Super key: A set of one or more fields that uniquely identify a record.
Compound key: Similar to a composite key, it combines multiple fields for uniqueness.

SECTION D: WORD PROCESSING – COMPULSORY

Task:

1. Use any Word processing application to create a table with the following column headings:
   SRN, First Name, School, Location.

2. Type the information below into the table created:

i. SRN 1, First Name: Esther, Last Name: Boakyewaa, School: Pilot Training Institute, Location: Accra

ii. SRN 2, First Name: Anabella, Last Name: Essuman, School: Avotrain, Location: Abetifi

iii. SRN 3, First Name: Anabella, Last Name: Obeng, School: Pentecost Vocational, Location: Temale

iv. SRN 4, First Name: Emmanuel, Last Name: Asante, School: Gbawe Vocational, Location: Gbawe

v. SRN 5, First Name: Rebecca, Last Name: Sarfoah, School: Tema Vocational, Location: Tema

Instructions:
1. Title the table STUDENTS VISA
2. Bold each of the column heading
3. Change the entire row of SRN 5 Into italics
4. Save your work and print it on an A4 sheet

Download the Past Question Here