CONFIDENTIAL BA/JULY 2025/BTM452/HOT
UNIVERSITI TEKNOLOGI MARA
HANDS ON TEST
COURSE : BUSINESS APPLICATION ESSENTIALS
COURSE CODE : BTM452
EXAMINATION : JULY 2025
TIME : 3 HOURS
INSTRUCTIONS TO CANDIDATES
1. This test consists of THREE (3) parts: PART A (14 Questions)
PART B (07 Questions)
PART C (15 Questions)
2. Follow all the instructions given in the questions.
3. Submit all the 3 files from Word, Excel, and PowerPoint to your respective lecturers.
NAME: ………………………………………………………………………..
STUDENT ID: ……………………………………………………………….
GROUP: ……………………………………………………………………..
1
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
PART A: MICROSOFT WORD (30 MARKS)
Instructions: Follow the steps below to simulate setting up a short academic research article in Microsoft
Word. Marks are awarded for accuracy, formatting, referencing, and organization.
1. Open a new Microsoft Word document. Save it as (HOT Words_Name_StudentID).
2. Type the following introduction paragraph. Use Times New Roman, font size 12, and justify the
paragraph.
Climate change remains one of the most pressing challenges of our time, affecting
ecosystems, human health, and global economies. The increasing frequency of extreme
weather events and rising sea levels demand urgent global cooperation and innovation.
Researchers and policymakers alike emphasize the importance of sustainable development
practices and technological innovation to mitigate the risks associated with climate change.
In response to these challenges, there is growing interest in leveraging emerging
technologies such as artificial intelligence, renewable energy systems, and climate modeling
tools to predict, adapt to, and reduce the effects of climate change. These innov ations play a
critical role in supporting data-driven policy decisions, optimizing resource use, and fostering
resilience in vulnerable communities. However, the integration of such technologies also
requires careful consideration of ethical, economic, and social implications to ensure
equitable and inclusive climate action.
(3 marks)
3. Insert the title: THE ROLE OF TECHNOLOGY IN CLIMATE CHANGE MITIGATION. Format the
title: Font size 14, UPPERCASE, bold, and center aligned.
(2 marks)
4. Apply double spacing to the paragraph and first-line indent for each paragraph.
(1 mark)
5. After the introduction at the end of second paragraph, insert a citation placeholder using “Add New
Placeholder” and name it Lee2021. Then replace the placeholder with the following source:
(4 marks)
Author: Dr. Sophia Lee
Year: 2021
Title: Green Innovation for a Changing Planet
Journal: Journal of Environmental Technology
Pages: 25–43
2
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
6. Continue the article by typing the content below, as a new paragraph.
One of the key strategies in combating climate change is the development and deployment of
green technologies. These include renewable energy systems, energy-efficient buildings,
carbon capture techniques, and AI-powered environmental monitoring systems. Integrating
such technologies across industries is critical in achieving long-term environmental
sustainability. Furthermore, collaboration between governments, private sectors, and research
institutions is essential to accelerate innovation and deployment. Investment in green
technology not only addresses environmental concerns but also stimulates economic growth
through new job creation.
(3 marks)
7. Insert a subtitle before the new paragraph: Technological Interventions – format it bold, italics, and
center-aligned.
(1 mark)
8. Insert the following table below the paragraph, and label it as shown.
Technology Type Description Potential Impact (%)
Solar Energy Harvesting sunlight for electricity 35
Carbon Capture Storing CO₂ emissions underground 20
Smart Agriculture AI-driven precision farming 25
Green Building Materials Reducing energy in construction and 15
cooling
Table 1: Examples of technology and their estimated impact on climate change mitigation (italicized and
centered).
(5 marks)
9. Apply any appropriate table style. Use Times New Roman, size 12, center the table, and set 1.5
line spacing. Adjust columns neatly.
(2 marks)
10. Insert another citation after the word “sustainability” in the paragraph. Use “Add New Source” with
the following details:
Author: Maria Fernandez
Year: 2022
Title: Leveraging AI for Environmental Protection
Journal: Tech & Sustainability Journal
Pages: 88–95
(2 marks)
3
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
11. On a new page, insert a bibliography using MLA style. Use the heading REFERENCES in bold,
uppercase, centered, and format the list with double spacing, Times New Roman 12pt.
(3 marks)
12. Use the Find and Replace feature to replace the word “impact” with “influence” throughout the
document.
(1 mark)
13. Add the conclusion paragraph:
In conclusion, technology holds immense promise in addressing climate-related
challenges. From clean energy systems to smart agriculture, innovation must be
embraced with urgency and responsibility. Collaboration among governments,
industries, and researchers is essential to ensure a sustainable future.
(1 mark)
14. Insert a header on the left containing your Full Name, Student ID, and Group. Insert a footer with
page numbers using Plain Number 2 format. Close the header/footer.
(2 marks)
4
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
PART B: MICROSOFT POWERPOINT (30 MARKS)
You are required to prepare a presentation slide for WellNet Hub, a digital wellness consultancy focusing
on promoting healthy technology habits. The organization supports balanced screen time, stress
management, and digital mindfulness.
1. Create a new blank PowerPoint presentation and save the file as (HOT
PowerPoint_Name_Student ID).
2. Create Slide #1 with a Title Slide, and do the following:
a. Add title as “DIGITAL WELLBEING FOR A BALANCED LIFESTYLE”
b. Add subtitle as “Prepared by WellNet Hub”
(2 marks)
c. Choose the Ion Theme for the presentation.
(1 mark)
d. Insert any image related to digital wellness, such as a human silhouette. Apply Soft Edges
(5 pt) to enhance the picture.
(2 marks)
3. Add Slide #2 with the Title Only layout, and do the following:
a. Add the title text “EVOLUTION OF DIGITAL WELLNESS AWARENESS”
(1 mark)
b. Insert a Shapes → Rectangle and draw 4 horizontal boxes side by side.
(1 mark)
c. Inside each box, type:
• 2005 – First Studies on Sustainable Practices
• 2012 – Digital Detox
• 2019 – Device Wellbeing Tools
• 2023 – Mindful Tech Design
(2 marks)
d. Add relevant icons or images above/beside each point. Apply color to enhance the style.
Align the shape in the center of the slide.
(2 marks)
4. Add Slide #3 using Two Content, with “DAILY TECH HABITS: HEALTHY VS UNHEALTHY” as
the title and insert a SmartArt list.
a. Enter these items in the Smart Art:
i. Healthy Habits:
20-20-20 Rule
Digital Curfew
Mindful Browsing
5
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
ii. Unhealthy Habits:
Doomscrolling
Device Overuse
Multitasking Burnout Commented [N1]: This is not a complete list as compared
(3 marks) to the answer scheme. Please revise.
b. Use icons or colored rectangles to distinguish each habit.
c. Ensure symmetry and balance in layout.
(2 marks)
5. Add a new slide as Slide #4 using a Title Only layout.
a. Insert a suitable graph that consists of data below.
(4 marks)
o Work – 40%
o Entertainment – 35%
o Social Media – 15%
o Learning – 10%
b. Insert the chart title as “SCREEN TIME DISTRIBUTION IN A DAY”.
(1 mark)
c. Apply any style of chart that shows percentage in the chart.
(1 mark)
6. Add a new slide, Slide #5 with Title and Content layout. Type “5 SIGNS YOU NEED A DIGITAL
BREAK” for the slide title.
(1 mark)
a. Use SmartArt graphic, select radial layout, and add the following suitable icons to list:
• 😠 Irritability
• 👁️ Eye Strain
• 💤 Sleep Disturbance
• 📱 Constant Scrolling
• ❌ Lack of Focus Commented [N2]: Please rephrase the question to make it
(2 marks) clearer.
b. Arrange icons and text in a visually attractive pattern.
(2 marks)
c. Apply any suitable effect as an entrance animation.
(1 mark)
7. Add any suitable transitions between slides and apply to all.
(2 marks)
8. Save and close the file.
6
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
PART C: MICROSOFT EXCEL (40 MARKS)
The worksheet below shows the Property Sales by SURI PROPERTY, ALAM MEGAH which contains the
details of information for each property project
1. Start Excel, then create a new workbook. Then, save the workbook as HOT EXCEL (Your FULL
NAME_GROUP).
2. Enter the data by following the above information. Use Arial 11 font.
(5 marks)
3. Change the formatting for “Total Price (per unit)” and “SubTotal” to Accounting and two decimal
points.
(4 marks)
4. Insert a new column after the “SubTotal” cells and name the “New Info”.
(2 marks)
5. Put the title of “ PROPERTY SALES INFO“ as the table title by using the Arial font 16, uppercase,
and bold. In cell A1.
(3 marks)
6. Next, in the A2 cell, put a subtitle of Monthly Customer Purchasing 2025 and apply Arial font 14 and
bold.
(3 marks)
7. Merge and center cell the titles and subtitles.
(2 marks)
7
CONFIDENTIAL BA/JULY 2025/BTM452/HOT
8. By using the formula, find the
(a) Highest Purchased
(b) Lowest Purchased
(c) Average Purchased
(6 marks)
9. Middle align the No, Name of Property, Selling Quantity (unit), Total price (per unit), Date of
purchased, Subtotal and New Info
(2 marks)
10. Use the IF function (No Project or New Project) to determine whether the next for the construction of
residential buildings will proceed or not. If the value of the Total is more than OR equal to 800000000,
the result should be No Project.
(3 marks)
11. Use the Conditioning Formatting tool for the new info column by changing the colour of the table
containing “New Project” to Green Fill with Dark Green Text.
(4 marks)
12. Using the name of the property and total purchased, create Style 1 3D column chart and name the
chart title as “Total of Property Sales 2025”, bold the title.
(4 marks)
13. Move the chart to a new sheet and name the sheet as “Total Sales”.
(2 marks)
14. Save the document.
END OF QUESTION PAPER
