SCE2202 Module
SCE2202 Module
Computers
Department of Education - School of Continuing Education
Bayero University, Kano
Contents at a Glance
SECTION I Page
The Internet ------------------------------------ 2
SECTION II
Word Processing with Microsoft Word ------------------------------------ 11
SECTION III
Spreadsheet with Microsoft Excel ------------------------------------ 33
SECTION IV
Presentation with Microsoft PowerPoint ------------------------------------ 43
1
Introduction to the Internet
What is internet?
The Internet or simply the Net is a worldwide network of computer networks. It is an
interconnection of large and small networks around the globe.
The applications of internet include:
1) Exchange messages using e-mail (Electronic mail).
2) Transfer files as well as software.
3) Browse through information on any topic on web.
4) Communicate in real time (chat) with others connected to the Internet.
5) Search databases of government, individuals and organizations.
6) Read news available from leading news groups.
7) Send or receive animation and picture files from distant places.
8) Set up a site with information about your company’s products and services.
Assignment: Read on the history of the Internet.
The Web
The Web is a collection of files that contain hyperlinks which allow you to move easily from one
document to another. These web pages use the Network as a route to arrive at your computer.
The Web browser
This is a piece of software that lets you visit the World Wide Web, a vast interconnected group of
files stored on and accessed by computers around the world. The key to the Web is its interwoven
connections: the hyperlinks you work with to access specific files on your screen.
Hyperlink
This is an automatic connection – when you click on specific text or a picture on the screen you
are automatically brought to another screen, another, and so on; you’re working through layers of
information.
These Web pages can be very simple or very sophisticated with text, graphics (pictures), sound,
animation or even a small application (program), or information from a data base. The information
brought to your screen is through a connection to the Internet, usually in the form of a modem,
telephone line and Internet service provider (ISP).
2
Accessing web sites
In this era of advanced technology and high-speed Internet connections, you can find information
on virtually anything. In the space of just a few minute, you can find recipes for Fried rice or learn
all about the theory of learning. To search the internet, you need a web browser or simply, a
browser. Example of browsers are the Internet explorer, Google chrome, Safari, Firefox, etc. To
visit a particular web site, you need to type the web address of the web site in the URL (Uniform
Resource Locator).
Sometimes you are not sure that you have correctly remembered the information or the
name you need to start your search. Simply put in a few potential variation of what you’re
looking for, and separate them by typing the “|” symbol. Instead of this symbol you can
also use “or.” Then it’s easy enough to choose the result that makes the most sense. For
example:
3
Figure 2: Search window 1
2. The power of the asterisk
When you cannot recall one key word, phrase, or number you need in order to find what
we’re looking for, you can turn to the powerful “*” symbol. Just use this in the place of the
word/phrase you can’t remember, and you should be able to find the results you’re looking
for.
Example:
4
Figure 3: Search window 2
3. Whole phrases
Framing the search term within quotation marks is the simplest and most effective way to
find something specific and in the exact order you typed it in. For example, if you type in
the words I’m picking up good vibrations without quotation marks, the search engine will
show the results where these words appear in any order on a website, as opposed to the
specific order in which you typed them. If, on the other hand, you type “I’m picking up
good vibrations” within quotation marks, you’ll get only those results where these words
appear only in the order you typed them in. This is a great way to find the lyrics to a song
when you only know one line from it. For example:
5
Figure 4: Search window 3
E- Mail
E-mail (electronic mail) is the exchange of computer-stored messages by telecommunication. It is
important for everyone to have e-mail accounts so that one can receive messages electronically.
There are various types of e-mail accounts one can create. This include Yahoo, Google, Hotmail,
live, ymail, and many more.
Creating G-Mail account
To create a Gmail address, you will first need to log in to the Gmail website by typing
[Link] in the address bar and press the enter key from the keyboard. The Gmail home
page will be displayed to you, where u can either sign in ( for an existing account ) or you click on
the Create account link. Gmail will redirect you to the Google account signup page. You’ll need
to provide some basic information like your name, birth date, gender, and location. You will also
need to choose a name for your new Gmail address. Once you create an account, you’ll be able to
start adding contacts and adjusting your mail settings.
6
To create an account:
[Link].
Click Create account.
The signup form will appear. Follow the directions and enter the required information.
Review Google’s Terms of Service and Privacy Policy, click the check box, then click
Next step.
Choose whether to verify your account using text message or voice call and click continue.
7
Figure 6: Google Privacy and Terms Figure 7: Verify account page
Your account will be created, and the Google welcome page will appear.
8
Figure 9: Welcome page
When you first create your account, you will be automatically signed in. Most of the time,
however, you will need to sign in to your account and sign out when you’re done with it.
Signing out is especially important if you are using a shared computer (for example, at a
library or office) because it prevents others from viewing your emails.
To sign in:
1. Go to [Link].
2. Type your user name (your email address) and password, then click Sign in.
To sign out:
In the top-right corner of the page, locate the circle that has your first initial (if you have already
selected an avatar image, it will show the image instead). To sign out, click the circle and select
Sign out.
9
Figure 10: Sign in Figure 11: Sign out
10
SECTION II
Word Processing with Microsoft Word
Microsoft Word 2010 is a word-processing program, designed to help you create professional-quality
documents. With the finest document formatting tools, Word helps you organize and write your
documents more efficiently. Word also includes powerful editing and revising tools so that you can
collaborate with others easily.
The Ribbon
Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to
Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office in a more
visual stream line manner through a series of tabs that include an immense variety of program features.
Home Tab
This is the most used tab; it incorporates all text formatting features such as font and paragraph changes.
Insert Tab
This tab allows you to insert a variety of items into a document from pictures, clip art, tables and headers
and footers.
11
Reference Tab
This tab has commands to use when creating a Table of Contents and citation page for a paper. It provides
you with many simple solutions to create these typically difficult to produce documents.
Mailing Tab
This tab allows you to create documents to help when sending out mailings such as printing envelopes,
labels and processing mail merges.
Review Tab
This tab allows you to make any changes to your document due to spelling and grammar issues. It also
holds the track changes feature which provides people with the ability to make notes and changes to a
document of another person.
12
View Tab
This tab allows you to change the view of your document to a different two page document or zoom.
Getting Started
Now that you have an understanding of where things are located, let’s look at the steps needed to
create a document.
Opening Word
You may have a shortcut to Word on
your desktop, if so double click the
icon and Word will open. If not follow
the steps below:
2. Type “Word”
3. Click on Microsoft Word
Using Templates
Word allows you to apply built-in templates from a wide selection of popular Word templates, including
resumes, agendas, business cards, and faxes.
13
To reuse a template that you’ve recently used, click Recent Templates, click the template that
you want, and then click Create.
To find a template on [Link], under [Link] Templates, click the template category that
you want, click the template that you want, and click Download to download the template from
[Link] to your computer.
3. Once you have selected your template you can modify it in any way to create the document you
want.
NOTE: You can also search for templates on [Link] from within Word. In the Search [Link] for
templates box, type one or more search terms, and then click the arrow button to search.
Opening a document
1. Click the File tab, and then click Open.
2. In the left pane of the Open dialog box, click the drive or folder that contains the document.
3. In the right pane of the Open dialog box, open the folder that contains the document that you want.
4. Click the document and then click Open.
Pasting Text
If you Copy text, you typically need to Paste it somewhere. The Paste feature
in 2010 is much more detailed than in previous versions of Word. When you paste content, the Paste
Options button provides different options, depending on the source of the content.
Keep Source Formatting: This option preserves the look of the original text.
Keep Text Only: This option removes all the original formatting from the text.
Link & Keep Source Formatting: This option preserves the look of the original text, and it maintains
a link to the source file and updates the pasted text with any changes that are made to the file.
source
Link & Use Destination Styles: This option formats the text to match the style that’s applied where the
text is pasted. It also maintains a link to the source file and updates the pasted text with any
changes that are made to the source file.
14
Merge Formatting: This option changes the formatting so that it matches the text that surrounds it.
Picture: This option inserts the text as an image.
Use Destination Styles: This option formats the text to match the style that’s applied where the
text is pasted.
Use Destination Theme: This option formats the text to match the theme that’s applied to the docume nt
To Paste, click on the area you want your information to be inserted and either go to the Home tab in
the Clipboard group and click Paste or right click on your mouse and select Paste.
Undo
The Quick Access Toolbar holds a variety of commands right at you finger tips. It is located in the top
left of the document above the File and Home tab.
Formatting Text
Formatting a document can range from modifying text size to adding graphics. It is easy to add creative
touches to any document with the options Microsoft Word has to offer.
Modifying Fonts
The Font Group allows you to change your text font style, size, colour and many other elements.
15
Change Text Case
You can change the case of selected text in a document by clicking
on the ribbon. a single button called
Change Case
Reflection, or Glow, and then click the effect that you want
to add.
Format Painter
The Format Painter feature allows you to quickly copy a format that you have applied to text
already in your document.
1. Select the text or graphic that has the formatting that you want to copy.
2. On the Home tab, in the Clipboard group, single click Format Painter. The pointer will
change to a paintbrush icon.
3. Bring your cursor to the text or graphic that you want to format and click on the text.
4. To stop formatting, press ESC or click on the Format Painter command again.
NOTE: Double-click the Format Painter button if you want to change the format of multiple selections
in your document.
16
Clear Formatting
To get rid of all the styles, text effects, and font formatting in your document, do the following:
1. Select the text that you want to clear the formatting from. Or press CTRL+A to select everything in
the document.
2. On the Home tab, in the Font group, click Clear Formatting.
NOTE: The Clear Formatting command
will not remove highlighting from your
text. To clear highlighting, select the highlighted
text, and then click the arrow next to Text
Highlight Color and click No Color.
Formatting Documents
Adjusting Line Spacing
The default spacing is 1.15 line spacing and 10 points after each paragraph. The default spacing in
Office Word 2003 documents is 1.0 between lines
and no blank line between paragraphs.
17
Page Orientation You can choose either portrait (vertical) or landscape (horizontal) orientation for all
or part of
your
document.
Change
Page
Orientation
1. On the
Page Layout tab, in the Page
Setup group, click Orientation.
2. Click Portrait or Landscape.
Page Margins
Page margins are the blank space around the edges of the page. In general, you insert text and graphics
in the printable area inside the margins when you change a document’s page margins, you change
where text and graphics appear on each page. You can change the page margins either by choosing
from one of Word’s predefined settings in the Margins gallery or by creating custom margins.
18
Create Custom Margins
1. On the Page Layout tab, in the Page Setup group, click Margins.
2. At the bottom of the Margins gallery drop down menu, click Custom Margins.
3. The Page Setup dialog box will appear.
4. Enter new values for the margins in all or some of the Top, Bottom, Left or Right text boxes.
5. Click OK
NOTE: Most printers require a minimum width for margin settings, because they can't print all the way
to the edge of the page. If you try to set margins that are too narrow, Microsoft Word displays the
message one or more margins are set outside the printable area of the page.
Page Breaks
Word automatically inserts a page break when you reach the end of a page. If you want the page to
break in a different place, you can insert a manual page break.
19
Headers, Footers, and Page Numbers You can add
headers, footers and page numbers numerous ways.
The simplest way is to double click on the top or
bottom of the page and the header and footer area
will appear. Enter the text you wish to be displayed
at the top or bottom of every page.
20
3. Click Remove at the bottom of the menu.
Document Ruler
You can use the horizontal and vertical rulers in
Word to align text, graphics, tables, and other
elements in your document. To view the
horizontal ruler across the top of your Word
document and the vertical ruler along the left
21
edge of your document, you must be in Print Layout view.
1. To show or hide the horizontal and vertical rulers, click View Ruler at the top of the vertical scroll bar.
Tab Stops
Creating tab stops can be helpful when creating a large number of documents such as flyers, table of
contents or even when creating a resume. They help you to display and line up information correctly.
Setting Manual Tab Stops
1. Click the tab selector at the left end of the ruler until it displays the type of tab that you want.
2. Then click in the ruler at the top of your page, where you want to set the tab stop.
A Left Tab stop sets the start position of text that will then run to the right as you type.
A Center Tab stop sets the position of the middle of the text. The text centers on this position as you type.
A Right Tab stop sets the right end of the text. As you type, the text moves to the left.
A Decimal Tab stop aligns numbers around a decimal point. Independent of the number of digits, the
decimal point will be in the same position. (You can align numbers around a decimal character only)
A Bar Tab stop doesn't position text. It inserts a vertical bar at the tab position.
NOTE: You can drag existing tab stops left or right along the ruler to a different position. Just Click and
hold on the tab stop on the ruler then drag it to where ever you would like it to be.
22
6. To add dots with your tab stop, or to add another type of leader,
click the option that you want under Leader.
7. Click Set.
8. Repeat steps 4-5 to add another tab stop, or click OK.
9. The Tabs dialog box will disappear and you should see your tabs
set on the document ruler.
Clear Tab Stops
You can clear tab stops in a variety of ways, the simplest is going to the ruler, click and hold on the tab
stop and drag in down towards the document. The tab stop will disappear. To quickly clear multiple tab
stops and start fresh:
1. Click the Home tab, click the Paragraph Dialog Box Launcher
2. A Paragraph box will appear, click on the Tabs button at the bottom left of the dialog box.
3. A Tabs dialog box will appear.
4. In the list under Tab stop position, click the tab stop position that you want to clear, and then click
Clear. To remove the spacing from all manual tab stops, click Clear All.
5. Click OK.
The text that you add becomes part of the shape — if you rotate
or flip the shape, the text rotates or flips also.
Format Shapes
After you insert a shape a new tab called Drawing Tools Format will appear every time you click on the
shape.
1. Click the shape that you want to apply a new or different Quick Style to.
23
2. Go to the Drawing Tools Format tab, in the Shape Styles group, click the style that you want to be
applied.
Delete Shapes
If you decide you no longer want the shape in your document then click on the shape and then press
DELETE.
1. On the Insert tab, in the Text group, click Text Box and a drop down menu will appear.
2. Click on a text box template or click Draw Text Box at the bottom of the drop down menu to draw
your own text box.
3. If you elect to draw your own text box you need to click in the document, and then drag to draw the
text box the size that you want.
4. To add text to a text box, click inside the text box, and then type or paste text.
To format text in the text box, select the text, and then use the formatting options in the Font
group on the Home tab.
To position the text box, click it, and then when the pointer becomes a , drag the text box to a
new location.
NOTE: If you have problems printing text boxes, make sure that the Print drawings created in
Word check box is selected. To do this, click the File tab, click Options, click Display, and then
under Printing Options, select the Print drawings created in Word check box.
24
WordArt
WordArt can be used to add special text effects to your document. For example, you can stretch a title,
skew text, make text fit a pre-set shape, or apply a gradient fill. This WordArt becomes an object that
you can move or position in your document to add decoration or emphasis. You can modify or add to
the text in an existing WordArt object whenever you want. To add WordArt to text in your document,
complete the following steps:
25
Sizing Graphics
You can easily resize pictures, text boxes, shapes, and WordArt in your file. You can also crop pictures or
return them to their original size.
Cropping a Picture
Cropping reduces the size of a picture by removing vertical or horizontal edges. Cropping is often used
to hide or trim a part of a picture, either for emphasis or to remove unwanted portions.
Uncrop a Picture
You can always restore a resized or a cropped picture to its original appearance.
26
2. Click the layout that you want. Your document will be formatted in columns.
NOTE: To add a vertical line between the columns, click Columns again, click More
Columns, and then select the Line between check box. You can also adjust
the column width and spacing.
1. On the Page Layout tab, in the Page Setup group, click Columns.
NOTE: 4. In the Apply to list, click Selected text or This point forward.
To change the layout again further on in your document, select text
or click where you want to change the layout, and then follow the same steps. For
example, you can change from one column to a two-column layout, and then you can
change back to the single-column layout on a later page.
SmartArt Graphic
A SmartArt graphic is a visual representation of your information that you can quickly and easily create,
choosing from among many different layouts, to effectively communicate your message or ideas. You
can create SmartArt graphics in
Excel, Outlook, PowerPoint, and
Word.
When you select a layout, placeholder text (such as [Text]) is displayed, so that you can see how your
SmartArt graphic looks, nor is it displayed during a slide show. However, the shapes are always displayed
and printed, unless you delete them. You can replace the placeholder text with your own content.
27
Create a SmartArt Graphic
1. On the Insert tab, in the Illustrations group, click SmartArt.
2. In the Choose a SmartArt Graphic dialog box, click the type and layout that you
want.
3. Enter your text by doing one of the following:
Click [Text] in the Text pane, and then type your text.
Copy text from another location, click [Text] in the Text pane, and then paste your text.
NOTE: To delete a shape from your SmartArt graphic, click the shape you want to
delete, and then press DELETE. To delete your entire SmartArt graphic, click the border
of your SmartArt graphic, and then press DELETE.
28
4. In the SmartArt Styles group you can also click Change Colours
to further modify your SmartArt graphic.
NOTE: If you don't see the SmartArt Tools or Design tabs, make
sure that you've selected a SmartArt graphic. You may have to
double-click the SmartArt graphic to open the Design tab.
Tables
Using tables in Word can provide you with additional elements to any document. Tables can be used to
create lists or format text in an organized fashion.
Inserting a Table
1. Click where you want to insert a table.
2. On the Insert tab, in the Tables group, click Table
3. A drop down box will appear; click and hold your mouse then drag to select
the number of rows and columns that you want inserted into your
document. You will see your table appearing in your document as you drag
on the grid.
4. Once you have highlighted the rows and columns you would like let go of
your mouse and the table will be in your document
Delete a Table
1. Rest the pointer on the table until the table move handle appears, and then click the table move
handle.
2. Press BACKSPACE on your keyboard.
29
Finalizing a Document
TO SELECT DO THIS
The entire table In Print Layout view, rest the pointer over the table until the table move handle
appears, and then click the table move handle.
A row or rows
Click to the left of the row.
A column or
columns
Click the column's top gridline or border.
A cell
Click the left edge of the cell.
2. Press DELETE.
30
Print
The Print tab is the place to go to make sure you are printing what you want.
1. Click the File tab, and then click Print. To go back to your document, click the File tab.
2. A preview of your document automatically appears. To view each page, click the arrows below the
preview.
Save a document
To save a document in the format used by Word 2010 and Word 2007, do the following:
31
Help
If you need additional assistance when completing your document you can use the help feature.
3. Click in the Search Help textbox and type what you need help with
4. Click the magnifying glass next to the text box and the possible solutions will
appear.
For additional information Microsoft Office has a great online resource that provides you with step by
step instructions in a variety of topics. This link will bring you directly to the Word 2010 Help and How-To
page: [Link]
32
SECTION III
Spreadsheet with Microsoft Excel
A spreadsheet is a table of values arranged in rows and columns. Each value can have a predefined
relationship to the other values. If you change one value, therefore, you may need to change other
values as well.
Spreadsheet applications (sometimes referred to simply as spreadsheets) are computer programs
that let you create and manipulate spreadsheets electronically. In a spreadsheet application, each
value sits in a cell. You can define what type of data is in each cell and how different cells depend
on one another. Examples include:
Google Sheets - (Online and free)
iWork Numbers - Apple Office Suite.
Microsoft Excel.
OpenOffice
Because we are more familiar with Windows operation systems, Microsoft Excel is the choice for
this course.
Microsoft Excel 2010
Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and
format workbooks (a collection of spreadsheets) in order to analyze data and make more informed
business decisions. Specifically, you can use Excel to track data, build models for analyzing data,
write formulas to perform calculations on that data, pivot the data in numerous ways, and present
data in a variety of professional looking charts.
The Ribbon
Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003
to Microsoft 2010. The ribbon holds all of the information in previous versions of Microsoft Office
in a more visual stream line manner through a series of tabs that include an immense variety of
program features.
Home Tab
This is the most used tab; it incorporates all text and cell formatting features such as font and
paragraph changes. The Home Tab also includes basic spreadsheet formatting elements such as
text wrap, merging cells and cell style.
33
Insert Tab
This tab allows you to insert a variety of items into a document from pictures, clip art, and headers
and footers.
Formulas Tab
This tab has commands to use when creating Formulas. This tab holds an immense function library
which can assist when creating any formula or function in your spreadsheet.
Data Tab
This tab allows you to modifying worksheets with large amounts of data by sorting and filtering
as well as analyzing and grouping data.
34
Review Tab
This tab allows you to correct spelling and grammar issues as well as set up security protections.
It also provides the track changes and notes feature providing the ability to make notes and changes
someone’s document.
View Tab
This tab allows you to change the view of your document including freezing or splitting panes,
viewing gridlines and hide cells.
Getting Started
Now that you have an understanding of where things are located, let’s look at the steps needed to
create an Excel document.
follow the steps below:
1. Click on the Start button
2. Highlight Programs
3. Highlight Microsoft Office
4. Click on Microsoft Excel 2010
35
Enter Data in a Worksheet
1. Click the cell where you want to enter data.
2. Type the data in the cell.
3. Press enter or tab to move to the next cell.
Formula bar
The formula bar can be used to
enter data and formula in a cell.
Click on to validate
data entered or
click on to cancel.
Nonadjacent cells or cell ranges - Select the first cell or range of cells, and then hold down CTRL
while you select the other cells or ranges.
An entire row or column - Click the row or column heading.
1. Row heading
2. Column heading
Adjacent rows or columns - Drag across the row or column headings. Or select the first row or
column; then hold down SHIFT while you select the last row or column.
36
Nonadjacent rows or columns - Click the column or row heading of the first row or column in
your selection; then hold down CTRL while you click the column or row headings of other rows
or columns that you want to add to the selection.
Cells to the last used cell on the worksheet (lower-right corner) - Select the first cell, and then
press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet
(lower-right corner).
Cells to the beginning of the worksheet - Select the first cell, and then press
CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.
NOTE: To cancel a selection of cells, click any cell on the worksheet.
Modifying Spreadsheets
In order to create an understandable and professional document you will need to make adjustments
to the cells, rows, columns and text. Use the following processes to assist when creating a
spreadsheet.
Cut, Copy, and Paste Data
You can use the Cut, Copy, and Paste commands in Microsoft Office Excel to move or copy entire
cells or their contents.
NOTE: Excel displays an animated moving border around cells that have been cut or copied. To
cancel a moving border, press ESC.
Move/Copy Cells
When you move or copy a cell, Excel moves or copies the entire cell, including formulas and their
resulting values, cell formats, and comments.
1. Select the cells that you want to move or copy.
2. On the Home tab, in the Clipboard group, do one of the following:
a. To move cells, click Cut.
b. To copy cells, click Copy.
3. Click in the center of the cell you would like to Paste the information too.
4. On the Home tab, in the Clipboard group, click Paste
NOTE: Excel replaces existing data in the paste area when you cut and paste cells to move them.
37
Automatically Fit Column/Row Contents
1. Click the Select All button
2. Double-click any boundary between two column/row headings.
3. All Columns/Rows in the entire worksheet will be changed to the new size
NOTE: At times, a cell might display #####. This can occur when the cell contains a number or
a data that exceeds the width of the cell so it cannot display all the characters that its format
requires. To see the entire contents of the cell with its current format, you must increase the width
of the column.
38
1. Click the cell in which you want to wrap the text.
2. On the Home tab, in the Alignment group, click Wrap Text.
3. The text in your cell will be wrapped.
Cell Borders
By using predefined border styles, you can quickly add a border
around cells or ranges of cells. If predefined cell borders do not
meet your need; you can create a custom border.
Note: Cell borders that you apply appear on printed pages.
Apply Cell Borders
1. Go to the Home tab, in the Font group
2. Click the arrow next to Borders
3. Click on the border style you would like
4. The border will be applied to the cell or cell range
Remove Cell Borders
1. Go to the Home tab, in the Font group
2. Click the arrow next to Borders
3. Click No Border
Cell and Text Coloring
Cell Fill
1. Select the cells that you want to apply or remove a fill color from.
2. Go to the Home tab, in the Font group do the following:
a. To fill cells with a solid color, click the arrow next to Fill Color and then under
Theme Colors or Standard Colors, click the color that you want.
39
Remove Cell Fill
1. Select the cells that contain a fill color or fill pattern.
2. On the Home tab, in the Font group, click the arrow next
to Fill Color, and then click No Fill.
Text Color
1. Select the cell, range of cells, text, or characters that you
want to format with a different text color.
2. On the Home tab, in the Font group do the following:
To change the text color, click the arrow next to Font Color
, and then under Theme Colors or Standard Colors, click
the color that you want to use.
Formulas in Excel
Formulas are equations that perform calculations on values in your worksheet. A
formula always starts with an equal sign (=). An example of a simple is =5+2*3 that
multiplies two numbers and then adds a number to the result. Microsoft Office Excel follows the
standard order of mathematical operations. In the preceding example, the multiplication operation
(2*3) is performed first, and then 5 is added to its result.
You can also create a formula by using a function which is a prewritten formula that takes a value,
performs an operation and returns a value. For example, the formulas =SUM(A1:A2) and
SUM(A1,A2) both use the SUM function to add the values in cells A1 and A2. To write a formula
in excel, click or select the cell you want the result to appear and type the = sign, then enter the
formula and press the enter key.
40
Examples:
1. Add the numbers 3 and 5: =3+5
2. Subtract 10 from 20: =20-10
You can also use cell reference/address in formula.
Example:
1. Add the content of cell A20 and B20: =A20 + B20
Example of functions:
1. =SUM(A3:A5) adds the content of A3, A4 and A5; i.e A3 + A4 +
A5
2. =PRODUCT(B3,H5) multiply the content of cell B3 and H5; i.e B3
* H5
41
Use Auto Sum
To summarize values quickly, you can also use
AutoSum.
1. Select the cell where you would like your
formulas solution to appear.
2. Go to the Home tab, in the Editing group,
3. Click AutoSum, to sum your numbers or
click the arrow next to AutoSum to select a
function that you want to apply.
Freeze Panes
When you freeze panes, Microsoft Excel keeps specific rows or
columns visible when you scroll in the worksheet. For example, if
the first row in your spreadsheet contains labels, you might freeze
that row to make sure that the column labels remain visible as you
scroll down in your spreadsheet. A solid line indicates that the row
is frozen to keep column labels in place when you scroll.
1. On the worksheet, select the first row below the row you want
to keep visible or the first column to the right of the column that
you want to keep visible when you scroll.
2. On the View tab, in the Window group, click the arrow below Freeze Panes.
3. Then click on the freeze panes option.
42
SECTION IV
Presentation with Microsoft PowerPoint
PowerPoint is a system in the Microsoft Office Suite that enables you to present information in
office meetings, lectures and seminars to create maximum impact in a minimal amount of time.
PowerPoint presentations can amplify your message, accelerate the information being absorbed
and assist with comprehension enabling faster decision making.
When you first open PowerPoint you will see what's called the Normal view.
1
4
2
1 The slide pane is the big area in the middle. This is the area you will work in to create your slides.
2 On each slide, you will see various boxes with the dotted borders which are called placeholders.
This is where you type your text. Placeholders can be customized to different sizes and can contain
pictures, charts, and other non-text items.
3 On the left of the screen are thumbnail versions of the slides in your presentation; the slide you're
working will be highlighted.
4 The bottom area is the notes pane; this is where you type speaker notes that you can refer to
when you present. You can also print speaker notes to use when presenting a slide show.
43
Adding Additional Slides
When you open a new PowerPoint document you will only see one slide. In order to add more
slides, you need to create them, to do this you have a few options.
1 Clicking on the top portion of the New Slide command, on the Home tab is the easiest
method because a new slide will be added immediately. PowerPoint will automatically
insert a Title and Content slide when using this method of adding slides.
2 If you click the bottom part of the New Slide command, a box will appear and you will
see a gallery of layouts for you to choose from which will be inserted after your
previous slide once you click on your preferred slide option.
Formatting Text
Many of your slides will require you to enter text in the placeholder boxes.
3
2
44
1. When typing text PowerPoint will automatically place the text into bulleted lists to make minor
points under major points. PowerPoint will also automatically text fit the text reducing font size
and line spacing to fit everything into the placeholder boxes.
2. To change the text font, color and size use commands in the Font group.
3. To change paragraph formatting such as bullet type, text indentation, and line spacing use the
commands in the Paragraph group.
2 To see additional themes, click the More arrow button on the right of the group.
3 When you point and hover on any theme thumbnail, a preview of the theme will appear on the
slide. To apply the theme to your slides, click on the thumbnail design you like.
1 3 2
NOTE: A theme can be selected at any time during the creation of your slides however; themes can alter
the position of placeholders, so your text maybe automatically adjusted to properly fit the
placeholder of the theme causing unexpected formatting changes to your slides.
45
Inserting Clip Art
If you would like to add an additional dimension to a PowerPoint slide you can add Clip Art to your
slides. Clip Art includes pictures, sounds and videos. There are two ways to initiate inserting Clip
Art depending on where you would like the graphic to be located.
1 The first method is to go to the Insert Ribbon and click on the Clip Art command. You can also click
on the Audio or Video commands and opt to pick from the Clip Art gallery. The second method is
to click on the Clip Art icon in a placeholder.
2 The Clip Art task pane will then open on the right. Type a keyword in the Search for box that
suggests the type of clips you may want. Use the Results should be drop down to select the media
type to search in then click Go.
3 Clips that fit the keyword will appear in the box below. Click on the clip that you would like on
your slide and it will be automatically appear.
46
NOTE: When inserting a graphic using the icon in a placeholder causes the graphic to be automatically
sized and positioned within the placeholder preventing you from entering text in the same
placeholder. Inserting a graphic through the Insert Ribbon will insert the graphic on the slide
without removing the placeholder enabling you to enter text on the slide without having to
further modify your slide.
Slide Transitions
Slide transitions provide an animated effect to each slide when moving from one slide to the
next during a slide show. There are a variety of transitions that can be applied to each or all
slides including sounds.
4
1
6
5
2 3
1 The Transition to This Slide group provides thumbnails of various slide transition options.
To see all of the transitions options click on the up and down arrows or the More arrow to the
right of this group.
2 When you point and hover over any transition thumbnail, a preview of the theme will play. To
apply the transition to your slide, click on the thumbnail you like.
3 To apply the same transition to all of your slides click on the Apply To All command after
selecting the transition of your choice.
4 To apply a Sound, click on the sound drop down arrow. Then Click on the sound you would like
to chime during the slide transition. Click the Apply To All command to have the chime occur
during each transition.
5 The Advance Slide group, allows you to decide if a transition should appear when the mouse is
clicked or after a specified time. Click the On Mouse Click box for transitions to occur only when
forced. Click on the After box for the slide to transition at the time specified such as 5 seconds or
1 minute.
6 Finally, when all transitions are applied you can preview the current slide by clicking on the
Preview command.
47
Slide Animations
Slide animations create animated effects to text and graphics during a slide show. There are a variety of
animations that can be applied to text or graphics in multiple ways from a single word to all of the text
on a slide.
3
4
1 2
1 The Animation group provides a variety of option to apply animations to text and graphics
within each slide.
To see all of the animation options click on the arrows to the right of the Animation group.
2 The Timing group allows you to modify the sequence and timing of the animations selected. You
can decide if an animation should appear when the mouse is clicked or after a specified time.
You can also decide if text should be animated together or separate as well as reordering the
animations. Use the Start drop down arrow to opt for animations to occur only when clicked or
with other text. Click on the Duration box for the text or graphic to animate at a specified time.
3 The Animation Pane displays all of the animations you have applied to each slide. It also
enables you to modify each animation similar to the Timing group and play the animations
applied to the slide.
4 Finally, when all animations are applied you can preview the current slide by clicking on the
Preview command.
1
1 To view your slide show go to the Start Slide Show group. To start on the first slide click the
From Beginning command. To start on the current slide click the From Current Slide command.
48
1 To view your slide show go to the Start Slide Show group. To start on the first slide click the
From Beginning command. To start on the current slide click the From Current Slide command.
2 Your computer screen will disappear and a slide show will fill your computer screen.
3 To move from slide to slide you can use the Slide Show toolbar, at the bottom left of the screen.
Navigational arrows will appear when you position your cursor in that area. You can also move
from slide to slide by clicking the mouse button or using the right and left arrows on the
keyboard.
4 To end your slide show press the ESC button on your keyboard. This will return you to your
screen as you left.
NOTE: Another way to quickly preview a slide is to click on the Slide Show button in the lower right part
of the PowerPoint window. The slide show will begin from the slide selected on the Slides tab.
49