Title | 2021-10 Eng Exercises Book |
---|---|
Author | Nguyễn Vũ Duy |
Course | Tin học đại cương |
Institution | Trường Đại học Ngoại thương |
Pages | 83 |
File Size | 3.3 MB |
File Type | |
Total Downloads | 44 |
Total Views | 518 |
FOREIGN TRADE UNIVERSITY BASIC SCIENCES FACULTY INFORMATICS DEPARTMENTSeptember 2021Informatics Exercises FTU - Informatics Page Microsoft Word TABLE OF CONTENTS Microsoft Excel Part I: Simple Exercises Part II: Financial Functions Part III: Database Management Exercises................................
FOREIGN TRADE UNIVERSITY BASIC SCIENCES FACULTY INFORMATICS DEPARTMENT
September 2021
Informatics Exercises
TABLE OF CONTENTS Microsoft Word......................................................................................................................... 3 Microsoft Excel........................................................................................................................ 33 Part I: Simple Exercises..................................................................................................... 33 Part II: Financial Functions................................................................................................46 Part III: Database Management Exercises.........................................................................49 Microsoft PowerPoint.............................................................................................................62 Financial Function Key..........................................................................................................73
FTU - Informatics
Page 2
Informatics Exercises
Microsoft Word
MICROSOFT WORD Exercise 1
Compose this poem, change font, font color for letters in below poem sentences. Each sentence has its own font and color.
Adjust space between lines (paragraphs) and save into your own folder in My Documents. Tahoma Green Times New Roman Red
FOREVER FRIENDS A shoulder to cry on, An ear to bend,
Verdana Brown Arial Yellow
Friday night movies, Verdana Bold, Blue
Arial Italic, Violet
Clothes to lend,
Being together,
Times New Roman Bold, Dard blue Tahoma Bold, Pink
Arial Italic, Violet
Our “private” talks. Arial Italic, Violet
Mending our hearts,
Verdana Bold, Blue
Crying those tears, Planning our future, May they never end
Arial Italic, Violet
Always together,
Times New Roman Bold, Dard blue
Forever Friends
FTU - Informatics
Page 3
Exercise 2
Change from Vietnamese typing mode to English typing mode
Use AutoCorrect function for the word “Christmas”
Format line spacing: Before 6pt, After 6pt, 1.5 lines
History of Christmas Christmas also referred to as Christmas Day, is an annual holiday celebrated on December 25 that commemorates the birth of Jesus Christ. The day marks the beginning of the larger season of Christmastide, which lasts twelve days. The nativity of Jesus, which is the basis for the anno Domini system of dating, is thought to have occurred between 7 and 2 BC. December 25 is not known to be Jesus' actual date of birth, and the date may have been chosen to correspond with either a Roman festival or the winter solstice. Modern customs of the holiday include gift-giving, Church celebrations, and the display of various decorations - including the Christmas tree, lights, mistletoe, nativity scenes, and holly. Santa Claus (also referred to as Father Christmas, although the two figures have different origins) is a popular mythological figure often associated with bringing gifts at Christmas for children. Santa is generally believed to be the result of a syncretization between Saint Nicholas and elements from pagan Nordic and Christian mythology, and his modern appearance is believed to have originated in 19th century media.
Exercise 3
Use Multilevel List
Format line spacing: Before 0pt, After 0pt, Line spacing: Multiple 1.2 lines
SAMPLE OUTLINE Title: Factors affecting customers' E-commerce adoption behavior in Vietnam: An application of Theory of Planned Behavior. 1. INTRODUCTION 1.1 Research background 1.2 Research procedure 2. LITERATURE REVIEW 2.1 Theory of E-commerce 2.1.1 Definition of e-commerce 2.1.2 The development of e-commerce 2.2 Theory of customer behavior 2.3 Theory of TPB Model 2.3.1 The basis of TPB model 2.3.2 Several recent studies using TPB model in Vietnam 3. RESEARCH DESIGN 3.1 Research model 3.2 Research hypotheses 3.3 Data Collection and analysis 3.3.1 Data collection 3.3.2 Data analysis 4. RESEARCH RESULT 4.1 Sample description 4.2 Descriptive statistics of variables 4.3 Hypothesis test 4.4 Discussion 5. CONCLUSION 5.1 Findings and contribution 5.2 Implication 5.3 Limitations Hanoi, day … month … year … Signature
Mai Phuong, Le
Exercise 4
Apply Bullets and Numbering or Multilevel List for paragraphs
Table: Create tables, clear borders; change font, size MINISTRY OF FINANCE
SOCIALIST REPUBLIC OF VIETNAM Independence - Freedom - Happiness
No. 38/2015/TT-BTC
Hanoi, March 25, 2015 CIRCULAR
ON CUSTOMS PROCEDURES, CUSTOMS SUPERVISION AND INSPECTION, EXPORT DUTY, IMPORT DUTY, AND TAX ADMINISTRATION APPLIED TO EXPORTS AND IMPORTS Pursuant to the Law on Customs No. 54/2014/QH13 dated June 23, 2014; Pursuant to the Law on Export and import duty No. 45/2005/QH11 dated June 14, 2005; ... Article 1. Scope 1. This Circular deals with customs procedures, customs supervision and inspection, export duty, import duty, and tax administration applied to exports and imports. 2. Separate instructions of the Ministry of Finance on customs procedures, customs supervision and inspection shall apply to the following types of exports and imports: a) Exports and imports sold at duty-free shops; b) Postal packages exported or imported via postal network; exports or imports sent by express mail; ... Article 10. Application of various modes of customs inspection customs procedures for exports or imports ... 3. Customs inspection of exported, imported, and transited goods of conformable enterprises shall be carried out as follows: a) Documents shall be inspected directly in the following cases: -
Violations against regulations of law on customs are suspected;
-
Not more than 5% of goods on the customs declaration is selected on the basis of risk analysis and assessment;
-
Direct document inspection must be carried out as prescribed by corresponding regulations of law. FOR THE MINISTER OF FINANCE DEPUTY MINISTER
Exercise 5
Format text to separated newspaper columns, borders, highlight colors; Create Drop cap at the beginning of paragraphs
COMPARE FEATURES OF OPENOFFICE AND MICROSOFT OFFICE
P
reviously, the success of Microsoft Corporation's Office suite overshadowed all other office software. However, with the time, and the strong development of open source programs, many free programs with similar functions were issued. For example, the Mozilla FireFox web
T
browser has more features and stability than Internet Explorer and especially the OpenOffice software
Ministry of Education and Training
suite, which functions
has issued a written
similar to the Microsoft
request for units to use the
Office software suite.
free and open source
In addition, in the trend of
software suite instead of
integration, the
Microsoft Office, which
compliance with
is understandable so as to
copyright and intellectual
enforce copyrights and
property laws is
intellectual property
indispensable.
rights of WTO.
herefore, recently, the
ACER VIETNAM INTRODUCES THE GOLD WARRANTY PACKAGE
ACER
Vietnam has just introduced the Gold Warranty for laptops
a new service package to bring customers peace of mind.
breaking; damage by lightnings and water for the components of a laptop.
If
main
the damage costs less than
This service package will expand the warranty
200,000 VND, customers will get free repaire and
coverage as well as ensure maximum benefits for
replacement. If the damage is
customers. Laptops with a Gold Warranty will be
greater, you only need to pay
warranted for an additional 1 year for both accidental, unintended risks such as dropping,
30%.
hitting, breaking,
Exercise 6
Format and use Tabs; use ruler to adjust margins
Format Bullets and Numbering or Multilevel List SOCIALIST REPUBLIC OF VIET NAM Independence - Freedom - Happiness To: CITES Viet Nam Management Authority
1. Name of requested enterprise and individual -
Enterprise: Full name of the enterprise in Vietnamese and transaction name in English (if any): -
Individual: Full name as appeared in ID/Passport:........................................................................
-
ID/Passport:................................. date: ............................... place: .................................................
2. Address -
Enterprise: Address of head office, Business registration number and date of issue: .................. -
Individual: Permanent Address: .....................................................................................................
3. Request: ......................................................................................................................................... 4. Name of species -
Scientific name (Latin name): ........................................................................................................
-
Common name (English, Vietnamese): .........................................................................................
-
Quantity (in words: …..): ...............................................................................................................
-
Unit (individual, kg, piece …): ......................................................................................................
-
Purpose of requesting for CITES permit, certificate: ....................................................................
5. Origin of specimens:..................................................................................................................... 6. Detailed description (size, status, type of products …):........................................................... 7. Name and address of exporting and importing organization, individual in Vietnamese and in English (if any): ........................................................................................................................ 8. Expected exporting, importing time: ......................................................................................... 9. Export, import border gate (specify border gate’s name and country): ............................... 10. Attached documents:.................................................................................................................... … date … month … year … Signature (Organization: specify Full name and position of the authorized person and stamp; Individual: specify Full name)
Exercise 7
Use table; set and use Tab; space between lines.
Company.......................................
SOCIALIST REPUBLIC OF VIETNAM
.......................................................
Independence - Freedom - Happiness
Number: .... / UQ / 20 ...
LETTER OF ATTORNEY 1/ Authorizing person: Full name: ................................................... Position: ............................................................ ID card number:........................issued by: ............................ date: ........................................ Unit: ........................................................................................................................................ Address: .................................................................................................................................. Account: ................................................................................................................................. 2/ Authorized person: Full name: .................................................. Position: ............................................................ ID card number:.......................issued by: ............................ date: ........................................ Unit: ....................................................................................................................................... Address: .................................................................................................................................. 3/ Content of authorization: Withdraw cash from deposit accounts at your Bank Get cheque from issued bank Credit cash into account Get account statement and other transactions 4/ Term of authorization: From date ... month ... year 20 ... 5/ Other regulations The authorized person is responsible for performing the work within the scope of authorization, must not authorize another person and takes responsibility before law for the authorized person for his / her actions. AUTHORIZED PERSON (Sign, write full name)
RIGHTS (Sign, write full name)
Exercise 8
Table: Create tables, clear borders; change font, size.
Insert symbols; then copy and paste to other locations.
Format and use Tab; use ruler to adjust margins
Format Bullets and Numbering or Multilevel List
HANOI DEPARTMENT OF EDUCATION AND TRAINING AN PHAT INFORMATICS CENTER 1 Hai Ba Trung - Hanoi
(04) 8.356.888
Diverse subjects
(04) 8.356.888
Modern classrooms
(04) 8.356.888
Quick contact
(04) 8.356.888
Provide IT software
(04) 8.356.888
REGISTRATION OF INFORMATION TECHNOLOGY COURSES PART FOR OFFICE STAFF: Staff name:.................................................................................................................................... Class: ............................................................... Course: ............................................................. Course date and time: ....................................... Opening: .......................................................... PART FOR STUDENT: Full name (in capital letters):........................................................................................................ Date of birth:..................................................... Place of birth: ................................................... Address: ........................................................................................................................................ University/School: ........................................................................................................................ Professional careers: ..................................................................................................................... Foreign languages and skills: ....................................................................................................... Health: .......................................................................................................................................... Note:
Attach two color photos (3x4cm) for the graduation certificate.
The graduation certificate will be issued upon request.
Commitment: 1. No refund in any case except classes are not open. 2. Pay the tuition fees according to requested dates. Ha Noi, date … month … year 20… Signature
Exercise 9
Table: Create table, clear borders; change font, size and type for letters.
Format and use Tab; use ruler to adjust margins. FTC COMPANY
SOCIALIST REPUBLIC OF VIET NAM Independence - Freedom - Happiness
PURCHASE AND SALE CONTRACT No.: …. /SV/ HDMB-FTC
– Pursuant to the Commercial Law with the effect from 01 January 2006. – Pursuant to the Civil Code with the effect from 01 January 2006. Today, date........................, at....................................., we are: PARTY A (Buyer): (Mr.) Viet Tan, Nguyen Addres
:
Tran Hung Đao
s Tel
:
8.598466-8.65972
Tax code
:
0101737373
Account No
:
0011001245667
Represented
:
Mr Viet Tan, Nguyen
by
:
Chief Business Officer Chief Commercial Officer
Position PARTY B (Seller): (Mr.) Van An, Le Addres
:
Hai Ba Trung
s Tel
:
4.598466-4.65972
Tax code
:
0101537373
Account No
:
001100245667
Represented
:
Mr Van An, Le
by
:
Chief Commercial Officer
Position After discussion, Party A agrees to buy and Party B agrees to sell garment product with the terms and conditions as follows: ARTICLE 1: NAME OF GOODS – QUANTITY – PRICE – Party A shall design the product sample and send it to Party B. Party B shall offer the fabrics as required by Party A and Party A shall sign the fabric sample to be used to make the product for Party B as a basis for production according to the sample of Party A.
– Party B shall be fully responsible for the specification and quality of goods – based on the sample mentioned above. Party A shall have the right to notify Party B in writing of the
quantity of products which fail to meet quality requirements (if any, such as patchy color, lack of fiber, dirty cloth, etc.), and the two parties shall discuss to find the most appropriate and effective solution (such as repair, exchange, return, etc.). ARTICLE 2: Time – Location – Method of delivery – Time of delivery: Party B shall deliver goods to Party A within 30 days from the date on which the parties sign the reference sample (packaged products). – Place and method of delivery: Party B shall deliver goods to Party A at Ho Chi Minh Port according to FOB conditions. – Shipping documents required for each shipment: + VAT invoice: 01 original + Packing list: 01 original and 02 copies ARTICLE 3: Payment – Payment shall be made by bank transfer in 02 installments: + 1st installment: Party A shall pay 50% of the total contract value to Party B after the contract is signed. + 2nd installment: Party A shall pay the remaining 50% of the total contract value to Party B just before delivery. ARTICLE 4: General terms – Any dispute arising out of or in connection with this contract shall be settled by the parties in a spirit of cooperation within 01 month from the date on which the dispute arises. After that, if no agreement can be reached by the parties, either party shall have the right to refer the dispute to the competent People’s Court in accordance with the provisions of law for settlement. The decision of the court shall be final and binding on the parties. – This contract is made in 02 original copies. Each party keeps 01 copy with equal legality for implementation. – The contract, after the implementation of the two parties, if there are no complaints or disputes, shall be deemed liquidat...