I T S S H N S: Create Folder or Directory Under Desktop Based On The Following Instruction
I T S S H N S: Create Folder or Directory Under Desktop Based On The Following Instruction
I T S S H N S: Create Folder or Directory Under Desktop Based On The Following Instruction
T
I
S
T
I
N
HS
Task 1
Address :
Phone number :
On the Insert tab, the galleries include items that are designed to coordinate with the overall look of your
document. You can use these galleries to insert tables, headers, footers, lists, cover pages, and other document
building blocks. When you create pictures, charts, or diagrams, they also coordinate with your current document
look.
You can easily change the formatting of selected text in the document text by choosing a look for the selected text
from the Quick Styles gallery on the Home tab. You can also format text directly by using the other controls on
the Home tab. Most controls offer a choice of using the look from the current theme or using a format that you
specify directly.
Save the above information with the name Data source under opc folder
Merge the letter for six people and save with the name Merged data under opc folder
Task 4. Write the bellow paragraph and save on the under opc folder by the file name of
paragraph
On the Insert tab, the galleries include items that are designed to coordinate with the overall
look of your document. You can use these galleries to insert tables, headers, footers, lists,
cover pages, and other document building blocks. When you create pictures, charts, or
diagrams, they also coordinate with your
Task 5.
Prepare system information about your computer using Ms-word and save the file With the
file name called “system info “under opc folder.
System information
Items Description
Operating Name
system version
manufacturer
system Model
type
manufacturer
Processor(s) Speed
type
Bios version
Physical
memory
Hard disk
capacity
TASK 4.
TYPES OF COMPUTER SAVE UNDER OPC FOLDER THE FILE NAME COMPUTER
NETWORK
Geographical
Computer Network
1.1. LAN
Network in the school
1.2. MAN
Network in the country
1.3. WAN
Internet
E-mail
2. Ownership
2.1. Private
Private organization
2.2. Public
Public organization
TASK 6.
SAVE THE INFORMATION UNDER OPC FOLDER THE FILE NAME SYSTEM
INFO
Part I.
1. Open new workbook under the opc folder save by the file name called Student
Mark list
No Name Sex B.date Maths Englishe Bio Civic HPE Chemist Physic
1 Dani M 2/5/2001 69 75 91 89 56 75 67
2 Beti F 1/3/1996 56 59 75 78 45 56 87
3 Adisu M 5/8/1984 58 57 73 65 43 67 34
4 Bekele M 5/10/1975 95 58 69 49 45 76 43
5 Saron F 10/8/1961 48 82 67 82 76 89 56
6 Meron F 6/4/1991 67 46 49 89 87 87 90
7 Hermela F 9/8/1999 94 67 97 94 76 78 80
Based no the above data calculate the following .
1. Rename Sheet 1 with student list?
2. Calculate Total , Average , and Grade mark of each students
3. Calculate The Minimum, Maximum, Remark , ( Comment ) of each students
4. Insert one column between average and grade with the name Rank and calculate their
rank.
5. Insert one column at the last with the name Age and calculate the age.
Rules
Mark Grade Remark
90-100 A Excellent
80-89 B Very good
70-79 C Good
60-69 D Passed
Otherwise F failed