CHINHOYI UNIVERSITY OF TECHNOLOGY

SCHOOL OF ENTREPRENEURSHIP AND BUSINESS SCIENCES

DEPARTMENT OF ACCOUNTING SCIENCES AND FINANCE

BSc (HONS) IN ACCOUNTANCY

COURSE: COMPUTER APPLICATIONS AND INFORMATION

SYSTEMS
PRACTICAL EXAMINATION (MAIN)

CODE: CUAC115

DATE: AUGUST – DECEMBER 2022

DURATION: 3 HOURS

INSTRUCTIONS TO CANDIDATES
1. Answer ALL questions
2. This is a PRACTICAL EXAMINATION, save your work in A folder
named with your registration on the desktop of your workstation.
3. DON’T FORGET TO CONSTANTLY SAVE YOUR WORK.

1
Question 1 (10 Marks)
Objectives:
• Introduction to MS Excel files, Workbooks, Worksheets,
Columns and Rows.
• Formatting Worksheets.
• AutoFill, Numeric formats, previewing worksheets.

a) Create a new workbook as shown below and save the file

with the name “Payroll”.
b) Enter the labels and values in the exact cells locations as
desired.
c) Use AutoFill to put the Employee Numbers into cells
A6:A8.
d) Set the columns width and rows height appropriately.
e) Set labels alignment appropriately.
f) Use warp text and merge cells as desired.
g) Apply borders, gridlines and shading to the table as
desired.
h) Format cell B2 to Short Date format.
i) Format cells E4:G8 to include $ sign with two decimal
places.
j) Calculate the Gross Pay for employee; enter a formula in
cell E4 to multiply Hourly Rate by Hours Worked. 11.
Calculate the Social Security Tax (S.S Tax), which is 6% of
the Gross Pay; enter a formula in cell F4 to multiply Gross
Pay by 6%.
k) Calculate the Net Pay; enter a formula in cell G4 to
subtract Social Security Tax from Gross Pay.
l) Set the work sheet vertically and horizontally on the page.
m) Save your work.

2
Question 2 (10 Marks)
Objectives:
 Using Formulas.
 Header and Footers.

a) Create a new workbook as shown below and save the

file with the name “Call Statistics”.

b) Rename Sheet 1 to (Call Statistics).

c) Enter the labels and values in the exact cells
locations as desired.
d) Set the row height of rows 1 & 3 to size 30; and rows
4 until 10 to size 20.

3
e) Set labels alignment appropriately.
f) Use Warp Text, Orientation and merge cells as
desired.
g) Apply border, gridlines and shading to the table as
desired.
h) Format column E to include $ sign with two decimal
places.
i) Format cell B12 to include % sign with 0 Decimal
places.
j) Calculate the Calls per Hour, enter a formula in cell
D4 to divide numbers of calls by Hours worked. Using
AutoFill, copy the formula to the remaining cells.
k) Calculate the Bonus. Enter a formula in cell E4 to
multiply ‘Calls per Hours’ by the fixed Bonus Rate in cell
B12. Using AutoFill, copy the formula to the remaining
cells.
l) Calculate the ‘TOTAL’. 13. Set the worksheet
vertically and horizontally on the page.
m) Create a header that includes your name in the left
section, and your ID number in the right section. Create
the footer that includes the current Date in the center.

Question 3 (15 Marks)

Objectives:
 Number, Commas and Decimal numeric formats.
 Working with Formulas (Maximum, Minimum,
Average, Count and Sum).
 Percentage Numeric Formats.

4
a) Create the worksheet shown above.
b) Set the column widths as follows: Column A: 8, Column
B: 14, Columns C & D: 15, Columns E & F: 14.
c) Enter the formula to find COMMISSION for the first
employee. The commission rate is 2% of sales,
COMMISSION = SALES * 2% Copy the formula to the
remaining employees.
d) Enter the formula to find TOTAL SALARY for the first
employee where: TOTAL SALARY = SALARY +
COMMISSION Copy the formula to the remaining
employees.
e) Enter formula to find TOTALS, AVERAGE, HIGHEST,
LOWEST, and COUNT values. Copy the formula to each
column.
f) Format numeric data to include commas and two
decimal places.
g) Align all column title labels horizontally and vertically at
the center.
h) Create a Header that includes your name in the left
section, page number in the center section, and your ID
number in the right section.
i) Create footer with DATE in the left section and TIME in
the right section.

5
j) Save the file with name panda EST.

Question 4 (10 marks)

Objectives:
 Working with the IF Statement.
a) For the given table find the following:

b) TAX (If ITEM PRICE is less than 100, TAX is 50,

otherwise it should be 100).
c) TOTAL PRICE BEFORE TAX =NO. OF ITEMS * ITEM
PRICE.
d) TOTAL PRICE AFTER TAX = TOTAL PRICE BEFORE TAX
+ TAX.
e) RATE (If TOTAL PRICE AFTER TAX > 3500 then the
rate is “HIGH”, otherwise it is REASONABLE.
f) Find Count of Items, Average of Taxes, Min Item
PRICE and Max Item PRICE. g) Save file as TAXIF.

Question 5 (10 Marks)

Objectives:
 Working with Sum IF and Count IF statements.
 Inserting Charts.

6
a) Create the worksheet shown above.
b) Set the Text alignment, Columns width and high
appropriately.
c) Use AutoFill to put the Series Numbers into cells A5:A7.
d) Format cells C3:G7, C8:E11, C13:E13 to include dollar sign
with two decimal places.
e) Find the Average Sales and Maximum Sales for each City.
f) Find the Total Sales for each Month.
g) Calculate the Profit for each month , where profit = Total
Sales – Cost
h) Calculate the 10% Bonus, which is 10% of the Profit.
i) Find the Total Sales for each Month; only for sales greater
than 30,000.
j) Find the No of Sales for each Month; only for sales greater
than 30,000.
k) Create the following Charts:

7
Question 6 (25 Marks) each task has a total of
5 marks

Task 1
a) Create a new database, save it on the desktop and name
it “School Database”
b) Create a Table in the School Database with the following:

Name Surname Telepho Date of Stipe Foreign

ID ne Birth nd er
Number
1001 mazun chinyaka 077656 5/7/199 $100 no
ga ta 576 9 00
1002 koroni dhobha 073454 13/6/19 $122 no
587 98 00
1003 ricardo figeredo 071345 14/8/20 $160 no
467 01 00
1004 george bush 077235 15/8/20 $240 yes
678 02 00
1005 donald trump 077245 17/2/20 $240 yes
639 01 00

8
c) Make the “ID Number” Field as the Primary Key.
d) Save the table as “Student’s Table”
e) Return to the main Access window.

Tack 2
a) Open the “Students Table” and enter 5 complete records.
b) Sort the table in ascending order by surname
c) Move the Date of Birth and Telephone Number fields so
that the Date of Birth field is now directly after the
Surname field.
d) Delete the last Record you have entered
e) Change the field size of the Surname to 20

Task 3
a) Create a Form with all fields on the Student’s Table.
b) Name the form Students Entries
c) Make the ID Number of Each student in the form, Red
d) Insert a Picture in the form in way that all text is visible.

Task 4
a) Create a report based on the Student’s Table showing the
Fields Name, Surname, and Telephone Number.
b) Name the report Telephone List
c) Insert a picture in the report Header

Task 5
a) Create a query, showing all fields of those students who
have a particular surname of your Choice.
b) Create another query showing all fields of those students
born after 2000
c) Create a query showing only the Student’s Name,
Student’s Surname and Student’s Date of birth.

9
Question 7 (20 Marks) each task has a total of 5
marks
Task 1

Create a table in Access that with the following

ID LAST FIRST ADDRES CITY STATE CLASS

NAME NAME S STANDIN
G
7 NYIKA MUTSA 1122 MUTAR MANICA SENIOR
Chikang E LAND
a
8 TRUMP DONALD 7230 HARARMASHO JUNIOR
Gunhill E NALAND
CENTRA
L
9 NEI PRECIOU 565 MASVI MASVIN FRESHMA
S Rujeko A NGO GO N
10 PATAI PATRICIA 65 BULAW MATEBE SOPHOM
Cowdry AYO LELAND ORE
Park NORTH
11 MADZIMA SHINGAI 54 GWERU MIDLAN SENIOR
I Athlone DS

12 MAPETE PANASHE 67 HARAR MASHO JUNIOR

Waterfall E NALAND
s CENTRA
L

a. Save the table as tblStudents.

Task 2
Create a query that displays the first name, last name and
city of students from Mashonaland Central
a. Save the query as qryCAStudents.
Task 3

Create a form of the following

10
a. Use tblStudents to create the form.
b. Include all the fields.
c. Use the Columnar layout.
d. Save (title) the form as frmStudents.

Task 4
Create a report

a. Use tblStudents to create the report.

b. Include the following fields:
 First Name
 Last Name
 ID Number
 Class Standing
c. Sort the records by Last Name.
d. Save the report (title) as rptStudentSummary.

End of Examination

11