CONFIDENTIAL BA/JAN 2023/ASM452/TEST

UNIVERSITI TEKNOLOGI MARA

HANDS ON TEST

COURSE : END USER APPLICATIONS

COURSE CODE : ASM452
EXAMINATION : JANUARY 2023
TIME : 3 HOURS

INSTRUCTIONS TO CANDIDATES

1. This test consists of THREE (3) parts: PART A (15 Questions)

PART B ( 9 Questions)
PART C (15 Questions)

2. Follow all the instructions given in the questions.

3. Submit all the 3 files from Word, Excel & PowerPoint to your respective lecturers.

NAME: ………………………………………………………………………..
STUDENT ID: ……………………………………………………………….
GROUP: ……………………………………………………………………..

1
CONFIDENTIAL BA/JAN 2023/ASM452/TEST

PART A: MICROSOFT WORD (30 MARKS)

1. Open a new Word document and then save the file as HOT Word (Your Name)

2. Type the following text.

(2 marks)

The COVID-19 pandemic is known as one of the biggest shocks with a remarkable impact on
economic, social, health, political and technological conditions worldwide. The disease has
spread to every continent and case numbers continue to rise and Malaysia is no exception. The
federal government implemented lockdown measures that includes stay-at-home orders,
banning outdoor activities including interstate travels, and shutting down all business except for
few designated essential services and the natural resource sectors which had brought negative
impacts on jobs, incomes, and livelihoods, disrupting supply chains and upending business
which are among the most vulnerable.
Therefore, to overcome the impact of COVID-19 on socioeconomic conditions among
Malaysians, the government and NGOs need to collaborate with the post-pandemic policies and
initiatives, such as providing constant support to enterprises, jobs, and incomes through
appropriate fiscal and monetary policies.

3. Write the title of “Socio-economic Differences in Response to the COVID-19 in Malaysia”

in 12-point Times New Roman and center the text
(3 marks)
4. Change all margins to 1.5 inches
(2 marks)
5. Make the first line of each paragraph indent 0.5 inches from the left margin
(2 marks)
6. Format the entire document to 10-point Times New Roman
(1 mark)
7. Format the entire document by using double spacing
(1 mark)
8. Create the following after the last paragraph and type the following sentence... “The table
below shows the socioeconomic indicators among Malaysian”.

Socioeconomic Indicators Percent (%)

Job loss 25%

Allowance cut 24.3%

2
CONFIDENTIAL BA/JAN 2023/ASM452/TEST

Overtime loss 13.6%

Pay cut 14.5%

Pay loss 22.6%

(3 marks)
9. Apply format grid table “Table 4 – Accent 2” for the table.
(2 marks)
10. Make a hyperlink for the article (paragraph no. 1, line 8) and set the hyperlink to
http://www.mdpi.com/2504-3990/82/1/32
(3 marks)
11. Use a bulleted list to present the items of “Socioeconomic Indicator” in table.
(2 marks)
12. Change the font of the text in the bulleted list to 14-point Comic Sans MS, font color to
“Orange – Accent 2, Darker 25%”
(2 marks)
13. Position your point at the end of the paragraph no 2 and “Insert Citation” by adding a new
“Type of Source” and click “Conference Proceedings”. Insert information about article as
per below details:

Author i) Othman, Nor Salwati ii) Mohamed Isa, Zuraidah

iii) Ali, Norhidayah iv) Ibrahim, Dahlia v) Anuar,
Azzyati vii) Abu Bakar, Suhaida
Title Socio-Economic Differences in Response to the
COVID-19 Pandemic: A Case in Malaysia
Year 2022
Page 32
Volume 82
Publisher MDPI
Editor Muhammad Rahimi Mohamad Rosman
DOI http://doi.org/10.3990/proceedings2022082032
(4 marks)
14. Create a header that state your Full Name, Student ID, and Group. Add page number “Plain
No 2” of your document footer. Close the header and footer toolbar.
(3 marks)
15. Save the document.

3
CONFIDENTIAL BA/JAN 2023/ASM452/TEST

PART B: MICROSOFT POWERPOINT (30 MARKS)

1. Create a new blank PowerPoint presentation and save the file as HOT TEST
POWERPOINT (Your Name_Class/Group).

2. Add Slide #1 and choose the Title Slide Layout and put the title as “MENTAL HEALTH
AWARENESS CAMPAIGN 2023” and put your name and student ID in the subtitle.

(3 marks)

3. Search for an appropriate image that will suit the theme “MENTAL HEALTH
AWARENESS” and insert the image nicely in Slide #1. Please make sure to remove the
background of the selected image.
(2 marks)

4. Add Slide #2 with Two Content layout. Enter “Proposed Date, Duration, and Venue” in
the title section. Enter the information below in the left content section and insert an
appropriate image in the right content section.
● Date: 1ST MAY 2023
● Duration: 1st May 2023-31st May 2023
● Venue: UiTM Campus Dungun
● Recommended Activities: Stress Reduction Seminar and Activities

(4 marks)

4. Add Slide #3 with the title and Content layout. Enter “MENTAL HEALTH ACTIVITIES”
as the title and insert the information below in SmartArt graphics. Insert an image for
each point that best represents the slide content. For this, you can choose any relevant
SmartArt graphics layout.

 Deep breathing.
 Exercise.
 Artwork
 Reading.
 Social interaction.
(5 marks)

5. Add Slide #4 with the Title and Content layout. Insert the information below by using any
table-style design with center Header Row.
Title: List of Task

Task Person in charge

Determine theme Anwar, Mahyuddin

Budget Discussion Maslan, Steven
Plan seminar content Fadhlina, Khalid, Anwar

4
CONFIDENTIAL BA/JAN 2023/ASM452/TEST

Plan activities: How to cope with unwanted Zaleha, Hisham, Mahyuddin

problems
Determine and Contact the Guest Speaker Zaleha
Plan for performances Hannah, Adam
Determine and Contact Guest Performer Hannah
Survey and determine the location Adam
Set Photographer Fahmi
Determine Guest List Zahid, Fadhilah
Send Invitation Zahid, Fadhilah
Contact safety authorities Hisham
Contact the Medical team and prepare First Aid Zaleha
Kit dll
Finalized Budget Maslan, Steven

(6 marks)

6. Add a new slide as Slide #5 using blank layout and create a Column chart based on the
allocated budget below. Insert the chart title “Percentages of Budget Allocation”.
Display the data labels for each item.

Items Percentage
Venue 15%
Activity kits 20%
Food 30%
Printing 5%
Guest Speaker & 20%
Performances
Others 10%
(4 marks)

7. Apply “Fade” Transition to all slides and set time duration for 2 seconds and Advanced
slide After 1 second for each slide transition.
(3 marks)

8. Apply “Appear” animation for each image and “Blind” animation for each title on each
slide.
(3 marks)

9. Save and close the file.

5
CONFIDENTIAL BA/JAN 2023/ASM452/TEST

PART C: MICROSOFT EXCEL (40 MARKS)

OVERVIEW:

You are a marketing executive in Vaccinax Pharmaceutical Corporation. Using excel, you are
required to calculate sales for COVID-19 vaccines and present to your Chief Financial Officer
(CFO).

INSTRUCTIONS:

1. Start Microsoft Excel and create a new workbook. Save the workbook as Hot Excel (Your
Full Name) (Group).

2. Enter the data given below into a worksheet.

(2 marks)

3. Add a title to the table as “VACCINAX PHARMACEUTICAL CORPORATION” (title should

be merged and centered, using Title style, font size 24).
(1 mark)

4. Add subtitle to the table as “SALES FOR COVID-19 VACCINES 2022” (subtitle should be
merged and centered, using Title style, font size 20).
(1 mark)

5. Calculate Total Sales for each vaccine. Use Currency format RM and set to 2 decimal
places.

(4 marks)

6. The formula to calculate Profit=Total Sales x % of Profit Margin. Calculate Profit for each
vaccine using absolute cell reference.
(4 marks)

6
CONFIDENTIAL BA/JAN 2023/ASM452/TEST

7. Using the most appropriate formulas and functions:

a. Find the highest sales for the vaccine

b. Find the lowest sales for the vaccine
c. Find the mean sales for the vaccine
(6 marks)

8. Add new column after column “Profit” and name the column heading as TARGET
ACHIEVEMENT.
(1 mark)

9. Use IF function to determine whether the company have achieved target if the “total
sales” is more or equal to RM500,000 by indicate “ACHIEVED” if the condition is met or
“NOT ACHIEVED” if the total sales is less than RM500,000.
(8 marks)

10. Apply conditional formatting by changing the inserting icon set- 3 symbols (circled)
based on the value below:

a. if the profit of each vaccine is 200,000 and above

if the profit of each vaccine is 100,000 and above but less
b.
than 200,000
c. if the profit of each vaccine is less than 100,000

(6 marks)

11. Insert a 3-D pie chart in a new worksheet that display Total Sales and Vaccine’s Name.

(2 marks)
12. Add a title to the chart as “Sales for COVID-19 Vaccines 2022’’.
(1 mark)

13. Amend the Data Label so that only Value and Category Name are shown on the pie
chart.

(2 marks)
14. Explode the highest sales by 30%.
(2 marks)
15. Save worksheet.

END OF QUESTION PAPER