Title | 2021 Eng Exercises Book practise more |
---|---|
Author | hồng anh |
Course | Tin học đại cương |
Institution | Trường Đại học Ngoại thương |
Pages | 112 |
File Size | 4.2 MB |
File Type | |
Total Downloads | 214 |
Total Views | 380 |
FOREIGN TRADE UNIVERSITY BASIC SCIENCES FACULTY INFORMATICS DEPARTMENTSeptember 2021INFORMATICS Exercises Microsoft Word Table of Contents Microsoft Excel Part I: Simple Exercises Part II: Financial Functions Part III: Database Management Exercises Microsoft PowerPoint Multiple choice - Chapter 1, 2...
FOREIGN TRADE UNIVERSITY BASIC SCIENCES FACULTY INFORMATICS DEPARTMENT
September 2021
INFORMATICS Exercises
Table of Contents Microsoft Word ...........................................................................................................................3 Microsoft Excel .........................................................................................................................34 Part I: Simple Exercises ............................................................................................................34 Part II: Financial Functions .......................................................................................................47 Part III: Database Management Exercises ................................................................................50 Microsoft PowerPoint ...............................................................................................................63 Multiple choice - Chapter 1, 2, 3 ..............................................................................................75 Multiple choice - Chapter 4 ......................................................................................................81 Multiple choice - Chapter 5 ......................................................................................................92 Multiple choice - Chapter 6 ....................................................................................................104 Key – Multiple choice - Chapter 1-6 ......................................................................................108 Key Financial Function ..........................................................................................................109
FTU - Informatics Department
Page 2
INFORMATICS Exercises
Microsoft Word
MICROSOFT WORD Exercise 1
Type 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.
Times New Roman Red Verdana Brown
FOREVER FRIENDS A shoulder to cry on, An ear to bend,
Arial Yellow
Verdana Bold, Blue
Clothes to lend,
Verdana Bold, Blue
Being together,
Times New Roman Bold, Dard blue
Our “private” talks. Tahoma Bold, Pink
Crying those tears, Planning our future, May they never end Always together,
Arial Italic, Violet
Arial Italic, Violet
Friday night movies,
Mending our hearts, Arial Italic, Violet
Tahoma Green
Forever Friends
FTU - Informatics Department
Arial Italic, Violet
Times New Roman Bold, Dard blue
Page 3
INFORMATICS Exercises
Microsoft Word
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.
FTU - Informatics Department
Page 4
INFORMATICS Exercises
Microsoft Word
Exercise 3
Use Multilevel List
Format line spacing: Before 0pt, After 0pt, Line spacing: Multiple 1.2 lines
SAMPLE OUTLINE Title: Frederick Douglass Thesis: Frederick Douglass played a crucial role in securing the abolition of slavery and equality of African American rights through his actions, ideas, and efforts as a lecturer, author/publisher, and politician. 1. Introduction 1.1. Thesis 1.2. Roles/ Arguments 2. Douglass as Lecturer 2.1. History as slave and acquisition of education 2.1.1. He “experienced slavery” 2.1.2. Literacy allowed expression 2.2. Early lectures, including initial speech before Garrison 2.2.1. Success of initial speech 2.2.2. Goals for future speeches 3. Douglass as Author/Publisher 3.1. Narrative’s success and effect 3.1.1. Springboard for paper 3.1.2. Goals/hopes for paper 3.2. Garrison set-back and significance 4. Douglass as Politician 4.1. Key trait for success 4.2. Efforts for Republican party 4.2.1. Significance of efforts 4.2.2. Black soldier enlistment crusade 5. Conclusion 5.1. Thesis 5.2. Summarize arguments and efforts Place, … day … month … year Signature
Mai Phuong, Le FTU - Informatics Department
Page 5
INFORMATICS Exercises
Microsoft Word
Exercise 4
Apply Bullets and Numbering or Multilevel List for paragraphs
Table: Create tables, clear borders; change font, size THE MINISTRY OF FINANCE
SOCIALIST REPUBLIC OF VIET NAM Independence - Freedom - Happiness
No. 23/2013/TT-BTC Hanoi, February 27, 2013 CIRCULARPROVIDING THE COLLECTION LEVELS, REGIME OF COLLECTION, EMITTANCE, MANAGEMENT AND USE OF CHARGES OF TESTING FOR DRIVING ROAD MOTOR VEHICLES Pursuant to the Law on Road traffic No. 23/2008/QH12, of November 13, 2008; Pursuant to the Ordinance on fees and charges No. 38/2001/UBTVQH10, of August 28, 2001; Article 1. Subjects of application 1. The participants of testing (Vietnamese and foreigners) for grant of permit of driving road motor vehicles are subject of payment of charges of testing for driving road motor vehicles as prescribed in this Circular. 2. Agencies managing the testing for grant of permit of driving road motor vehicles as prescribed by law on road traffic are agencies performing the collection of charges. 3. This Circular does not apply to the testing for grant of permit of driving for army and public security forces on their duty for national defense and security. Article 2. Charges 1. Charges of testing on driving road motor vehicles are provided as follows: a. For testing for driving motorcycle (ranks of A1, A2, A3, A4): -
Theory testing: 40,000 dong/once;
-
Practice testing: 50,000 dong/once;
b. For testing for driving automobile (ranks of B1, B2, C, D, E, F): -
Theory testing: 90,000 dong/once;
-
Practice testing in pictures: 300,000 dong/once;
-
Practice testing on public roads: 60,000 dong/once;
2. Charges of testing for driving road motor vehicles are applied in uniformity in nationwide when agencies managing the testing of grant of driving permit hold the testing of grant of permit for driving road motor vehicles. 3. The participants of testing for grant of permit of driving road motor vehicles in a part shall pay charges of testing of that part. FOR THE MINISTER OF FINANCE DEPUTY MINISTER FTU - Informatics Department
Page 6
INFORMATICS Exercises
Microsoft Word
Exercise 5
Format text to separated newspaper columns, borders, highlight colors; Create Drop cap at the beginning of paragraphs
Compare features of OpenOffice with Microsoft Office
P
reviously, success
the 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 born. For example, the Mozilla FireFox web
browser has more features and stability than Internet Explorer and especially the OpenOffice software suite, which functions similar to the Microsoft Office software suite.
T
herefore, recently, the
Ministry of Education and Training has
issued
a
written
request for units to use the free
and
open
source
In addition, in the trend of
software suite instead of
integration,
the
Microsoft Office, which is
compliance with copyright
understandable to enforce
and intellectual property
copyright
laws is indispensable.
intellectual property of
laws.
and
WTO.
Acer Vietnam introduces the Gold Warranty package
ACER
Vietnam has just introduced the Gold Warranty for laptops - a new service
pack to bring customers peace of mind. This service pack will expand the warranty coverage as well as ensure maximum benefits for customers. Laptops with a Gold Warranty will be warranted for an additional 1 year for both accidental, unintended risks such as dropping, hitting,
If
the damage is less than 200,000 VND,
customers will be repaired and replaced for free. If the damage is greater than the customer, you only need to pay 30%.
breaking, breaking, being struck by lightning and damage due to water being poured into the Main components of a laptop.
FTU - Informatics Department
Page 7
INFORMATICS Exercises
Microsoft Word
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)
FTU - Informatics Department
Page 8
INFORMATICS Exercises
Microsoft Word
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: ............................ dated: ...................................... Unit: ........................................................................................................................................ Address: .................................................................................................................................. Account: ................................................................................................................................. 2/ Authorized person: Full name: .................................................. Position: ............................................................ ID card number: .......................issued by: ............................ dated: ...................................... 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 activities. AUTHORIZED PERSON
RIGHTS
(Sign, write full name)
(Sign, write full name)
FTU - Informatics Department
Page 9
INFORMATICS Exercises
Microsoft Word
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 career: ....................................................................................................................... Foreign language 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 not open. 2. Pay the tuition fees according to requested dates. Ha Noi, date…month…year 20… Signature
FTU - Informatics Department
Page 10
INFORMATICS Exercises
Microsoft Word
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, dated … … ……, at ………………………, we are: PARTY A:
PARTY B:
VIET TAN, NGUYEN Address
:
Tran Hung Đao
Tel
:
8.598466-8.65972
Tax code
:
0101737373
Account No
:
0011001245667
Represented by
:
Mr Viet Tan, Nguyen
Position
:
Chief Business Officer Chief Commercial Officer
Address
:
Hai Ba Trung
Tel
:
4.598466-4.65972
Tax code
:
0101537373
Account No
:
001100245667
Represented by
:
Mr Van An, Le
Position
:
Chief Commercial Officer
VAN AN, LE
After discussion, Party A agrees to buy and Party B agrees to sell garment product with the terms and conditions as follows: Artice 1: Name of goods – Quantity – Price – Party A shall design the product sample ...