INTERNATIONAL UNIVERSITY-VIETNAM NATIONAL UNIVERSITY–HCMC MIDTERM EXAMINATION
Business Computing Skills – BA120IU Date: 22nd April 2024 Duration: 90’
Student ID: ......................................Name:................................................
SUBJECT: BUSINESS COMPUTING SKILLS
School of Business Lecturer Signature: Signature: Full name:
Full name: Ton That Long, Ph.D. GENERAL INSTRUCTION(S)
1. Only LAPTOP is allowed in this examination
2. NO INTERNET connection is allowed during the examination.
3. The exam has a total of 100 points
4. Silence needs to be kept during the exam
5. Discussion and Material transfer are strictly prohibited
6. Submission your answers in Blackboard is required. For alternative
approach,please send to email ttlong@hcmiu.edu.vn (only use when submitting to Blackboard cannot be made)
7. Any violation will be considered as cheating and will receive ZERO of this course GOOD LUCK!
PART A (Mixed questions) (20 marks)
Answer the following questions (1 mark/ question) 1 ⓐ ⓑ ⓒ ⓓ 11 ⓐ ⓑ ⓒ ⓓ 2 ⓐ ⓑ ⓒ ⓓ 12 ⓐ ⓑ ⓒ ⓓ 3 ⓐ ⓑ ⓒ ⓓ 13 ⓐ ⓑ ⓒ ⓓ 4 ⓐ ⓑ ⓒ ⓓ 14 ⓐ ⓑ ⓒ ⓓ 5 ⓐ ⓑ ⓒ ⓓ 15 ⓐ ⓑ ⓒ ⓓ 6 ⓐ ⓑ ⓒ ⓓ 16 ⓐ ⓑ ⓒ ⓓ 7 ⓐ ⓑ ⓒ ⓓ 17 ⓐ ⓑ ⓒ ⓓ 8 ⓐ ⓑ ⓒ ⓓ 18 ⓐ ⓑ ⓒ ⓓ 9 ⓐ ⓑ ⓒ ⓓ 19 ⓐ ⓑ ⓒ ⓓ 10 ⓐ ⓑ ⓒ ⓓ 20 ⓐ ⓑ ⓒ ⓓ
1. Through MS Excel, you can _____.
a. Sort data to see it in a different order
b. Filter data to see just pieces of it
c. Use data in formulas to create new data d. All of the above
2. To format the contents of your Excel file, from the cell level to the sheet level, yourefer to _____. a. Home tab b. Insert tab c. Page Layout tab d. Data tab
3. To work with the data in your sheet by adding formulas to the data, you use _____.a. Insert tab b. Review tab c. Data tab d. Formulas tab
4. To save a previously saved workbook with a new name or on a differentdrive,_____.
a. click Save on the File Menu
b. click Save As on the File Menu c. press Ctrl+S d. None of the above
5. The _________ determines how fast a computer can execute instructions. a. Mainboard b. CPU c. Ports d. Hard disk drive
6. Which tab contains the commands for adding content to your worksheet? a. Home tab b. Data tab c. Insert tab d. Formulas tab 7. The .xlsx files _____.
a. are compress xml and formatting files b. are binary files
c. are files in a proprietary format
d. can be opened only by Excel
8. The Ribbon is made up of which of the following _____. a. Tabs b. Groups c. Buttons d. All of the above
9. Which of these file formats can Excel open? a. xlsx b. xls c. xlsb d. All of the above
10. When sharing files with people who are using other versions of Excel, you willneed to _____.
a. send them the .xlsx file, which they will be able to open
b. send them a printout of the file, and tell them to mark it up and you will edit it
c. save your file as an .xls file, which they will be able to open
d. you cannot share files with people using older versions of Excel
11. When a formatted number does not fit within a cell, it displays _____. a. ##### b. #DIV/0 c. #DIV@ d. None of these
12. What symbol is used to enter number as text? a. ' b. " c. = d. +
13. Which of the following is concatenating operator? a. Apostrophe (') b. Exclamation (!) c. Ampersand (&) d. Hash (#)
14. To select multiple non-adjacent cells in a worksheet you will click them holding_____. a. Ctrl key b. Alt key c. Shift key d. Ctrl+Shift key
15. Hardware is any part of the computer that has a _______________structure.a. Physical b. Element c. Minor d. Liquid
16. Which of the following component displays the contents of active cell? a. Name box b. Formula bar c. Menu bar d. Status bar
17. A quick way to return to a specific area of a worksheet is to type in the _____. a. Name box b. Formula bar c. Zoom box d. None of these
18. RAM is a (Random Access/ Rarely Access/Read Only/Right Arm) memory a. Random Access b. Rarely Access c. Read Only d. Right Arm
19.One of the three three essential components for Internet access include (an Internet
Service Provider (ISP)/a router/a computer/an Internet browser) a. Internet Service Provider (ISP) b. Payment c. Router d. None of the above
20.Power supply unit sends power to the motherboard and other components by a. Wireless b. Internet c. Cables d. Thought PART B (80 marks) Q1. (60 marks)
a. Create a spreadsheet Cosmetics Survey and then create following tables
Table 1. Cosmetics Sold Survey in 09/2023 Name of Order Code of Brand Unit Reward Bill date Cosmetic Quantity Cost ID Cosmetics s name Price ($) / Gift 1 Day 22 MR1 5 2 Day 04 CM2 4 3 Day 05 MOD3 6 4 Day 17 ER1 4 5 Day 05 PM2 5 6 Day 14 LD1 8 7 Day 02 PM1 2 8 Day 07 MOD3 8
Table 2. Unit Price of Products Unit Price Name of Product ID REVLON Product DEBON MAYBELINE M Mascara $ 270 $ 360 $ 180 C Cream $ 350 $ 150 $ 90 MO Moisturiser $ 450 $ 550 $ 320 E Eyeliner $ 100 $ 120 $ 150 P Primer $ 200 $ 210 $ 230 L Lipstick $ 120 $ 160 $ 140 Table 3. Brand name Code Brand name R1 MAYBELINE M2 DEBON OD3 REVLON D1 DEBON M1 REVLON
Use formulae to fill in the columns Name of Cosmetics, Brand name, Unit Price ($),
Cost, and Reward/Gift in Table 1. These values can be obtained as follows: Name of Cosmetics:
The values are obtained based on Table 2 Brand name :
The values are obtained based on Table 3 Unit Price ($) :
The values are obtained based on Name of Product and depending on types of Brand
name in Table 2. Cost :
Use the formula Cost ($) = Unit Price ($)*Quantity. However, if the product is
DEBON, 5% reduction is applied to the Cost ($). Reward/Gift :
If the product is either REVLON or MAYBELINE, write LV Wallet; otherwise, leave as blank cell. [28 marks]
b. Use the results obtained in part a, fill in the following table Moisturise
Name of Cosmetics Mascara Cream
Eyeliner Primer Lipstick r Sold quantity Total Cost [8 marks]
c. Apply Conditional formatting to highlight the information in Table 1 which satisfies
both maximum value of Cost and Reward/Gift as LV Wallet. [6 marks]
d. In the same sheet, using results obtained in part b, plot suitable chart with full format
(Chart title+ Chart axis with names) to show Total cost of each product names. [8 marks]
e. Use information given in Table 1 to create Pivot Table and Pivot Chart as follows [10 marks] Q2. (20 marks)
Create a spreadsheet named Forecast. A survey on number of sells is done. The data is recorded as follows:
Table 4. Survey on sell Period 1 2 3 4 5 6 7 Sales 20 32 51 43 62 63 82
Use proper method to predict the number of sales corresponding to the periods from 8
to 12. Show clearly how to obtain the result and record the new results in a new table.