Microsoft Office 2010 Practicum Module

TABLE OF CONTENTS

CHAPTER 1 INTRODUCTION TO MICROSOFT WORD 2010 3

DIFFERENCE BETWEEN TAB, RIBBON AND GROUP 4
UNDERSTANDING THE ICON FUNCTIONS ON THE HOME RIBBON .................. 4
Group Clipboard 4
Group Font 4
Group Paragraph 5
Group Styles 6
Group Editing 6
UNDERSTANDING THE FUNCTION OF ICONS ON THE INSERT RIBBON... 6
Group Pages 6
Group Tables 7
Group Illustrations 7
Group Links 7
Group Header & Footer 8
Group Text 8
Group Symbols 8
GETTING TO KNOW THE ICON FUNCTIONS ON THE PAGE LAYOUT RIBBON. 8
Group Themes 9
Group Page Setup 9
Group Page Background 9
Group Paragraph 10
Group Arrange 10

CHAPTER 2 EXERCISES - MICROSOFT WORD 2010.................. 11

EXERCISE 1 Block Paragraph And Increase Indent .............................. 11
EXERCISE 2 First Line Indent, Tabulation and Numbering ................ 13
EXERCISE 3 Editing Text, Numbering and Bullets ..................... 14
EXERCISE 4 Setting Margins and Paper Size .............................. 15
EXERCISE 5 Creating a Table of Contents with Tabulation Symbols and Leaders
............................................................................................................ 16
EXERCISE 6 Creating Exam Questions 18
EXERCISE 7 Creating a Table 19
EXERCISE 8 Using Illustrations 20
EXERCISE 9 Creating a Cover With a Frame................................. 21
EXERCISE 10 Header, Footer, and Page Number ............................. 22
EXERCISE 11 Drop Cap And Page Column 23
EXERCISE 12 Creating Diagrams with Smart Art........................... 25

CHAPTER 3 INTRODUCTION TO MICROSOFT EXCEL 2010 26

MICROSOFT EXCEL 2010 COMPONENTS 27
Row Heading 27
Column Heading 27
Cell Pointer 27
Formula Bar 27
MOVING THE CELL POINTER.......... 27
USING FUNCTIONS 28
Microsoft Office 2010 Practical Module

Average Function 28
Logical IF Function 28
Max Function 28
Minimum Function 28
Sum Function 28
Left Function 28
Mid function 28
Right Function 29
The functions HLOOKUP and VLOOKUP. 29

CHAPTER 4 MICROSOFT EXCEL 2010 EXERCISES................... 30

EXERCISE 1 Creating a Simple Table........................................... 30
EXERCISE 2 Using Calculation Operator Functions And Functions
Statistics .............................................................................................. 31
EXERCISE 3 Using Calculation Operator Functions And Functions
Statistics .............................................................................................. 32
EXERCISE 4 Custom Data Format, Increase Decimal And Decrease
Decimal 33
Exercise 5
Custom 34
EXERCISE 6 If Function And Countif 35
EXERCISE 7 Vlookup And Hlookup Functions 37
EXERCISE 8 Functions Left, Mid, and Right 39
EXERCISE 9 Creating Graphs (Chart) 40
EXERCISE 10 Setting Margins and Printing Documents .............. 41

CHAPTER 5 INTRODUCTION TO MICROSOFT POWERPOINT 2010................ 42

FEATURES IN POWERPOINT 2010 43
POWERPOINT 2010 COMPONENTS 43
RIBBON TAB DESIGN 44
RIBBON TAB ANIMATIONS 44
RIBBON TAB SLIDE SHOW 45
RIBBON TAB VIEW 45

CHAPTER 6 CREATING A SIMPLE PRESENTATION 46

Preparing Documents 46
Creating a Simple Presentation 47
Giving Transition Effects on Slides............................... 48
Adding Animation Effects to Objects............................ 49
Displaying Presentation 49
Microsoft Office 2010 Practicum Module

CHAPTER I
INTRODUCTION TO MICROSOFT WORD 2010

Microsoft Office Word 2010 (hereinafter referred to as MS. Word only)

is a word processing application program created by Microsoft
Corporation. MS. Word 2010 is the result of the development of several versions.
Previously, MS. Word appeared more user-friendly and has adopted the ribbon.
as a new standard in displaying tool menus. According to their claims,
ribbon is an innovation that will eventually become a standard in the future
for the menu display.

Image 1
Microsoft Office Word 2010

For those who have just migrated from Word 2003 to MS. Word 2010, there is no need to panic.
with such an unfamiliar view. You just need a little adaptation and
After that, you will feel the efficiency and ease in working. If you
If you are unsure, please open MS. Word 2010, place the mouse pointer in the area.
menu, then turn the scroll button. What happens? You are right! You
can open the access door to each ribbon just by turning the scroll button.
Returning to the menu icon issue, MS. Word 2010 recognizes the terms tab, ribbon,
and group in presenting the tool menu. Different from Word 2003 and earlier
which is almost 100% controlled by the Barbarian Class (Menu Bar and Toolbar).
Microsoft Office 2010 Practicum Module

Microsoft Office Word 2010 can be activated through the Start menu - All Programs.
–Microsoft Office–Microsoft Word 2010. Or it can be done by double-clicking
Click the Microsoft Word 2010 icon on the desktop to display a screen like Figure 1.

1. DIFFERENCE BETWEEN TAB, RIBBON AND GROUP

The tab is a series of menus marked by text. It consists of the File tab, Insert,
Page Layout, etc. The ribbon is a collection of menus in each tab. While
A group is a set or group of menus within each Ribbon that has
function similarity. So, the Tab provides a Ribbon, the Ribbon consists of several
Group, and Group consists of a set of menus that have similar functions.

Image 2
Tab, Ribbon, and Group Display in Word 2010

2. INTRODUCING THE ICON FUNCTIONS ON THE HOME RIBBON

The Ribbon Home consists of several Groups namely, Clipboard, Font, Paragraph,
Styles and Editing.

2.1 Group Clipboard

The Group Clipboard consists of a set of menus, namely:

Image 3
Group Clipboard Display

Paste: to attach the results of copy or cut.

[Link]: to cut selected text/object.
[Link]: to duplicate the selected text/object.
4. Format Painter: used to replicate the document page formatting to
in other documents.

2.2 Group Font

The menus in the Font Group specifically function for formatting related to
letter. Consists of:

Image 4
Group Font Display

[Link]: to choose the typeface

Microsoft Office 2010 Practical Module

2. Font Size: to adjust the font size

[Link] Font: to instantly increase the font size
4. Shrink Font: to instantly reduce the font size
Change Case: to change the status of uppercase/lowercase letters
[Link] Formatting: to remove the formatting of the selected text
[Link]: to bold the selected text
Italic: to italicize selected text
Underline: to give a underline to the selected text
[Link]: gives a strikethrough mark to the selected text
[Link]: to type exponent characters
[Link]: to type exponent characters
Text Effect: to give an artistic effect to the selected text
Text Highlight Color: to provide a highlighter color behind the text
selected
[Link] Color: to set the color of the selected text.

2.3 Group Paragraph

Group Paragraph consists of a collection of menus that share the same function.
to arrange the text paragraph. The commands in the Paragraph Group are:

Image 5
Group Paragraph Display

1. Bullets: to provide a bullet point in each selected paragraph

[Link]: to provide a numbering format in each selected paragraph
3. Decrease Indent: to shift the second line of the paragraph to the left
4. Increase Indent: to move the second line of the paragraph to the right
5. Left-to-Right: to make the text direction run from left to right
(format Latin)
[Link]-to-Left: to make the text direction run from right to left
(Arab format)
[Link]: to sort data
[Link] Paragraph Marks: to display/hide paragraph marks
paragraph correction
9. Align Text Left: to arrange text left aligned
[Link]: to center align text
[Link] Text Right: to align text to the right
12. Justify: to align the text both right and left
13. Line Spacing: to adjust the distance between lines of text
14. Shading: to set the background color of selected text
[Link]: to provide a border for the selected text.

2.4 Group Styles

Group Styles consists of two menus. They are:
Microsoft Office 2010 Practical Module

Image 6
Group Styles Appearance

[Link] Styles: contains options for formatting the selected paragraph titles
2. Change Styles: contains options for paragraph theme settings

2.5 Group Editing

In general, the group Editing consists of Find, Replace, and Select. its function
is

Image 7
Group Editing Display

1. Find: to search for a specific word based on a certain input keyword

in a file
[Link]: to search for and replace found words to be replaced
with specific words in a file
[Link]: used to select a specific object or text within a file

3. INTRODUCING THE ICON FUNCTIONS ON THE INSERT RIBBON

The Insert tab is used to insert objects into the managed document.
Both in the form of image objects, tables, shapes, and special characters (symbols). Even
With the Insert tab, users can insert a link to a file that is located outside.
documents, even to the internet. In general, the commands found in the Insert Ribbon
consists of 7 command groups that have similar functions. Some groups that
located in this tab are: Pages, Tables, Illustrations, Links, Header & Footer,
Text and Symbols.

3.1 Group Pages

Image 8
Group Pages Display

1. Cover Page: Used to insert and select the type of page

cover
[Link] Page: To insert a new blank page into a file
document
3. Break Page: To separate a page in a document file
3.2 Group Tables
Microsoft Office 2010 Practicum Module

Image 9
Group Tables Display

[Link] Table: To insert a table using the Insert Table dialog

2. Draw Table: To insert a table by drawing in
document page
3. Convert Text to Table: Used to make the selected text into a table
in the table
4. Excel Spreadsheet: To insert a table in the form of a worksheet
Excel
5. Quick Table: To insert an instant table that is already available type and
its form in MS. Word 2010

3.3 Group Illustrations

Image 10
Group Illustrations Display

[Link]: Used to insert images that are saved in

computer
Clip Art: To insert illustration images that are available in
library program
3. Shapes: Used to insert autoshape image objects
4. SmartArt: Used to insert images in the form of
organization
[Link]: Used to insert a diagram

3.4 Group Links

Image 11
Group Links Display

1. Hyperlink: Used to link selected text/object with a file.

lain
Bookmark: Used to create a bookmark
[Link]-Reference: Used to create references between files

3.5 Group Header and Footer

Microsoft Office 2010 Practical Module

Image 12
Group Header and Footer Display

[Link]: Used to set up the header of a file

Footer: Used to set the footer of a page
file
3. Page Number: Used to set the humor
page

3.6 Group Text

Image 13
Group Text Display

Text Box: Used to insert a box that can be filled with

text
2. Quick Parts: Used to manage automatic text and others
[Link]: Used to insert artistic styled text
4. Drop Cap: Used to insert a capital letter at the beginning
paragraph
[Link] Line: Used to insert a digital signature
6. Date & Time: Used to insert the current date and time
7. Object: Used to insert objects with OLE (Object Extension)
Linking Embedded

3.7 Group Symbols

Image 14
Group Symbols Display

[Link]: used to insert equation symbols,

especially in the field of mathematics.
2. Symbol: used to insert special characters.
4. INTRODUCING THE ICON FUNCTIONS ON THE RIBBON PAGE LAYOUT

The command icons found in the Page Layout Tab are used for layout settings.
document page layout. This tab consists of 5 groups of commands, namely:
Themes, Page Setup, Page Background, Paragraph, dan Arrange.
4.1 Group Themes
Microsoft Office 2010 Practical Module

Image 15
Group Themes Display

[Link]: Used to select a page theme that includes colors

the color of the letters on the next page.
Color: Used to set the theme color of the page.
3. Fonts: Used to set the font theme that will be applied to
active document page.
4. Effect: Used to set the theme of effects on Shape objects.
found on the document page.

4.2 Group Page Setup

The menus available in the Page Setup group are provided to perform
page settings, namely in the fields of paper size, page margins,
text column settings, etc. Document pages can be arranged according to
user's desire, especially to synchronize with type and size
the paper that will be used later. The command menu available in
The group Page Setup includes: Margins, Orientation, Size, Columns, Breaks, Line
Numbers, and Hyphenation.

Image 16
Group Page Setup Display

[Link]: Used to set the text boundaries on the document page.

2. Orientation: Used to set the paper position.
[Link]: Used to set the page size.
[Link]: Used to set the number of text columns.
5. Breaks: Used to control the continuity of pages and columns.
text.
[Link] Numbers: Used to arrange the continuity of the text line numbers.
7. Hyphenation: Used to separate syllables with a sign
connect automatically.

4.3 Group Page Background

The commands in the Page Background group are used to set the background.
the back page of the document file being worked on. There are three command menus:
Watermark, Page Color, and Page Borders.

Image 17
Group Page Background Display

1. Watermark: Used to provide a watermark effect behind the text.

Microsoft Office 2010 Practicum Module

2. Page Color: Used to set the background color of the page.

3. Page Borders: Used to set the page border lines.

4.4 Group Paragraph

The command menu in the Paragraph Group is generally used for
settings regarding text paragraph. Meanwhile, the commands contained in
this group: Indent, and Spacing.

Image 18
Group Page Display Paragraph

1. Indent: Used to set text boundaries

2. Spacing: Used to adjust the distance between paragraphs.

4.5 Group Arrange

In general, the commands in this group are used to arrange: Position
objects between the text, the position of objects with other objects, and arrange alliances
objects on the document page.

Image 19
Group Page Arrangement View

1. Position: Used to arrange the position of objects within a page.

[Link] Text: Used to arrange the position of objects in relation
with the paragraph text
3. Bring Forward: Used to position an object with
other objects
4. Send Backward: Used to send the selected object backward.
other objects
5. Selection Pane: Displaying the object navigation panel
[Link]: Used to arrange the position of loose objects
7. Group: Used to cluster several objects into one.
group
8. Rotate: Used to rotate and flip a selected object.
Microsoft Office 2010 Practice Module

CHAPTER 2
EXERCISES - MICROSOFT WORD 2010

EXERCISE 1

PARAGRAPH BLOCK AND INCREASE INDENT

Instructions:

1. Activate the menuJustify icon

2. Use the increase indent menu icon

Tika Bravani

Jl. Arif Rahman Hakim No. 9

Karawang

January 20, 2011

To

Dear Mr./Mrs. Principal

State Junior High School 1 Rawamerta

Street Complex Education

Rawamerta

Karawang

With respect,

Subject: Application

Based on the information I received from one of the teaching staff at SMP Negeri 1
Rawamerta, that in the school you lead, there is a need for a staff member.
teacher of Information and Communication Technology (ICT) subjects.
Microsoft Office 2010 Practicum Module

In relation to this matter, I intend to submit a job application to

the school that you lead.

I am skilled in operating computers, whether it's Microsoft Office office applications.

or in hardware repairs.

To complete this application letter, I attach a resume, a photocopy

last diploma and photo.

Thank you for your attention, Sir.

Yours sincerely,

Tika Bravani

3. Save the document that has just been created. The way:

Click menu File - Save (Ctrl + S)

After that, a Save As dialog box will appear as below. Specify
storage location then specify the document name (File Name). Give a name
document becomes "Exercise 1"
Click the Save button (press the Enter key) to save.

Image 20
Save As Dialog Window
Microsoft Office 2010 Practical Module

EXERCISE 2

FIRST LINE INDENT, TABULATION, AND NUMBERING

1. First Line Indent functions to indent the first line of each paragraph that
pushed somewhat inward. used to create letter model paragraph
Indent.
2. The TAB key (Tabulation) means to move to a field or input area or selection.
next. During the typing process, TAB means jump to the TAB stop.
closest.
3. Numbering is used to automatically assign numbers to
the selected paragraph.

Subject: Job Application Bandung,

January 26, 2011

To Whom It May Concern.

Human Resources Manager

PT. Gilland Ganesha

Jalan Raya Kebon Durian No. 11

East Jakarta

Respectfully,

In accordance with the job vacancy offer from PT. Gilland Ganesha, such as
published in the Kompas newspaper on January 24, 2011. I am submitting myself to
joined the Marketing Team at PT. Gilland Ganesha.

My brief data is as follows:

Full Name Andreas Hermansyah

Place / Date of Birth Bandung, March 21, 1988

Last Education Bachelor of Computer Science

ITENAS Bandung

Address Gurame Street No. 165 Bandung

Phone / E-mail 081909159969 –

andreaz_hermansyah@[Link]
Microsoft Office 2010 Practical Module

I have very good health and can speak English.

well both orally and in writing. My educational background is very
satisfying and skilled in the field of computerization. I have become accustomed to
working with a computer. Especially operating MS package applications
Office, such as Excel, Word, Access, PowerPoint, Outlook, as well as the internet, and letters.
writing in English.

Currently, I work as a Marketing staff at PT. Hilmy Finance. I am happy.

to learn, and to be able to work independently as well as in a team effectively.

As a consideration, I attach:

1. Curriculum Vitae.
2. A photocopy of the bachelor's degree and transcript.
3. Photocopy of course/training certificate.
4. Recent passport photo.

I hope you would be willing to take the time to give

the interview opportunity, so I can explain in more detail
about my potential.

Thus, this application letter, and thank you for your attention, Sir/Madam.

Yours sincerely,

Andreas Hermansyah
Microsoft Office 2010 Practicum Module

EXERCISE 3
EDITING TEXT, NUMBERING, BULLETS

Type the script below.

Difference between 32-bit and 64-bit OS

There are several comments asking about the difference between Windows 32-bit
When should one use Windows 32-bit, and when should one use 64-bit?
Windows 64-bit? Especially since most of the latest hardware CPUs already support it.
64-bit. Microsoft FAQRabout the difference between 32-bit and 64-bit that I
translate freely with some alterations:

What is the difference between 32-bit and 64-bit?

The terms 32-bit and 64-bit refer to how computer processors (also called
CPU), handling information. 64-bit versionWindows handles a large number of random
RAM access is more effective than a 32-bit system.

2. Which OS version should I install: 32-bit version or 64-bit version?

To install the 64-bit OS version, you must have a CPU on the system.
You who can run the 64-bit version of Windows. Benefits of using 64-bit
the operating system is most evident when you have a large amount of RAM
installed on your computer, usually 4 GB RAM or more. In that case,
because a 64-bit operating system can handle a larger amount of memory
more efficient than 32-bit operating systems. 64-bit operating systems can be more responsive
when running several programs at the same time and often switching between
program.

3. Can a 32-bit program run on a 64-bit operating system?

Many programs can run, but 32-bit programs can run more.
slow on 64-bit operating system and 32-bit drivers cannot run on the operating system
64-bit

4. Can a 64-bit program run on a 32-bit operating system?

All 64-bit programs cannot run on a 32-bit operating system. So
the drivers cannot work.

From the writing above, it can be concluded as follows:

If your computer has only 4 GB of RAM or less, it's better to use
OS 32-bit, especially notebooks that typically only have 2 memory slots where 1 is
the slot can only be filled with a maximum of 2 GB, for the driver usually the company
the notebook only provides a 32-bit driver.
If your computer has more than 4 GB of RAM, please use a 64-bit OS.
noting that you cannot use some old hardware that
the driver is not available from the manufacturer. The 64-bit OS is useful for work.
heavy, like rendering in 3Ds Max, basically those that are heavy.
Microsoft Office 2010 Practicum Module

EXERCISE 4
CREATING A TABLE

A table is a storage place for data that consists of columns (Column) and
row. In addition, the table also contains cells which are intersections
between columns and rows. The MenuTable is found on the Ribbon Insert - Table.

1. KlikTable–Insert Table.
2. Determine Number of
Columns(number of columns)
3. Specify Number of Rows
(number of lines)
4. ClickOK

How to add rows and columns to a table

:
1. Right-click on the cell you want
add columns or rows.
2. Then it will appear like the image
below. You choose one of them.
Insert column to the left
add a column on the left
Image 24 Insert column to the right=
Insert Table
add a column on the right
Insert rows above = add
top line
Insert rows below = add
bottom line

Create a table like the one below. Arrange it first:

Top 4 cm
Bottom 3 cm
Left 3 cm
Right 3 cm
Size Letter /Quarter
Orientation Landscape

DEPARTMENT OF EDUCATION, YOUTH AND SPORTS

KARAWANG REGENCY
STATE JUNIOR HIGH SCHOOL 1 RAWAMERTA

GRADE LIST: Class IX Z

Name Value Value
No Student Daily Daily Total Explanation
UTS UAS
1 2
1 Threeum Virat 75 80 80 85 320 GRADUATED
2 Pamanahrasa 76 78 83 87 324 GRADUATED
Gondewa
3 Iwan 75 81 84 86 326 GRADUATE
Hathairattanakool
4 Kijaga Reksa 80 82 79 84 325 GRADUATED
5 Yunk Icikibunk 74 75 76 81 306 GRADUATED
6 Deden Sarip Kasep 65 63 70 66 264 FAIL
Microsoft Office 2010 Practice Module

CHAPTER 3
INTRODUCTION TO MICROSOFT EXCEL 2010

Microsoft Office Excel 2010 (hereinafter referred to as MS. Excel)

is a spreadsheet application program created by Microsoft Corporation.
MS. Excel 2010, like MS. Word 2010, is a product of development from
previous versions. MS. Excel appears more user friendly and has already
using a ribbon as the new standard for displaying tool menus.
According to their claim, ribbon is an innovation that will be in the future
becoming a standard for the menu display.
Before we begin discussing Microsoft Excel 2010, it is best that we
get to know earlier how the appearance of Microsoft Excel is, along with some terms
common terms that will be used.

Image 29
Microsoft Office Excel 2010

To activate Excel 2010, Click Start–All Programs–Microsoft

Office - Microsoft Excel 2010. Or double click the Microsoft Office Excel 2010 icon in
desktop. Then a screen will appear like the image above. Generally not far
different from the Excel 2007 version.
Microsoft Office 2010 Practical Module

1. MICROSOFT EXCEL 2010 COMPONENTS

1.1 Row Heading

Row Heading is an indicator of the row location in the worksheet
the active. Row Heading also serves as one part of the indicator
sel (will be discussed after this). The number of lines provided by Microsoft.
Excel has 65,536 rows.
1.2 ColumnHeading
Column Heading is an indicator of the column location on the sheet.
active work. Similarly to Row Heading, Column Heading also
serves as one part of the cell indicator (will be discussed after this).
Column in symbols with letters A–Z and their combinations. After column Z, we
You will encounter columns AA, AB to AZ, and then columns BA, BB to BZ, and so on.
up to the last column which is IV (totaling 256 columns). Truly a
a very large worksheet, isn’t it? (65,536 rows with 256 columns).

1.3 Cell Pointer

Cell Pointer is the active cell pointer. A cell is
the intersection of columns and rows. Cells are named according to the position of the column.
and row. Example. Cell A1 means the intersection between column A and row 1.

1.4 Formula Bar

The Formula Bar is where we type the formulas that will
we will use later. In Microsoft Excel, typing a formula must be preceded by
with the sign "= " . For example, we want to sum the values contained in
Select A1 and B1, then you can type =A1+B1 in the formula bar.
2. MOVING THE CELL POINTER

The Cell Pointer serves as an indicator of the active cell. What is meant by the active cell
is the cell that will perform a certain operation. To move the pointer
Using the mouse can be done by clicking on the desired cell. For the cell
that are not visible we can use the Scroll Bar to scroll the screen
until the desired cell is visible, then click on that cell. For certain conditions, we
it is better to use the keyboard. Here is a list of the keys used for
moving the pointer with the keyboard:

Button Function
←↑→↓ Move one cell left, up, right or down.
Tab Move one cell to the right
Enter Move one cell down
Shift + Tab Move one cell to the left
Shift + Enter Move one cell up
Home Move to column A on the selected row
Ctrl + Home Move to cell A1 on the active sheet
Ctrl + End Move to the last cell position that is currently being used.
PgUp Move one screen up
PgDn Move one screen down
Alt + PgUp Move one screen to the left
Alt + PgDn Move one screen to the right
Move from one worksheet tab to the tab sheet
Ctrl + PgUp
next
Move from one worksheet tab to the worksheet tab
Ctrl + PgDn
previously
Microsoft Office 2010 Practical Module

3. USING FUNCTIONS

The actual function is a formula that has been provided by Microsoft Excel, which
will assist in the calculation process. we just need to utilize it accordingly
with the requirements. In general, the writing of functions must be accompanied by
arguments, whether in the form of numbers, labels, formulas, cell addresses, or ranges. These arguments must
written in parentheses ()

Some commonly used functions:

3.1Function Average(...)
This function is used to find the average value of a set of data (range).
The general form of its writing is =AVERAGE(number1,number2,…)
where number1, number2, and so on are the data ranges to be searched
the average value.
3.2 IF(...) Logical Function
This function is used when the input data has certain conditions.
For example, if the value of cell A1=1, then the result is 2; if not, it will be 0.
Usually, this function is assisted by relational (comparison) operators such as the following:

Symbol Function
= The same as
< Smaller than
> Greater than
<= Less than or equal to
>= Greater than or equal to
<> Not the same as

3.3 MaxFunction(...)
This function is used to find the highest value from a collection of data (range).
The general form of its writing is =MAX(number1,number2,…), where
number1, number2, and so on are the range of data (numeric) that will
the highest value is sought.

3.4 Min(...) Function

Similarly to the max function, the difference is that the min function is used to find
the lowest value from a set of numerical data.

3.5Function Sum(...)
The SUM function is used to add a set of data in a
range. Shape general writing function this is
=SUM(number1,number2,…). Where number1, number2 and so on
is the range of data to be summed.

3.6 Function Left(…)

The left function is used to take characters from the left side of
a text. The general form of writing is =LEFT(text,num_chars).
Where the text is the data that will take part of its characters from the side.
left, num_chars is the number of characters to be taken.

3.7 Function Mid(…)

This function is used to take a portion of the middle characters from
a certain text. Form general usage function this is
Microsoft Office 2010 Practical Module

=MID(text,start_num,num_chars). It means taking a number of characters

starting from start_num, as much as num_char.

3.8 Right(…) Function

This function is the opposite of the left function, while the left function takes
a number of characters from the left side, then the function takes a certain number of characters
from the right side of the text.. The general form of writing is
=RIGHT(text,num_chars). Where text is the data to be retrieved
some characters from the right side, num_chars is the number of characters
that will be taken.
3.9 HLOOKUP and VLOOKUP Functions
The HLOOKUP and VLOOKUP functions are used to read a table.
horizontally (VLOOKUP) or vertically (VLOOKUP). Form
the general writing of this function is:

=HLOOKUP(Lookup_value, Table_array, Row_index_num,…)

=VLOOKUP(Lookup_value, Table_array, Col_index_num,...)

From the formula above, it can be seen that the only difference is in the index number.
So, if we use HLOOKUP, it uses the row index number.
(Row_index_num), but if using VLOOKUP, the column index number is used.
(Col_index_num). The index number is a number that indicates the position of a certain
column/row in the table that starts with number 1 for column/row
first in that data range.
Microsoft Office 2010 Practicum Module

CHAPTER 4
EXERCISES – MICROSOFT EXCEL 2010

EXERCISE 1
CREATING A SIMPLE TABLE

Create a table like the image below. Pay attention to the position of the table, rows, and width.
column.

STATEJUNO
IRHG
IHSCHOOL1RAWAMERTA

RawamertaEducationComplexStreet

TEACHER REGISTRATION LIST

STATEJUNO
IRHG
IHSCHOOL1RAWAMERTA

NAME ACCOUNT MATA

No ADDRESS
COMPLETE Facebook Twitter LESSON
1 NewSugiana BambooSand UusSugiana - Sundaneselanguage

2 Sarip Komarna Sukamerta DedenSaripKasep - IPA

3 Kasturi AgusCholik Farewell MuskAgusCholik @kasturi46 Mathematics
4 Tri Wiratno Majalaya ThreeumVirat @ThreeumVirat IPS
5 Tibih Subanda Bekasi Tibih Subanda - IPS
6 Nur Rahmat Kurniawan Sukamerta OnlyRahmatKurniawan @nurrahmatk IPS
7 Cum Wiarsih Sukamerta CucumWiarsih - Mathematics
8 Istiana Ekawati Sukamerta IstianaEkawati - Indonesianlanguage
9 Syarifah Badriah Introduction SyarifahBadriah - PAI
10 Tatin Laraswati Foretelling Tatin Laraswati - Sundanese
11 ImasRahmawati Introduction ImasRahmawati - IPA
12 Dedi Kusnaedi Sukapura PamanahrasaGondewa - Indonesianlanguage
13 Gilang Purnama Sukaraja Gilang Purnama @pagil_ang Mathematics/ICT
14 Suwardi Eka Cipta Glossary Okok'aAmethyst @Okok_Amethyst English/ICT
15 Iwan Kurniawan Sukapura Iwan Hathairattanakool @Kang_KunKun TIK
Microsoft Office 2010 Practical Module

EXERCISE 2
USING CALCULATION OPERATOR FUNCTIONS AND FUNCTIONS
STATISTICS

Create a table like the image below. Pay attention to the table position, rows, and width.
column.

TRAINING AND COMPUTER SKILLS INSTITUTION

SALWACOMPUTER

STUDENT SCORE LIST

NOT DETAILED
Value
No STUDENT PROGRAM PACKAGETyping Practice Exercise Exercise Exam
Internship End
10Fingers Evaluasi1 End
1 KijagaReksa IntegratedOffice 83 78 82 81 75 80
2 PamanahrasaGondewa MicrosoftExcel 80 76 82 81 76 80
3 ThreeumVirat MicrosoftExcel 82 77 84 80 81 85
4 SuryanaYan MicrosoftWord 79 80 80 84 76 75
5 HestyAyu MicrosoftExcel 81 81 82 82 79 80
6 Iwan Hathairattanakool IntegratedOffice 82 79 80 80 79 80
7 QueenTikaBravani IntegratedOffice 79 83 83 83 75 85
8 NyiIteung Clubbing IntegratedOffice 81 80 81 81 76 85
9 KangKunKun MicrosoftWord 90 85 87 88 85 85
10 Ahmadinejad Safei MicrosoftWord 75 79 80 81 75 80
MaximumValue
MinimumValue
Average

Instructions:
To merge cells, use the 'Merge and Center' icon.
Use 'Wrap Text' to create two lines of text within one cell
To calculate the "Final Score" use the formula: "=SUM(D9:I9)/6"
To calculate the Maximum Value (Max) use the formula "=MAX(Range...)"
To calculate the Minimum Value (Min) use the formula "=MIN(Range...)"
For calculating Value Average (Average) use formula
=AVERAGE(Range...)
Range is a data area (data block). Example: D9:D18, D9:I9
If the calculation results in a decimal value, use 'Decrease Decimal'
to reduce the decimal places (rounding numbers).
Save the document that has been created earlier to the specified folder.
name "Exercise 1".
Microsoft Office 2010 Practicum Module

EXERCISE 3
USING CALCULATION OPERATOR FUNCTIONS AND FUNCTIONS
STATISTICS

Create a table like the image below. Pay attention to the position of the table, rows, and width.
column.

SALWACOMPUTER
PROFIT CALCULATION

NAME PRICE PRICE PERCENTAGE

No Good morning
ITEM SELL BUY (%)
1 USBKeyboard Rp 85,000 Rp 67,500
2 OpticalMouse Rp 45,000 Rp 34,000
3 USB Data Storage 8 GB Rp 220,000 Rp 175,000
4 DDRRAM 512 MB Rp 225,000 IDR 170,000
5 DDR2 RAM 1GB Rp 325,000 Rp 285,000
6 HarddiskSATA250GB Rp 475,000 Rp 335,000
7 HarddiskSATA120GB Rp 415,000 Rp 295,000
8 External 16x DVD RW Rp 425,000 Rp 385,000
9 15" LCD Monitor Rp 1,100,000 Rp 950,000
10 Windows 7 HE Original Rp 800,000 Rp 700,000
TOTAL
MAXIMUM PRICE
MINIMUM PRICE
AVERAGE

Instructions:
Use the 'Accounting / Currency' data format to add the symbol 'Rp'
To calculate profit, = Selling Price - Purchase Price
To calculate the percentage, = Profit / Purchase Price
Total = SUM(Range...)
Maximum Price = MAX(Range...)
Minimum Price = MIN(Range...)
Average = AVERAGE(Range...)
Microsoft Office 2010 Practice Module

EXERCISE 4
CHANGE DATE FORMAT (LONG DATE, SHORT DATE AND
CUSTOM

Create a table like the picture below. Pay attention to the position of the table, the rows, and the width.
column.

CHANGEDATEFORMAT

Long Date ShortDate d/m/yy dd/mmm/yyyy dd-mmm-yy dd-MMMM-yyyy

January1,2012 01/01/2012 1/1/12 January1,2012 01-Jan-12 January 1, 2012

February3,2012 03/02/2012 3/2/12 03/Feb/2012 03-Feb-12 February 3, 2012
March5,2012 March5,2012 5/3/12 March5,2012 March 5, 2012 March 5, 2012
April7,2012 07/04/2012 7/4/12 07/Apr/2012 April 7, 2012 07-April-2012
May9,2012 09/05/2012 September5,2012 09/May/2012 09-May-12 09-May-2012
June11,2012 November6,2012 11/6/12 June11,2012 11-Jun-12 June 11, 2012
July13,2012 13/07/2012 July13,2012 July13,2012 13-Jul-12 July 13, 2012
August15,2012 15/08/2012 August15,2012 August15,2012 15-August-12 August 15, 2012
September17,2012 September17,2012 September17,2012 September17,2012 September 17, 2012
October19,2012 19/10/2012 19/10/12 19/Oct/2012 October 19, 2012
November21,2012 21/11/2012 21/11/12 21/Nop/2012 21-Nov-12
December23,2012 23/12/2012 23/12/12 23/Dec/2012 23-Dec-12 23-December-2012

Instructions:
In general, there are two date formats, namely 'Long Date (dd mmmm yyyy)' and 'Short
Date (dd/mm/yyyy)
Day
Date separators can use 'Space', '-' or '/'
To change the 'Custom' date, first select the cell or range that contains
date format. Click Number–Custom, then type the desired date format.
Microsoft Office 2010 Practical Module

EXERCISE 5
CREATING A CHART

Graphs or charts are visual media that translate data in numerical form.
into data in the form of images. In research, it is usually utilized for
connecting data between variable x and variable y. How to create a graph or chart
In Microsoft Excel 2010, it is very easy. The first thing we need to do is
prepare the data first.
Create a table like the image below. Pay attention to the position of the table, the rows, and the width.
column.

STATEJUNIORHIGHSCHOOL1RAWAMERTA

RECAPITULATIONOFUNSCORESSTUDENTCLASS9J

StudentName Subject
[Link] MTK IPA English
ChicaKhaerunisa 85 75 70 75
ChikaGaluhSafitri 85 76 72 72
Uncle Abdul Muhyi 72 55 45 25
DeviMelinda 81 62 64 46
DickyPratama 60 42 51 39
EbahSuhaebah 64 55 68 52
EndangPurnama 74 64 66 57

Instructions:
Block range table A5:B12
Click Ribbon Insert–Chart–Chart Type–OK
Click Layout–Chart Title– Above Chart : “SUMMARY OF STUDENT UN SCORES
CLASS 9 J
Click Layout–Axis Title–Primary Horizontal Axis Title–Title Below Axis :
STUDENT NAME
Click Layout–Axis Title–Primary Vertical Axis Title– Rotated Title: “VALUE
UN

RECAPITULATION UN
CLASS 9 STUDENT J
100
80
60
40
20 B. Indonesia
0
MTK
IPA
B. English

STUDENT NAME
Microsoft Office 2010 Practical Module

CHAPTER 5
INTRODUCTION TO MICROSOFT POWERPOINT 2010

Presentation is an important activity in communicating something.

ideas to others with various purposes, for example to attract an audience
if they purchase products, use services or for other purposes.
One of the props that can be used to support a presentation is
computer. One of the software that can be used is PowerPoint
which is part of Microsoft Office. By using this software
someone can pour their brilliant ideas into an attractive visual form
in a short time.
Microsoft PowerPoint 2010 is actually version 14 of the type
presentation program owned by Microsoft Windows that is part of Microsoft
Office 2010 (also referred to as Office 2010 and Office 14). While Microsoft Office
2010 itself was released on June 15, 2010. It does not mean that after a long time
the year this program circulates and is used by people around the world, Microsoft PowerPoint 2010
its popularity began to fade. In fact, one year after the release of this program,
The new features still feel like there is an endless array to try.
The new version of this Microsoft presentation program offers several new features that
impressive, there are many differences from its predecessor (PowerPoint 2007).

Image 32
Microsoft Office PowerPoint 2010
Microsoft Office 2010 Practice Module

1. FEATURE – FEATURE IN POWERPOINT 2010

The following are new features available in PowerPoint 2010:

a. Create, manage, and collaborate with others
Managing files in the new Backstage view
Connecting the presentation author with your colleagues
Automatically saving presentation versions
Organize your slides into several sections
Combining and comparing presentations
Should work with separate PowerPoint presentation files in
different window
Can work from anywhere: PowerPoint Web Apps
PowerPoint Mobile 2010 for Windows Phone 7: Editing and viewing
from your phone
b. Enrich your presentation with videos, images, and animations.
Including, editing, and rotating videos in presentations
Trimming audio or video clips
Using bookmarks in audio and video clips
Connecting video from the website
Applying artistic textures and effects to the image
Removing the background and other unwanted parts from
image
Cutting photos more accurately (precision)
New SmartArt graphic picture layouts
Using transitions with 3-D motion graphic effects
Copy and insert animation effects from one object (text or shape) to another.
lain
Adding a screenshot for a slide
c. Send and share your presentation more effectively
Creating a portable presentation format for sharing
Convert presentation to video
Broadcast your slides view
Identifying and solving problems with accessibility
Activate mouse to laser pointer

2. COMPONENTS – COMPONENTS POWERPOINT 2010

Here are the components found in PowerPoint 2010 along with

its function.
2.1 Backstage File: a button that contains a pull-down menu, such as = new,
open, save, save as, print, close, and others. This button replaces Office
Button in Office 2007.
2.2 Quick Access Toolbar: is a toolbar that contains command buttons
quickly. by default, there are 3 commands: save, undo, and redo.
for certain purposes, these buttons can be added or
removed as needed.
2.3 Title Bar: contains the name of the file that is currently open followed by the name
the application, in this case, is Microsoft PowerPoint. when it was first released
When PowerPoint is opened, it will automatically be named presentation 1.
2.4 Tab Ribbon: a type of toolbar that contains several groups, where each group ...
each group consists of various types of commands that have been classified
according to their respective functions.
2.5 Group: consists of a collection of several commands that have been classified.
according to its function. The commands are marked with images.
Microsoft Office 2010 Practical Module

2.6 Slide Pane: to display the slides that have been created.
2.7 Placeholder: used to insert text within it.
2.8 Slide Number: used to view the active slide and the total number of slides
has been made.
2.9 View Mode: used to set the display mode. there are 3 types of options
The views are normal, slide sorter, and slide show.
Zoom Slider: used to enlarge or reduce a display
slide.

3. RIBBON TAB DESIGN

Image 33
Design Ribbon Tab in Microsoft Office PowerPoint 2010

If you click the Design tab on the Ribbon, a Ribbon will appear with
Several group tools, including: Page Setup, Themes, and Background, serve
to design your slide.
3.1 Page Setup, there is a button to set the orientation of the slide, do you
will use portrait or landscape orientation.
3.2 Themes, You can use the design options that have been prepared by Ms.
PowerPoint 2007 for your slide.
3.3 Background, to enhance the slides you created, you can arrange the background.
the back of your slide using the menu on this tool group.

4. RIBBON TAB ANIMATIONS

Image 34
Ribbon Tab Animations in Microsoft Office PowerPoint 2010

In the Ribbon Tab Animations, you can add various shapes.

animations on your slide. There are 3 tool groups that you can use, between
lain :
4.1 Preview, this button is used to view the results of the animation that you
Please provide for your slide.
4.2 Animations, You can choose animations for the objects on the slide,
consists of animate and custom animations.
4.3 Transition to This Slide, to provide the slide during the slide transition that
You make.
Microsoft Office 2010 Practice Module

5. RIBBON TAB SLIDE SHOW

Image 35
Ribbon Tab Slide Show in Microsoft Office PowerPoint 2010

The Ribbon Tab Slide Show consists of several tool groups, including:
5.1 Start Slide Show, to determine from where your slide is run, whether
from beginning or from current slide
show) or your own choice (custom slide show).
5.2 Set Up, in this tool group there is a button that can be used to
hide slide, record narration and
to determine the slide order (rehearse timings) that will be displayed.
5.3 Monitors, You can adjust the resolution of your presentation slides in the tool
this group.

6. RIBBON TAB VIEW

Figure 36
Ribbon Tab View in Microsoft Office PowerPoint 2010

The tool groups available on this Ribbon Tab include:

6.1 Presentation Views, in this section you can see the overall slides.
that you have created. You can view it normally, in slide sorter, notes
page, and slide show. In addition, you can also create a Master slide accordingly
with the design you want.
6.2 Show/Hide, to help you in creating presentation slides, you can
display the ruler and gridlines.
6.3 Zoom, You can enlarge the size of the slides you create or alternatively
normal.
6.4 Color/Grayscale, In this section you can determine whether the slide is
You make it in color or black and white.
6.5 Window, What is the appearance of the PowerPoint window, is it in cascade,
split, or switch to another window.
Microsoft Office 2010 Practicum Module

CHAPTER 6
CREATING A SIMPLE PRESENTATION

1. Preparing Documents
Open the Microsoft PowerPoint 2010 application. Click Start - All Programs - Microsoft
Office–Microsoft PowerPoint 2010. The screen below will appear.

Image 37
PowerPoint 2010 initial display

Upon first activation, PowerPoint will provide a standard slide.

with a layout of "Title Slide" as shown in the image above. For
to add a new slide, click 'New Slide' on the Home Ribbon, then choose a layout
what is desired. On the left side of the screen there is a slide panel. If you want to change
layout slide, click on the slide to change its layout, then click 'Layout' on
Ribbon Home, choose the desired layout.
To insert text, click on the words 'Click to add title' on the slide. To
Insert an object, use the Ribbon Insert. The method used is exactly the same as when
we use Microsoft Word or Excel.

Image 38
Slide Layout Option Display

2. Creating a Simple Presentation

Microsoft Office 2010 Practical Module

Using the method explained earlier, try to design your presentation.

with slides like the ones below. Note the layout type, text, objects, and
design.

Slide 2
Microsoft Office 2010 Practical Module

Slide 3

Slide 4

3. Adding Transition Effects to Slides

Click one of the slides. Click the Transitions Ribbon - Transition

to this slide. Select the transition effect to be used. Click the combo to
choose another type of transition.

Do the same for the next slide.

Microsoft Office 2010 Practical Module

Giving Animation Effects to Objects

On slide 1, click the text 'Access and Application of Internet Applications'

Click Ribbon Animations - Animation.

Choose the desired effect. A preview of the effect can be seen when clicking on the wrong one.
one effect.

Click 'More Entrance Effects', 'More Emphasis Effects', 'More Exit Effects'
and 'More Motion Effects' to try various types of other effects.

Do the same for other texts or objects on slide 1 and slide-

next slide.

4. Displaying Presentation
Click the Slide Show Ribbon - From Beginning to start the presentation. Or
by pressing the "F5" key on the keyboard.
Click Ribbon Slide Show–From Current Slide to start the presentation only
for specific slides only (the selected slide).
Press the "Esc" (Escape) button to end the presentation.