Exercise # 1 Working with Microsoft Excel
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom : .5”
Left : .5”
Right : .5”
Click OK button
Type the following:
3
45
32
345
23
22
35
189
Click File, click Print Preview
Edit the data (Press F2 or Double click the cell)
Change 189 to 289
Click File, click Save, enter the filename
File name: exer1.xls
Note: if you want to save for worksheet in your diskette just
include A:\ before the filename.
Click File, click Close
Click File, click Exit
_________________________________________________________________________
Exercise # 2 Microsoft Excel Resizing and moving window
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Landscape
Paper Size: 8.5”x14”
Click Magins Tab
Top : 1”
Bottom : 1”
Left : 1”
Right : 1”
Click OK button
Minimize the Application Window
Click the control menu, click minimize or click the minimize
button located at the upper left portion of your worksheet.
Restore your document
To restore double click the ICON restore at the top left
portion of the window.
Resize the document window
Position your mouse pointer anywhere on the border of your
window. When the mouse pointer changes to two-headed arrow
click and drag the mouse. Release the mouse.
Moving the document window
Position the mouse pointer on the Title Bar. Click the
left mouse button and drag it to the left.
Click File, click Close
Click File, click Exit
_________________________________________________________________________
Exercise # 3 Sorting Cells
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom: .5”
Left : .5”
Right : .5”
Click OK button
Move down five rows
Click the down arrow key 5 times
Move up 2 rows2
Click the up arrow key 2 times
Move right 10 columns
Click the right arrow key 10 times
Move left 2 columns
Click the left arrow key 2 times
Type the following:
Red
Orange
Blue
Yellow
White
Pink
Violet
Gray
Highlight A1 to A8.
Click the Sort Ascending button
Highlight A1 to A8. Change the font size to 16. Look what
will happen
Click File, click Exit
Note: Don’t save your work
_________________________________________________________________________
Exercise # 4 Selecting Cells, Ranges and resizing column
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom: .5”
Left : .5”
Right : .5”
Click OK button
Select cell B8
Position the mouse pointer on cell B8 and click the left mouse
button.
Type Room
Select range A2:D20
Position the mouse pointer to cell A2
Click and drag the mouse pointer to cell D20
Release the mouse button.
Select range B2, D4, E25, F12 and C17
Hold down the CTRL key
Click the B2, D4, E25, F12, and C17
Select all columns on A
Click column heading A
Note: All of the rows on A will be highlighted
Select column B and C
Select rows G15 and column E
Resizing column
To resize the column click the column heading that
you want to resize (A, B, C, D, E….)
Move the mouse pointer on the edge of the column,
the mouse pointer will change to black
color and becomes a cross with 2 headed arrow.
Drag the mouse.
_________________________________________________________________________
Exercise # 5 Inserting Border, using Decimal and comma style
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom: .5”
Left : .5”
Right : .5”
Click OK button
Type the following:
SCHOOL LOT AREA
BUST 323,452,345
GUP 234,234,341
MATENEO 123,231
TEU 2,121,212
Click File, click Print Preview or click
Note: The document has no border
To insert a border
Highlight the cell(s) or range A1 to B5
Click the Border Icon
Click the All borders icon
SCHOOL LOT AREA
BUST 323,452,345
GUP 234,234,341
MATENEO 123,231
TEU 2,121,212
Click Print preview or click
Note: To resize the column click the column heading that
you want to resize. Move the mouse pointer on the edge of
the column, the mouse pointer will change to black color
and becomes a cross with 2 headed arrow.Drag the mouse.
Add the following to column C
SCHOOL LOT AREA AMOUNT
BUST 323,452,345 2150214545
GUP 534,234,341 7125489872
MATENEO 123,231 3254894
TEU 2,121,212 325418784
To insert decimal places and comma
Highlight cell C2 to C5
Click increase decimal icon twice.
Click comma style icon.
SCHOOL LOT AREA AMOUNT
BUST 323,452,345 2,150,214,545.00
GUP 534,234,341 7,125,489,872.00
MATENEO 123,231 3,254,894.00
TEU 2,121,212 325,418,784.00
Add border to column C1 to C5
Click Print Preview or click
Click File, click Save
Enter the Filename
Click File, click Exit
_________________________________________________________________________
Exercise # 6 Centering data using Merge and Center command
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom: .5”
Left : .5”
Right : .5”
Click OK button
Type the following:
BINAUGANAN
CUT-CUT I
POBLACION
SAN VICENTE
MATATALAIB
SAN SEBASTIAN
LIGTASAN
SAN NICOLAS
SAN ROQUE
STO. CRISTO
SAN JUAN DE BAUTISTA
MABINI
STA. CRUZ
TARIJI
BALIBAGO I
SALAPUNGAN
SEPUNG CALZADA
DALAYAP
ALVINDIA
BUHILIT
BANABA
CENTRAL/HOMESITE
MAPALACSIAO
LOURDES
ASTURIAS
BUENAVISTA
Sort the data in ascending order
Add the following headings:
Note: To add a row. Position the mouse on the
desired row (A1).
Click Insert menu, click Rows.
To merge two cells highlight cell A1 to B1, click
the merge and Center icon.
Add a border
Tarlac City
Place Population
ALVINDIA 344
ASTURIAS 6556
BALIBAGO I 2334
BANABA 2342
BINAUGANAN 1313
BUENAVISTA 5677
BUHILIT 4344
CENTRAL/HOMESITE 2343
CUT-CUT I 1323
DALAYAP 3443
LIGTASAN 2453
LOURDES 2344
MABINI 2342
MAPALACSIAO 2344
MATATALAIB 1234
POBLACION 3134
SALAPUNGAN 23424
SAN JUAN DE BAUTISTA4344
SAN NICOLAS 345553
SAN ROQUE 2434
SAN SEBASTIAN 6785
SAN VICENTE 7453
SEPUNG CALZADA 34434
STA. CRUZ 5767
STO. CRISTO 24244
TARIJI 5657
Save your work in your diskette with a filename “Tarlac”
Close Microsoft Excel
_________________________________________________________________________
Exercise # 7 Saving a workbook with different filename or location
Open Microsoft Excel
Click File Menu
Click Open
Open Tarlac file
Click OK button
Add the following:
Republic of the Philippines
Tarlac City
Place Lot Area Population
ALVINDIA 524 344
ASTURIAS 54,879 6556
BALIBAGO I 579 2334
BANABA 4,784 2342
BINAUGANAN 6,587 1313
BUENAVISTA 9,725 5677
BUHILIT 24,874 4344
CENTRAL/HOMESITE 49,947 2343
CUT-CUT I 5,498 1323
DALAYAP 487,514 3443
LIGTASAN 548 2453
LOURDES 547 2344
MABINI 4,876 2342
MAPALACSIAO 457 2344
MATATALAIB 3,658 1234
POBLACION 6,548 3134
SALAPUNGAN 548 23424
SAN JUAN 698 4344
SAN NICOLAS 478 345553
SAN ROQUE 698 2434
SAN SEBASTIAN 3,254 6785
SAN VICENTE 7,485 7453
SEPUNG CALZADA 3,654 34434
STA. CRUZ 3,254 5767
STO. CRISTO 12,545 24244
TARIJI 4,875 5657
Save your work with a different filename
Click File, click Save As
Filename: Places.xls
Click SAVE button
Close Microsoft Excel
_________________________________________________________________________
Exercise # 8 Renaming a Sheet
_________________________________________________________________________
Open Microsoft Excel
Click File Menu
Click Open
Open Tarlac file
Click OK button
Right click sheet1 tab
Click Rename. Type Places
Right click sheet2 tab
Click Rename. Type Voters
Type the following:
BARANGAYS PRECINT # # OF REG. VOTERS
1998
AGUSO 1A 200
1A1 167
2A 200
2A1 58
3A 200
3A1 30
4A 200
4A1 195
5A 200
5A1 116
6A 159
7A 81
8A 153
9A 198
2157
ALVINDIA 10A 200
10A1 12
11A 200
11A1 144
556
AMUCAO 12A 200
12A1 70
13A 200
13A1 185
14A 200
14A1 21
15A 70
16A 80
1026
Exercise # 9 Using Formula Function
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Landscape
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom: .5”
Left : .5”
Right : .5”
Click OK button
Type the Following:
Student no. Student Name Prelim Midterm Final Average
99-091 Bond, Mighty G. 78 78 78
99-827 Bondage, James T. 85 86 77
99-231 Pie, Erik H. 97 87 76
99-123 Sy, Jonathan S. 78 87 79
99-122 Agota, Michelle F. 84 89 84
99-132 Peralta, Havok T. 76 83 75
99-001 Labork, Chucky U. 87 86 76
99-623 Wong, Edwin T. 82 78 74
99-016 Dela Cruz, Say Y. 84 94 82
99-991 Talon, Talon T. 79 78 87
To use the Formula Function
Select cell F2
Type = average(C2:E5) and press ENTER key
To use formula to all cells at once
Position the mouse pointer to the lower right
(fill handle) of cell F2, the pointer becomes
a cross, drag the mouse down to cell F11.
Student no. Student Name Prelim Midterm Final Average
99-091 Bond, Mighty G. 78 78 78 78
99-827 Bondage, James T. 85 86 77 82.66666
99-231 Pie, Erik H. 97 87 76 86.66666
99-123 Sy, Jonathan S. 78 87 79 81.33333
99-122 Agota, Michelle F.84 89 84 85.66666
99-132 Peralta, Havok T. 76 83 75 78
99-001 Labork, Chucky U. 87 86 76 83
99-623 Wong, Edwin T. 82 78 74 78
99-016 Dela Cruz, Say Y. 84 94 82 86.66666
99-991 Talon, Talon T. 79 78 87 81.33333
Use only two decimal places:
Highlight cell F2-F11. Click Decrease decimal icon 5 times
Sort the data according to last name.
Save your work in your diskette with a filename Grade.xls
_________________________________________________________________________
Exercise # 10 Copying and Moving Data
Open Microsoft Excel
Click File Menu
Click Page Setup
Click Page Tab
Orientation: Portrait
Paper Size: 8.5”x11”
Click Magins Tab
Top : .5”
Bottom: .5”
Left : .5”
Right : .5”
Click OK button
Open the file Grade.xls
Note: You have two workbooks open. Book1 and Grade
Copy Student No. and Student Name to Book1
Student no. Student Name
99-091 Bond, Mighty G.
99-827 Bondage, James T.
99-231 Pie, Erik H.
99-123 Sy, Jonathan S.
99-122 Agota, Michelle F.
99-132 Peralta, Havok T.
99-001 Labork, Chucky U.
99-623 Wong, Edwin T.
99-016 Dela Cruz, Say Y.
99-991 Talon, Talon T.
Type the following:
See sample output
SAMPLE OUTPUT
INTERWORLD COLLEGES
Ninoy Aquino Ave., Tibag, Tarlac City
Attendance Sheet
Subject:_____________________ Room:___________________
Day and Time:________________ Teacher:___________________
Student no. | Student Name | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | |
99-091 | Bond, Mighty G. | |||||||||||
99-827 | Bondage, James T. | |||||||||||
99-231 | Pie, Erik H. | |||||||||||
99-123 | Sy, Jonathan S. | |||||||||||
99-122 | Agota, Michelle F. | |||||||||||
99-132 | Peralta, Havok T. | |||||||||||
99-001 | Labork, Chucky U. | |||||||||||
99-623 | Wong, Edwin T. | |||||||||||
99-016 | Dela Cruz, Say Y. | |||||||||||
99-991 | Talon, Talon T. |
Format Cell
Position the mouse pointer to column heading C, then drag
the mouse up to column heading T.
Click Format
Click Column
Click Width…
Type 3, then click OK buton
Center the Heading
Click Print Preview then close print Preview (this is done
to display the paper size, broken line indicates paper
margin.
Highlight the text that you want to center.
Example: Highlight cell A1 to cell T1
Click Merge and Center icon
Sort the Data
Highlight student no. 99-091 to 99-991, Student Name Bond,
Mighty G. up to Talon, Talon T.
Click the Sort Ascending icon
Note: Use the Border icon to insert borders
Use the Merge and Center icon to Center the Heading
Save you work in your diskette with a filename Attend.xls
Close Microsoft Excel
_________________________________________________________________________
EXERCISE # 11 – Using Word Art
Change the paper setup to
Margin Top - .5”
Left - .5”
Right - .5”
Bottom - .5”
Orientation Landscape
Click the Insert WordArt Icon
Select the WordArt style by double clicking the box
Type your text in the text box (you can edit the text
by changing the Font style, size, bold, italics etc.)
Click OK
TO EDIT WORDART/TO RESIZE AND REPOSITION WORDART
Click the WordArt
A outside border will be displayed
To reposition the Wordart drag the text
To resize WordArt point the mouse pointer to any
of the borders then drag the mouse.
note: You can use the Word art toolbars to edit
your text
INSERT WORDART - It is use to add WordArt
EDIT TEXT - it is use to change or edit the text
WORDART GALLERY – It is use to edit the Word Art
style
FORMAT WORDART – It is use to change the color and
lines, size,etc.
WORDART SHAPE – it is use to change the shape of
the WordArt to stop sign, plain, circle etc.
FREE ROTATE – it is use to rotate the Word Art.
Note : to rotate, click the free rotate icon
then point to any yellow circle of the
edge of the text. Then drag the text.
WORDART SAME LETTER HEIGHTS - It is use to change
the size of all letters to a specific height.
Note: It will make the text all CAPS.
WORDART VERTICAL TEXT – It is use to align the text
vertically
WORDART ALIGNMENT – It is use to align the text
WORDART CHARACTER SPACING – It is use to change the
spacing of the text. ( Normal, tight, loose, etc..)
_________________________________________________________________________
EXERCISE # 12 – Inserting a picture ( POSTER)
Change the paper setup to
Margin Top - .5”
Left - .5”
Right - .5”
Bottom - .5”
Orientation Landscape
Insert a WordArt
Insert a picture
1. Click the Insert clip Art Icon
2. Click the category (example: click the
animal icon)
3. Click magic then click the insert clip art
4. Close the Clip Art Window by clicking the
x icon
note: change the size and position of the clip
Art by dragging the image
OUTPUT:
_________________________________________________________________________
EXERCISE # 13 – Inserting a picture and using the picture toolbar ( RECEIPT)
Change the paper setup to
Margin Top - .5”
Left - .5”
Right - .5”
Bottom - .5”
Orientation Landscape
I. Type the following
II. Insert a picture
1. Click the Insert clip Art Icon
2. Click the category (example: click the animal icon)
3. Click magic then click the insert clip art
4. Close the Clip Art Window by clicking the x icon
note: change the size and position of the clip Art
by dragging the image
note: to change the image click the image then click
the image contol click the gray scale and
click the watermark.
To display the picture toolbar click the view in the
menu bar then click the toolbars then click
picture toolbar.
INSERT PICTURE FROM FILE – it is use to insert picture
from file.
IMAGE CONTROL – It is use to change the image to
automatic, gray scale, black and white and watermark.
MORE CONTRAST AND LESS CONTRAST – it is use to change
the image contrast
MORE AND LESS BRIGHTNESS- It is use to change the
image brightness
CROP – It is use to crop the image
LINE STYLE - It is use to change the line style
FORMAT PICTURE - It is use to change the color
and lines, size,etc.
SET TRANSPARENT COLOR – It is use to set the image
to transparent.
RESET THE IMAGE PICTURE – It is use to reset the
picture to its original size, color etc.
OUTPUT:
_________________________________________________________________________
EXERCISE # 14 – using color (font, fill and line color) and using rectangle
Change the paper setup to
Margin Top - .5”
Left - .5”
Right - .5”
Bottom - .5”
Orientation Portrait
I. Type the following
II. Insert a rectangle
1. Click the Rectangle Icon then drag the pointer
to make a box
2. Drag the box in the text
3. To change the color to transparent click fill
color drop down list box the icon, then a color
window will appear, click the no fill.
4. To change the line select or click the
rectangle then click the line icon then select
the line style.
III. Change the font color to BLUE
1. To change the font color highlight all the
fonts then click the drop down list box of the
font color the click BLUE
SAMPLE OUTPUT
STUDENT EVALUATION FORM
Name of Student ___________________________________________
Course ________________________ Major _____________________
Directions: Check the number that best describes the
student’s performance
Rating: 5 – Excellent 4 – Very Good 3 – Good 2 – Fair 1 – Poor
FIRST SEMESTER/FIRST YEAR
Subject Code SUBJECTS UNITS GRADE
Eng113 Communication Arts 3
Math2 College Algebra 3
Fil1 Kasanayan sa Pakikipagtalastasan3
EDP1 Intro. to Comp. Scie. 6
CA1 Comp. Architechture 3
Typing Basic Typing 3
PE1 Self Test Activities 2
MS11 ROTC 1.5
SECOND SEMESTER/FIRST YEAR
Eng.112 Communication Arts 3
Fil.2 Panitikang Filipino 3
Nat.Sci1Physics 3
Os101 Operating System 3
CS101 Data Structure 6
PE2 Fundamentals of Rhythmic Act. 2
MS12 ROTC 1.5
FIRST SEMETER/SECOND YEAR
Eng.213 Technical Writing 3
Nat.Sci Physics2 3
EDP2 Foxbase1 6
CA2 Computer Architecture 6
PE3 Group Sports 2
MS 21 ROTC 1.5
SECOND SEMESTER/SECOND YEAR
Eng.223 Business Correspondence 3
Math3 Plane Trigonometry 3
EDP3 Foxbase2 6
Soc.Sci5Rizal Life,Works,and Writing 3
HUM Phil.History 3
PE 4 PE 4 2
MS 22 ROTC 1.5