Microsoft Word 2007 Bruksanvisning

Microsoft Office-programvara Word 2007

Läs gratis den bruksanvisning för Microsoft Word 2007 (140 sidor) i kategorin Office-programvara. Guiden har ansetts hjälpsam av 24 personer och har ett genomsnittsbetyg på 4.9 stjärnor baserat på 12.5 recensioner. Har du en fråga om Microsoft Word 2007 eller vill du ställa frågor till andra användare av produkten? Ställ en fråga

Ladda ner PDF

Sida 1/140

Microsoft Office 2007

Training Manual

publication, including the student manual, instructor's guide and exercise files, or any part thereof, may not be

reproduced or transmitted in any form or by any means, electronic or mechanical, without prior written permission of

EZ-REF Courseware.

TRADEMARKS

EZ-REF is a trademark of EZ-REF Courseware. All other products or brand names mentioned are trademarks or

registered trademarks of their respective holders.

DISCLAIMER

While EZ-REF Courseware has taken care to ensure the accuracy and quality of these materials, all material is provided

without any warranty whatsoever, including, but not limited to, the implied warranties of merchantability or fitness for a

particular purpose. Any persons or businesses mentioned in the text of this manual are strictly fictitious. Any

resemblances to existing or deceased persons, or existing or defunct businesses, is entirely coincidental.

Product Code: OFFICE 2007 7.08

Microsoft Office 2007

TABLE OF CONTENTS

HOW TO USE THIS MANUAL ..................................................................................................................... VII

RUNNING MICROSOFT WORD ................................................................................................................... 2

THE WORD SCREEN .................................................................................................................................... 3

WORKING WITH HELP ................................................................................................................................. 6

PRINTING HELP TOPICS .................................................................................................................................... 8

EXITING HELP ..................................................................................................................................................... 9

SCREENTIPS ..................................................................................................................................................... 10

VIEWING OPTIONS ..................................................................................................................................... 11

SAVING A DOCUMENT .............................................................................................................................. 13

USING THE SPELL CHECKER ................................................................................................................... 15

PRINTING A FILE ........................................................................................................................................ 18

CLOSING A DOCUMENT ............................................................................................................................ 20

CREATING A NEW DOCUMENT ................................................................................................................ 21

SWITCHING BETWEEN MULTIPLE DOCUMENTS ......................................................................................... 22

OPENING AN EXISTING DOCUMENT ....................................................................................................... 24

NAVIGATING WITHIN A DOCUMENT ........................................................................................................ 27

DELETING TEXT ......................................................................................................................................... 29

SELECTING WITH THE MOUSE ....................................................................................................................... 29

OOPS!! UNDELETING TEXT ..................................................................................................................... 30

REDOING/REPEATING COMMANDS .............................................................................................................. 30

APPLYING ATTRIBUTES ............................................................................................................................ 31

REMOVING ATTRIBUTES ................................................................................................................................. 31

CHANGING FONTS & POINT SIZE ............................................................................................................ 32

PAGE SETUP ............................................................................................................................................... 34

CHANGING MARGINS ....................................................................................................................................... 34

CHANGING ORIENTATION ............................................................................................................................... 35

CHANGING PAPER SIZE .................................................................................................................................. 35

PARAGRAPH ALIGNMENT ......................................................................................................................... 36

Microsoft Office 2007

RUNNING MICROSOFT EXCEL ................................................................................................................. 38

THE EXCEL SCREEN ................................................................................................................................. 39

NAVIGATING WITHIN A WORKSHEET ..................................................................................................... 43

CHANGING THE WORKBOOK VIEW ........................................................................................................ 44

ENTERING INFORMATION ........................................................................................................................ 45

EDITING DATA ............................................................................................................................................ 46

DELETING UNWANTED DATA ................................................................................................................... 47

CLEARING A CELL ............................................................................................................................................ 48

OOPS! UNDOING THE DELETION .................................................................................................................. 49

REDOING COMMANDS .................................................................................................................................... 49

WORKING WITH BLOCKS .......................................................................................................................... 50

MOUSE SHAPES ............................................................................................................................................... 51

SELECTING A CONTIGUOUS BLOCK OF CELLS ........................................................................................... 52

SELECTING NONCONTIGUOUS BLOCKS OF CELLS ................................................................................... 52

SELECTING THE ENTIRE WORKSHEET ........................................................................................................ 52

ADJUSTING COLUMN WIDTH & ROW HEIGHT ....................................................................................... 53

ENTERING A FORMULA ............................................................................................................................. 54

WORKING WITH FUNCTION ARGUMENTS ............................................................................................. 55

WORKING WITH FUNCTION ARGUMENTS .................................................................................................... 56

THE AUTOSUM FEATURE ................................................................................................................................ 57

USING THE AUTO FILL ............................................................................................................................... 58

USING THE FILL TOOL ...................................................................................................................................... 59

AUTO FILL OPTIONS ......................................................................................................................................... 60

SAVING YOUR WORKBOOK ..................................................................................................................... 61

CHANGING THE PAGE SETUP ................................................................................................................. 63

CHANGING MARGINS ....................................................................................................................................... 63

CHANGING ORIENTATION ............................................................................................................................... 64

CHANGING PAPER SIZE .................................................................................................................................. 64

CHANGING THE PRINT AREA .......................................................................................................................... 65

SETTING/REMOVING PAGE BREAKS ............................................................................................................ 65

DEFINING PRINT TITLES .................................................................................................................................. 66

ACCESSING THE PAGE SETUP DIALOG BOX ............................................................................................... 66

CUSTOMIZING MARGINS ................................................................................................................................. 68

CUSTOMIZING HEADERS/FOOTERS ............................................................................................................. 69

SHEET PRINTOUT OPTIONS ........................................................................................................................... 71

PRINTING YOUR WORKSHEET ................................................................................................................ 73

CREATING A NEW WORKBOOK ............................................................................................................... 76

SWITCHING BETWEEN MULTIPLE WORKBOOKS ........................................................................................ 77

OPENING AN EXISTING WORKBOOK ...................................................................................................... 78

ALIGNING CELL DATA ................................................................................................................................ 81

MERGE AND CENTER ACROSS COLUMNS .................................................................................................. 81

VERTICALLY ALIGNING DATA ......................................................................................................................... 82

CHANGING TEXT ORIENTATION .................................................................................................................... 82

FORMATTING VALUES .............................................................................................................................. 83

USING CELL STYLES ................................................................................................................................. 84

Microsoft Office 2007

RUNNING MICROSOFT POWERPOINT .................................................................................................... 86

THE POWERPOINT SCREEN .................................................................................................................... 87

OPENING A PRESENTATION .................................................................................................................... 90

SWITCHING BETWEEN MULTIPLE FILES ...................................................................................................... 93

RUNNING A SLIDE SHOW ......................................................................................................................... 94

STARTING A SLIDE SHOW ................................................................................................................................... 95

MOVING AROUND WITHIN THE SLIDE SHOW ............................................................................................... 95

CHANGING VIEWS ..................................................................................................................................... 96

CHANGING THE VIEWING SIZE ....................................................................................................................... 96

WORKING WITH THE SLIDE SORTER ............................................................................................................ 97

REARRANGING SLIDES ................................................................................................................................... 98

DELETING AN UNWANTED SLIDE .................................................................................................................. 98

WORKING WITH THE NOTES PAGE VIEW ..................................................................................................... 99

WORKING WITHIN THE SLIDE PANE ............................................................................................................ 100

SELECTING OBJECTS ............................................................................................................................. 101

SELECTING MULTIPLE OBJECTS ................................................................................................................. 101

SELECTING ALL OBJECTS ............................................................................................................................ 102

THE SELECTION PANE .......................................................................................................................................... 102

MOVING OBJECTS ................................................................................................................................... 103

COPYING OBJECTS ................................................................................................................................. 104

RESIZING OBJECTS ................................................................................................................................. 105

DELETING OBJECTS ................................................................................................................................ 106

OOPS! UNDELETING ...................................................................................................................................... 106

REDOING AN ACTION ..................................................................................................................................... 106

CUSTOMIZING OBJECTS ........................................................................................................................ 107

CHANGING OUTLINE/LINE COLOR AND STYLE ............................................................................................. 107

CHANGING FILL COLORS .............................................................................................................................. 108

ADDING A SHAPE EFFECT ............................................................................................................................ 109

WORKING WITH TEXT ............................................................................................................................. 110

CHANGING FONTS ......................................................................................................................................... 110

CHANGING POINT SIZE .................................................................................................................................. 110

STARTING A NEW PRESENTATION ....................................................................................................... 111

SWITCHING BETWEEN MULTIPLE PRESENTATIONS ............................................................................... 112

SAVING A PRESENTATION ..................................................................................................................... 113

PRINTING................................................................................................................................................... 114

ADDING/DELETING SLIDES .................................................................................................................... 118

ADDING A NEW SLIDE .................................................................................................................................... 118

DELETING A SLIDE ......................................................................................................................................... 119

Microsoft Office 2007

INSERTING SHAPES AND CLIPART ...................................................................................................... 120

ACCESSING THE COMPLETE LIST OF SHAPES ......................................................................................... 121

INSERTING CLIPART ...................................................................................................................................... 122

REMOVING A CLIP ART ITEM ........................................................................................................................ 125

MOVING TEXT ........................................................................................................................................... 127

PASTE FORMAT OPTIONS ............................................................................................................................. 128

COPYING TEXT ......................................................................................................................................... 129

USING THE OFFICE CLIPBOARD ........................................................................................................... 130

CLIPBOARD OPTIONS .................................................................................................................................... 132

Microsoft Office 2007

HOW TO USE THIS MANUAL

This manual was designed to be used as a reference. This is not a step-by-step tutorial. Our

feeling is that you did not pay to have someone stand in front of class and read you something

that you could do on your own. Through our own classroom experience we have discovered

that students don't read detailed descriptions and that lengthy text is ignored. They prefer to

explore and try things out.

In typical tutorials, students often get lost following rote procedures and get caught in error

conditions from which they can't back out of. Besides, once students leave class, they just

want something they can use to look up a subject quickly without having to read through an

entire tutorial.

Our design ensures that each course is stimulating and customized yet covers the outlined

objectives. The left page of your manual is designed for note-taking. That way, you won't

have to switch between your notebook and a manual whenever you need to look up how to

perform an operation.

Keys and commands that you need to press are displayed as icons such as E or Z.

Each topic starts on a new page, making things easy to find and follow. In addition, topics

covering actual commands always begin with the USAGE section where we explain the

purpose of the command.

Although you will usually be using the mouse to make your selections there are also shortcut

keys that can be used at times so we will also include those. Any keyboard shortcuts will be

displayed with a keyboard icon while mouse shortcuts will include a picture of the mouse icon.

The next page shows how a typical topic will be discussed and each part found in the book.

Microsoft Office 2007

 Running MS Word

 The Word Screen

 Getting Help

 Creating a New Document

 Changing Views

 Saving & Naming a File

 Spell Checking

 Printing Documents

 Opening Existing Files

 Navigating through Documents

 Deleting Unwanted Text

 Applying Attributes

 Page Setup

 Paragraph Alignment

Microsoft Office 2007

RUNNING MICROSOFT WORD

USAGE: Microsoft Word (along with all of the other MS Office 2007

applications) can be accessed through the desktop or through the

Start menu.

If you have assigned a shortcut to your desktop,

double-click on the Microsoft Office Word 2007 icon

to run the application.

Although the quickest way of running Word is obviously through the

desktop, you can also access the Start menu which allows you to

locate any program available on your system.

Follow these steps to run Word from the Start menu:

 Click on this button (located along the far left

side of the taskbar) to access the Windows

Start menu.

 Select from the pop-up menu.

 Select Microsoft Office Word 2007 from the sub-menu.

Microsoft Office 2007

THE WORD SCREEN

After you start the program, you are taken into a blank untitled document where you may begin

entering your text. The screen can be quite intimidating the first time you see it as there are so

many items displayed on it. However, if you take a few minutes to familiarize yourself with the

various screen elements, the program will become easier to work with.

Along the top left corner of the screen is the Office Button

which provides quick access

for creating, opening, converting, saving, printing, preparing, sending, publishing, and closing

files. Recently accessed documents are also listed under this button. This button provides the

only true menu within Word 2007 or any other MS Office 2007 application.

To the right of the Office Button is the Save tool as well as the Undo and Redo tools. Since

those are tools that are most often used, they are placed in a convenient location on what is

referred to as the “Quick Access Toolbar”. Click on the button to the right of these tools to

customize this Quick Access Toolbar.

The name of current document followed by the application name is displayed in the middle.

Microsoft Office 2007

The far right side of this line contains three icons for minimizing ,

maximizing , and closing the document or program.

The second line contains a new feature within Word 2007. There

are tabs located on this line which are used to access a series of

Ribbons to help you quickly find the commands needed to

complete a task. Commands are organized in logical groups that

are collected together under these tabs. Each tab on the Ribbon

relates to a type of activity, such as inserting an object or laying out

a page. To reduce screen clutter, some tabs are shown only when

they are needed.

There is no way to delete or replace the Ribbon with the toolbars

and menus from previous versions of Microsoft Office. However,

you can minimize the Ribbon to make more space available on the

screen. To quickly minimize the Ribbon, press C+!. If you

prefer using the mouse, point to an empty space just to the right of

the last tab across the top of your screen and click the [RIGHT]

mouse button. From the pop-up menu, choose Minimize Ribbon.

If you press C+! a second time, the Ribbon will again be

displayed. If you prefer using your mouse, point just to the right of

the last tab and click your [RIGHT] mouse button. From the pop-up

menu, again choose Minimize Ribbon (this time to de-select it).

Use the A key to access the ribbon directly from the keyboard.

For example, if you were to press A+n, you could access the

“Insert” Ribbon. Each time you press A, Word displays

corresponding letters for the ribbon items to help you to continue

using keyboard shortcuts to select them.

Along the right side of the screen is the scroll bar used to quickly

move (vertically) within your document. Use the arrows located

across the top and bottom of the scrollbar to move up and down.

To move more quickly, drag the small rectangle located within the

scroll bar to the desired location (up or down).

If you zoom to a larger size than can fit horizontally within the

window, a horizontal scroll bar will appear across the bottom of the

screen.

Below the vertical scroll bar are three buttons which are used to

move up and down between pages and/or document objects.

Microsoft Office 2007

WORKING WITH HELP

USAGE: All of the MS Office 2007 applications have an extensive help

database that can assist you with virtually any topic you encounter

while working with the program.

Help can be as generic as explaining how to print within the

program or as specific as detailing each item within a dialog box.

To display help in any of the 2007 applications, simply click

on this tool (located on the far right side of the tabs and just

above the Ribbon).

Microsoft Office 2007

Notice that a generic group of topics is listed in the help box when

you first enter it. If you don’t see the topic you want help on, simply

click in the text box provided towards the top of the help window

and then enter the topic (e.g., printing). When done, press E.

Word will search through its help database and replace the current

list with a group of topics related to the item you entered.

There are several buttons across the top of the help window:

If you have been moving between help topics, click on the

back arrow button to return to the previous help topic.

If you have returned to a previous help topic, click on the

forward arrow button to display the next topic.

If you are viewing a topic online and it is taking a long time to

load, click on this button to cancel the help page.

Click on this button to refresh the help window.

Click on this button to return to the original help topic list.

Click on this button to print the current help topic.

Click on this button to increase/decrease the text size for

viewing purposes in the help window.

Click on this button to access Word’s complete table of

contents for help. A task pane will be opened along the left

side of the window, listing all of the help topics and allowing

you to scroll through them. Click on this button a second

time to close the task pane.

Click on this button to keep the current help topic on top.

Click on the down arrow

beside this button to

select the type of help topic you would like displayed.

Click on this button to specify whether you want to

search for online help or display only the offline topics

that come with MS Word.

Microsoft Office 2007

PRINTING HELP TOPICS

If you find a help topic that you feel might be a good idea to print,

you can have Word send that topic to the printer. This comes in

handy when a screen lists several choices or perhaps lists various

keyboard shortcuts.

Click on this tool to print the current help topic. A dialog box

containing two tabs will be displayed:

The first tab (labeled General) is divided into three main sections,

as discussed below:

Select Printer This section is used to select the printer. There

is also a checkbox to print the topic to a file.

Print Range Use this section to specify the print range.

Number of copies Sets the number of copies to print. If you are

printing more than one copy of a multiple page

topic, you can check the Collate box to have

Word organize each set of copies for you.

Microsoft Office 2007

The second tab (labeled Options) contains the following items:

Print frames This section is only used for documents that

have been divided into multiple frames and is

not available at this time.

There are also two check boxes at the bottom of the this dialog box

that allow you to print related linked documents as well as a table

that lists the links in the document.

Printing all links will also print any documents referred to (via links)

by the displayed topic. Printing a table of links adds a table at the

end of the printout which lists all linked documents.

When done, choose to begin the printing.

EXITING HELP

Click on this button (located in the top right corner) to close

the help window and return to your document.

Microsoft Office 2007

VIEWING OPTIONS

USAGE: Word provides more than one way to view a document. The five

views include Print Layout, Full Screen Reading, Web Layout,

Outline, and Draft. The main difference between these views is

your personal preference as to how you want to work with the

document. Each view has its own unique format. You can switch

between the views at any time. It is also possible to zoom in or out

of a document to get different perspectives of the same page.

The most common view within Word is "Print Layout". Print Layout

can be used to get a more accurate view of the final layout while

editing the document.

You can change the display mode by either accessing the View

Ribbon or using the viewing icons located towards the bottom right

of the screen - just above the status bar:

Click on this button to switch to Print Layout view.

This display shows the final page layout while still

allowing you to edit the document. Headers, footers

and all formatting are displayed within this view.

Click on this icon to switch to Full Screen Reading

Layout view. This view is best when opening simply

for reading as it hides most of the screen elements.

Click on this icon to switch to Web Layout view. This

display is used to create documents for the Internet.

Click on this icon to switch to Outline view. This view

allows you to work with large documents - collapsing

certain sections while expanding others.

Click on this button to switch to Draft view. Headers,

footers and most of the formatting are not displayed

within this view.

If you click on this button (located to the right of the

viewing icons) a dialog box will open whereby you can

select a Zoom factor for the text displayed on the

screen. You can also use the

and buttons to

increase/decrease the zoom factor.

Microsoft Office 2007

Word places you in a new document as you enter the program. Although the screen may

appear to be blank, glancing in the upper portion of the screen (title bar) reminds you that a

document is being created.

You may immediately begin typing your file.

PRACTICE EXERCISE

Instructions:  Type in the following paragraphs. Remember not to press the

E key except at the end of each paragraph!

 Be sure to leave the errors included within the example as they are

since they will be used later to demonstrate spell checker.

TO ALL EMPLOYES:

As our fiscal year year comes to a close later this month, we ask that each employee keep

their overtime hours dowwn to a minimum.

At the moment, our company is on-target to meet its projected earnng estimates but we need

the assistance of all of our employees to keep costs down. Since overtime is one of our most

costly expenditures we incur, we espcially want to ask supervisors in each division to keep

overtime hours down.

Thank yu in addvance for your cooperation.

Microsoft Office 2007

SAVING A DOCUMENT

USAGE: After having typed a document, you will want to save it and assign

a name that will allow you to easily find it again. If you click on the

button, you will notice two options for saving a document:

Save and Save As.

Save is the normal save feature which will ask you the first time you

save a file to assign a name to it. From that point on, choosing

SAVE will simply update the file to include the new information. On

the other hand, Save As saves an existing file under a new name

or as a different format to be imported into another program.

Click on the Save icon (located on the Quick Access Bar).

The first time you save a document, Word provides a dialog box

prompting you to enter a file name, as shown below:

Letters, numbers and spaces are allowed. Enter 1-255 characters.

Notice that Word defaults to assigning the new “docx” extension.

This extension is new in version 2007.

Microsoft Office 2007

Along the left side of the dialog box, Word displays the Navigation

Pane. This pane lists common/favorite locations (links) as well as a

section for browsing your folders and drives. You can hide/display

the “Folders List” section at the bottom of this area by clicking on

the

arrows.

In this latest version of Word using Windows Vista, the address bar

is displayed a bit differently, as shown below:

Notice the path is displayed horizontally on the bar instead of

vertically (as was the case in previous versions). For example, in

the diagram shown above the currently selected item is the “Data”

drive (W) which is part of your computer. To get to that folder, you

had to first choose your computer, then the Data drive (W). This

new layout is commonly referred to as “bread crumbs” because it

shows you the path that was taken to get to the current location.

You can easily move to another folder on the “W” drive by clicking

on the

arrow beside the drive name and then selecting a different

folder to view.

In the box provided, enter a name for the new file. Letters,

numbers and spaces are allowed. Enter 1-255 characters.

Notice that Word defaults to assigning the new “docx” extension.

This extension is new in version 2007.

If you want to save the document in another format (such as

another word processing application or any previous version of

Word so that someone else can edit the document who does not

have this version), click on the down arrow

beside the box

labeled Save as type and select the format from the list provided.

Enter a name for the document in the box labeled File name and

then click on

to actually save the document.

TIP: The shortcut key for saving is

Microsoft Office 2007

USING THE SPELL CHECKER

USAGE: Before printing and sending a document out for others to read, you

should always spell check it for typing errors. By comparing words

in your file against the dictionary, Word can check your spelling and

alert you of possible mistakes.

For each word the program cannot find in its dictionary, Word asks

what to do. You will be able to choose to change the spelling,

suggest alternative words, have the word remain as it is, or add the

word to the dictionary. Word also checks for words that are

incorrectly capitalized and for repeated words.

Click on the Spelling and Grammar tool (located within

the Proofing section on the Review Ribbon).

Word will display the following box:

Microsoft Office 2007

The top section of the box contains the first unrecognized word -

shown in red with its accompanying sentence so you can see how

you were using the word within the document. The bottom of the

dialog box contains suggestions for correcting the flagged word.

If the word should remain as it is, select the

Ignore Once button. Word also offers the

option of Ignore All if the word in question

appears throughout the document.

If the word should be added to your custom

dictionary for future reference, click on this

button.

If one of the suggestions is correct, double-

click on the correct spelling or highlight the

word and choose the Change button. If you

are afraid you misspelled a word more than

once, click on the Change All button.

If both the word and suggestions are incorrect,

you can type the correct spelling in yourself

since your cursor is already blinking in the top

section (beside the selected word. Afterwards,

press E or select Change.

Use this button to add the word to the

AutoCorrect list. In the future, when you

misspell this word while typing, Word will

automatically correct it - without you having to

access the spell checker.

Reverses the latest actions made during the

current spell checking session.

Check this box to include grammar checking.

Microsoft Office 2007

This button is used to change the options

associated with spelling and grammar features.

This box provides a variety of options to customize how the spell

checker works. You can specify whether to suggest and where to

get the suggestions and what you want to ignore during the spell

checker (such as uppercase words or words containing numbers).

Click on to add or modify custom dictionaries,

such as medical and legal to be used during spell checking.

In addition, you can specify grammar options, such as how often to

check, and what writing style to use.

Once all options are selected, choose . You will be

returned to the original spell checking box where you can continue.

After running the spell checker, save your document again.

Microsoft Office 2007

You can also select what you actually want printed (e.g., the

document, the summary screen, etc.), how many copies are

needed and which pages you want printed.

You can save the print settings to a file so that you can print at a

later time and specify whether multiple copies should be collated.

You can also choose to enable the manual duplex option, which

allows you to print double-sided by having Word prompt you to turn

the paper over once the first side has been printed.

This button allows you to even further specify how the

document will be printed.

Once all printer options have been set, choose to have

Word begin printing the document.

TIP: The shortcut key for printing is

Microsoft Office 2007

CLOSING A DOCUMENT

USAGE: Although you can have several windows (documents) open at the

same time, it is usually a good idea to close a file once you have

saved and printed it if you no longer need to continue editing.

Click on the close button in the upper right corner of the

window to close the current document. If you only have one

document open and you click on this icon, Word will close

the entire program.

If you only have one document open and don’t want to close the

entire application, you can close the document by accessing the

Office menu, as shown below:

Click on the Office button.

Select Close from the Office menu.

NOTE: If you have made changes to the file and have not

saved those changes, Word will ask whether you want

to save the changes before closing the file.

Microsoft Office 2007

The window is divided into three sections. The far left section

contains a list of available template categories that you can base

your new document on.

The middle section lists the templates available within the category

you selected (from the left side of the window).

The far right section displays a preview of the currently selected

template. To preview a template before actually selecting it, click

on its name (within the middle section of the window) and then look

to the right side of the window for a preview.

Once you decide which template you would like to use, highlight its

name and then choose .

The new document will be created - based on the template you

have selected.

NOTE: To quickly create a new blank document without first

having to access the Office menu, press

SWITCHING BETWEEN MULTIPLE DOCUMENTS

When working with two or more open documents, you can switch

between them by accessing the View Ribbon and then clicking on

the button or you can quickly switch between open

documents using the Windows taskbar (located along the bottom of

your screen), as shown below:

Each time you create a new document or open an existing one,

Word displays it along your taskbar - making it easy to access.

Simply click on the document you want to switch to and that file will

become the active window.

Microsoft Office 2007

PRACTICE EXERCISE

Instructions:  Create the following document.

 Spell check the file to locate any mistakes you may have made.

 Save the file as AUDIT

 Print the file.

 Close the file.

Mr. James Doe

Anderson Accounting Firm

111 West 57

Street, Suite 1500

New York, NY 10014

Dear Mr. Doe,

I am writing on behalf of my company to thank you for the work your accounting firm did for us

last month during our audit.

Because of your experience in the matter along with detailed record-keeping on our part, we

passed with flying colors.

What could have been a stressful situation turned out to be quite simple. Your firm is largely

responsible for that outcome.

Thank you again for your assistance. I hope that our companies can continue to do business

in the future.

Sincerely,

Sally Smith

Vice President of Operations

Microsoft Office 2007

OPENING AN EXISTING DOCUMENT

USAGE: Whenever you want to work on a document that already exists, you

will need to open it.

Click on the Office button.

Select Open from the Office menu.

The following dialog box will be displayed:

Along the left side of the dialog box, Word displays the Navigation

Pane. This pane lists common/favorite locations (links) as well as a

section for browsing your folders and drives. You can hide/display

the “Folders List” section at the bottom of this area by clicking on

the arrows.

Microsoft Office 2007

In this latest version of Word using Windows Vista, the address bar

is displayed a bit differently, as shown below:

Notice that the path is displayed horizontally on the bar instead of

vertically (as was the case in previous versions of Windows). For

example, in the diagram shown above the currently selected item is

the “Data” drive (W) which is part of your computer.

To get to that folder, you had to first choose your computer, then

the Data drive (W). You could then select the folder containing

your Word documents.

This new layout is commonly referred to as “bread crumbs”

because it shows you the path that was taken to get to the current

location.

You can easily move to another folder on the “W” drive by clicking

on the arrow beside the drive name and then selecting a different

folder to view.

Across the top of the window are the following buttons:

Click on this button to access the Organize

pull-down menu. From the resulting pull-down

list, select the operation (e.g., cut, copy, paste,

delete, rename) you want to perform on

existing files listed within this box.

To change the display of the files, click on the

down arrow

beside this button.

Click on this button to create a new folder.

Microsoft Office 2007

When ready, double-click on the name of the file you want to open

or highlight the name and click on to open the file.

If you click on the down arrow beside the

button, you can choose from a list

of options (such as opening the file as read-

only or in your Web browser).

TIP: To open more than one file at a time, select the first

file by clicking on its name once to highlight it. Next,

hold the

key down as you click on each

additional file to be opened. Once all files have been

selected, click on to actually open them.

Each file will be placed in its own window.

TIP: The shortcut key for opening files is

Microsoft Office 2007

NAVIGATING WITHIN A DOCUMENT

USAGE: When working with large files you should know the quickest ways of

moving from page to page and from one area to another.

Z Moves one line up.

Y Moves one line down.

Q Moves one character to the left.

R Moves one character to the right.

C+R Moves one word to the right.

F+Q Moves one word to the left.

F+Y Moves one paragraph down.

F+Z Moves one paragraph up.

} Moves to beginning of the current line.

~ Moves to end of the line.

C+g Moves to specified page number.

F+} Moves to beginning of the file.

F+~ Moves to end of the file.

O Displays the previous screenful.

N Displays the next screenful.

To scroll through the document using the mouse, click on one of

the arrows located on either the horizontal or vertical scroll bar.

If you drag the scroll box on the vertical scroll bar up or down, Word

will display the current page number to the left of the box. When

you see the desired page, release the mouse button and that page

will be displayed.

If you are using a mouse with a scroll wheel, roll the rubber wheel

(located between the [LEFT] and [RIGHT] mouse buttons) forward

or back to quickly scroll through large documents.

NOTE: If you are using the mouse to move through a

document, remember that you must click on the new

page before the cursor will move to the new location!

Microsoft Office 2007

Directly beneath the vertical scroll bar are two icons. The

top one moves to the previous page while the bottom icon

moves to the next page.

Click on this button (located between the previous and next

page icons) to change the method by which the previous and

next buttons will navigate through your document. For

example, you can set them to move from one graphic picture

to another rather than from page to page.

Once you click on the Select Browse Object button, a pop-

up box appears:

Each icon within this box represents a type of object

available within a Word document. The object you select will

be used to browse through the document. For example, if

you select the table object, the previous and next buttons will

go to the previous or next table within your document.

The previous and next buttons change color (to blue) if you

select anything other than page (the last icon on the first line

of the box) as the object.

You can see the description of each icon as your mouse

hovers over an icon.

If you click on the left side of the status line where the current page

number and section are displayed (located at the bottom of your

screen), Word will ask what page to "Go To".

Microsoft Office 2007

DELETING TEXT

USAGE: When a block of text is no longer needed, you can easily remove it.

¢ Deletes the character to the left of the cursor. Works

like a correctable backspace on a typewriter.

= Deletes the character to the right of the cursor.

SELECTING WITH THE MOUSE

Word Double-Click anywhere on the word.

Line Move the Insertion Bar to the left of a line until

it changes to an arrow . Click once.

Sentence Hold the F key down and click the mouse

button anywhere on the sentence.

Paragraph Move the Insertion Bar to the left of a line until

it changes to a pointer arrow . Double-Click.

Triple-Clicking on a paragraph also selects it.

Any Text Move the Insertion Bar to the beginning of the

block you want to delete. Click and drag.

Entire File Move the Insertion Bar to the left of a line until

it changes to a pointer arrow . Hold C

down and click once. Triple-Clicking on the left

side of the screen also selects the entire file.

You can also press

C+a to select the

entire document.

You can also use this button (located within the

Editing section of the Home Ribbon) to select

items. The pull-down list includes options for

selecting everything within the document,

graphic objects, or text with similar formatting.

After selecting the item(s) you wish to remove, press

Microsoft Office 2007

OOPS!! UNDELETING TEXT

USAGE: If you ever delete a portion of a document by mistake, Word has

the ability to undo that deletion. Undo instructs the program to

disregard the last action (whether it was deleting, copying, or

applying format changes). It is important to understand, however,

that certain actions (such as printing and saving) cannot be

undone. Word has the capability of remembering not only the last

action performed but the last several.

Click on the Undo tool to undo the last action.

If you click on the down arrow (to the

right of the tool), you can scroll through

the last several actions.

Move your mouse down the list to

highlight the number of actions to undo.

They must be done in sequence!

REDOING/REPEATING COMMANDS

If you undo an action and then change your mind (again), you can

always redo what you have just undone.

Click on this button to redo the last undo.

The Redo button (shown above) changes from Redo

to Repeat depending on what action was last

performed. For example, if you just deleted an item

and then chose to “Undo” the deletion, Word would

display the “Redo” button. However, if you just

applied an attribute (such as bold or underline) to a

block of text, Word would display the “Repeat” button

so that you could repeat the last action (applying the

attribute) for another block of text.

Microsoft Office 2007

APPLYING ATTRIBUTES

USAGE: As you enter and edit text, you can change its appearance to add

emphasis and make the document easier to read. This is called

formatting. Formatting the text means setting the font and size of

the letters, and emphasizing words using such attributes as bold,

underline or italics. To format characters you can either use the

keyboard or the Home Ribbon. All of the character attributes are

located within the “Font” section on this ribbon.

Before typing, turn on the attribute and then begin entering text.

When you want to turn the attribute off you press the same key.

Click on this tool to turn bold on and off.

Click on this button to turn italics on and off.

Click on this tool to turn underline on or off. Click on the

down arrow beside the tool to change the style and color.

When you select a block of text, Word displays a semitransparent

toolbar called the Mini toolbar. The Mini toolbar helps you work

with fonts, font styles, font sizing, alignment, text color, indent

levels, and bullet features.

When you see the transparent toolbar appear, simply point to the

attribute you want to set and select it with your mouse.

REMOVING ATTRIBUTES

After selecting the text containing the attributes you want

removed, click on the Clear Formatting tool (located within

the Font section on the Home Ribbon).

You can also press C+• to remove most attributes.

Microsoft Office 2007

CHANGING FONTS & POINT SIZE

USAGE: A font is a family of characters that have the same design. To

change fonts, you select the new font by its name.

 Click on the down arrow to the right of the Font tool

(located within the Font section on the Home Ribbon).

 Select the new font from the pull-down list. Notice how Word

displays a sample of each font within the pull-down list so

that you can see the font before actually selecting it.

 The new font begins at the current cursor location and

continues until the end of the document or until you change it

again. Begin typing your text.

NOTE: Notice that Word displays the current theme fonts

along with the last few selected fonts at the top of the

list for easy access.

NOTE: To change existing text, be sure to select the text first

and then choose the desired font. If text is selected,

as you scroll through the list of available fonts, Word

will display the selected text with the currently

highlighted font – as a preview.

Microsoft Office 2007

CHANGING THE POINT SIZE

 Click on the down arrow to the right of the Font Size

button (located within the Font section on the Home Ribbon).

 Select the desired font size from the pull-down list.

 The new font size begins at the current cursor location and

continues until the end of the document or until you change it

again. Begin typing your text.

NOTE: As was the case with attributes, to change existing

text, be sure to select the text first and then choose

the desired font size.

You can also use the following tools (both of which are located

within the Font section on the Home Ribbon) to quickly increase or

decrease the font size.

Click on this tool to increase the current font size.

Click on this tool to decrease the current font size.

Microsoft Office 2007

PAGE SETUP

USAGE: To change the margins, page orientation, and page size or other

features that affect the layout of your page, switch to the Page

Layout Ribbon.

CHANGING MARGINS

Click on the Margins tool (located within the Page

Setup section on the Page Layout Ribbon) to access

a list of preset margins.

Select the new margin setting from the list provided.

If you need a margin setting that is not included in this pull-down

list, click on Customize Margins…. (located at the bottom of the

list) to open a dialog box where you can enter custom margins.

Microsoft Office 2007

CHANGING ORIENTATION

Click on the Orientation tool (located within the Page

Setup section on the Page Layout Ribbon) to access

the page orientation options.

Select the page orientation from the two diagrams provided.

CHANGING PAPER SIZE

Click on the Size tool (located within the Page Setup

section on the Page Layout Ribbon) to access the

paper size options.

Select the paper size you would like to use. If you don’t see a size

in the list, click on More Paper Sizes… to access the Page Setup

dialog box.

Microsoft Office 2007

PARAGRAPH ALIGNMENT

USAGE: Depending on the type of document you are creating, you may find

it preferable to have a report title centered between the left and

right margins or to have the paragraphs fully justified.

Word is capable of aligning paragraphs, as shown below:

Word is automatically set for left alignment. To change the

alignment, place your cursor anywhere on the paragraph and select

one of the following tools (located on the Home Ribbon):

Left Aligned

Centered

Right Aligned

Full Justification

TIP: Typically the last line of a paragraph is shorter than

the rest of the paragraph and may not be justified. To

justify the last line, press

instead of

at the end of the line. However, if the line is

very short, there may be large gaps between words.

Microsoft Office 2007

 Running Excel

 The Excel Screen

 Navigating the Worksheet

 Changing Views

 Entering & Editing Data

 Working with Blocks

 Adjusting Column Width/Row Height

 Entering Formulas

 Using AutoFill

 Saving & Printing Workbooks

 Changing Page Setup

 Creating New Workbooks

 Opening Existing Files

 Aligning Cell Data

 Formatting Values

Microsoft Office 2007

RUNNING MICROSOFT EXCEL

USAGE: Just as you saw when running Word, Excel can be accessed

directly through the desktop or from the Start menu (located on the

taskbar at the bottom of the screen).

If you have a shortcut on your desktop, double-click

on the Microsoft Office Excel 2007 icon to run the

application.

Although the quickest way of running any MS Office 2007

application is obviously through the desktop, you can also access

the Start menu which allows you to locate any program available

on your system.

Follow these steps to run Excel from the Start menu:

 Click on this button (located along the far left

side of the taskbar) to access the Windows

Start menu.

 Select from the pop-up menu.



 Select Microsoft Office Excel 2007 from the sub-menu.

Microsoft Office 2007

The far right side of this line contains three icons for minimizing ,

maximizing , and closing the workbook or program.

The second line contains a new feature within Excel 2007. There

are tabs located on this line which are used to access a series of

Ribbons to help you quickly find the commands needed to

complete a task. Commands are organized in logical groups that

are collected together under these tabs. Each tab on the Ribbon

relates to a type of activity, such as inserting an object or laying out

a page. To reduce screen clutter, some tabs are shown only when

they are needed.

There is no way to delete or replace the Ribbon with the toolbars

and menus from previous versions of Microsoft Office. However,

you can minimize the Ribbon to make more space available on the

screen. To quickly minimize the Ribbon, press C+!. If you

prefer using the mouse, point to an empty space just to the right of

the last tab across the top of your screen and click the [RIGHT]

mouse button. From the pop-up menu, choose Minimize Ribbon.

If you press C+! a second time, the Ribbon will again be

displayed. If you prefer using your mouse, point just to the right of

the last tab and click your [RIGHT] mouse button. From the pop-up

menu, again choose Minimize Ribbon (this time to de-select it).

Use the A key to access the ribbon directly from the keyboard.

For example, if you were to press A+n, you could access the

“Insert” Ribbon. Each time you press A, Excel displays

corresponding letters for the Ribbon items to help you to continue

using keyboard shortcuts to select them.

Along the right side of the screen is the scroll bar used to quickly

move (vertically) within your workbook. Use the arrows located

across the top and bottom of the scrollbar to move up and down.

To move more quickly, drag the small rectangle located within the

scroll bar to the desired location (up or down).

There is also a horizontal scroll bar that you can use to move left

and right through your workbook.

Microsoft Office 2007

The next section across the top of the screen lists the columns and

rows within the current worksheet. As mentioned, columns are

lettered and rows are numbered. The first 26 columns are lettered

A through Z. Excel then begins lettering the 27th column with AA

and so on. In a single Excel worksheet there are 16,384 columns

(lettered A-XFD) and 1,048,576 rows (numbered 1-1048576).

The highlighted borders around the document window indicate the

columns and rows and are used to identify where on the worksheet

you are located since you obviously cannot see an entire worksheet

of this size on the screen at one time.

The worksheet itself is located to the right and beneath the borders.

This is where you will actually be working and entering information.

The outlined cell (the one with the dark borders) within the

worksheet is referred to as the active cell. Each cell may contain

text, numbers or dates. You can enter up to 32,767 characters in

each cell.

Towards the bottom of the worksheet is a small Tab that identifies

each sheet within the workbook (file). If there are multiple sheets,

you can use the tabs to easily identify what data is stored on each

sheet. For example, the top sheet could be "Expenses" and the

second sheet could be called "Income". When you begin a new

workbook, the tabs default to being labeled Sheet1, Sheet2, etc.

Along the bottom of the screen is another bar called the Status

Bar. This bar is used to display various information about the

system and current workbook. The left corner of this line lists the

Mode Indicator which tells you what mode you are currently

working in. When Excel is ready for you to enter text, the mode

indicator will read “Ready”.

Just below and to the left of the vertical scroll bar is the Zoom

section. Notice you can click on the increase

or decrease

buttons to change the zoom factor. You can also drag the slider

horizontally to change the text size as it appears on the screen.

Excel displays the current percentage just to the left of this area.

Microsoft Office 2007

To the left of the zoom area are three View Icons. These are used

to change the current display (Normal, Page Layout, and Page

Break Preview). Simply click on the view you want to switch to.

To make working with multiple workbooks less confusing, Excel has

included a feature which automatically displays all opened

workbooks along the taskbar. Rather than having to access the

Ribbon labeled View to switch between opened files (windows),

you can simply use your mouse to click on the name of the file you

want to access directly on the taskbar. Once selected, that file

becomes the active window.

Microsoft Office 2007

NAVIGATING WITHIN A WORKSHEET

USAGE: Excel offers both keyboard and mouse methods for moving:

Q Moves pointer left one column.

R Moves pointer right one column.

Z Moves pointer up one row.

Y Moves pointer down one row.

A+N Moves one full screen to the right.

A+O Moves one full screen to the left.

O Moves one full screen up.

N Moves one full screen down.

} Moves to the beginning of the row.

C+R Moves to the next blank/filled cell in a row.

C+Q Moves to the first blank/filled cell in a row.

C+Y Moves to the next blank/filled cell in a column.

C+Z Moves to the previous blank/filled cell in a column.

F+} Moves to beginning of worksheet (A1).

F+~ Moves to bottom right corner of worksheet.

C+g The GOTO key allows you to go to any cell. You

must know the cell address. You can also press %.

Click in this box and type in the cell address to

go to. You must press E when done.

You can also use the vertical (down the right) and the horizontal

(along the bottom) scroll bars to move. Drag the box in the scroll

bar to move more quickly. The pointer does not move until you

click in the cell to move to. Remember to look at the formula bar for

the current cell address.

If you are using a mouse with a scroll wheel, roll the rubber wheel

(located between the [LEFT] and [RIGHT] mouse buttons) forward

or back to quickly scroll through large worksheets.

Excel lights up column and row headings as you move from cell to

cell. This helps to distinguish the current cell address.

Microsoft Office 2007

ENTERING INFORMATION

USAGE: Excel allows you to type in words, numbers or formulas.

Click in the cell you want to store the data in and then simply begin

typing the word(s), number or formula.

If you make a mistake and want to start over, press X.

Notice as you type, the entry is displayed both in the cell and in the

formula bar. A thin, blinking cursor appears to the right of the entry

and moves as you type.

If you make a mistake while typing, use the ¢ key to correct

what has already been entered.

You cannot use the arrow keys at this time to make corrections!

Pressing an arrow key at this point will enter what you have typed

in the cell and then automatically move the pointer in the direction

of the arrow key you pressed.

Two symbols also pop up to the left of the formula bar. The

 can

be used by mouse users instead of pressing the E key. The X

is used like the X key to cancel.

When entering text, words are automatically left aligned within the

cell while numbers are placed to the right.

While entering columns of numbers, the column heading may not

align correctly with the values. If text is wider than the cell it is

stored in, it will appear to "spill" into the adjacent cell(s), providing

they are empty.

Microsoft Office 2007

EDITING DATA

USAGE: If you type something in a cell and then decide later to change or

correct it, place your pointer on the cell to edit and reactivate it by

selecting from one of the two methods mentioned below:

Double-Click on the cell you want to edit.

If you prefer using the keyboard, press

Your cursor will appear within the cell in the form of a vertical bar

and you will be able to use

¢ and = to make corrections.

You can also use the following keys for movement while editing:

} Moves to the beginning of the entry.

~ Moves to the end of the entry.

R Moves the cursor to the right one character.

Q Moves the cursor to the left one character.

F+R Moves the cursor one word right.

F+Q Moves the cursor on word left.

When done editing the cell, press

E or click on .

Microsoft Office 2007

CLEARING A CELL

Excel not only allows you to clear the contents of a cell (the actual

data), but also the format and/or comments attached to the cell.

A single cell may contain one or more of the following:

Formats Includes fonts, bold, borders surrounding the cell(s),

as well as, number formats (e.g., dollar signs).

Contents The data stored within the cell (numbers or text).

Comments Can be attached to a cell to explain the reasoning

behind its entry (e.g., when entering complex

formulas). These comments are usually not printed.

Click on this tool (located within the

“Editing” section on the Home Ribbon).

Choose what you want to clear from the

pull-down list provided.

Microsoft Office 2007

OOPS! UNDOING THE DELETION

Excel has the capability of remembering the last several actions

performed and allows you to change your mind about most

changes you have made.

Click on this tool (located towards the top left corner

of your screen) to undo the last action.

If you click on the down arrow (to the

right of the tool), you can scroll through

the last several actions.

Move your mouse down the list to

highlight the number of actions to undo.

They must be done in sequence!

REDOING COMMANDS

If you undo a set of actions and then change your mind (again), you

can always "Redo" what you have just undone.

Click on this tool (located towards the top left corner

of your screen) to redo the last undo.

Microsoft Office 2007

WORKING WITH BLOCKS

USAGE: Many commands and operations require that you work on more

than one cell at a time. While you may not require the entire

worksheet, you may need to work on a Block of cells.

A block includes any group of cells in a rectangular format, as

shown in the illustration below.

Every block of cells has a beginning and ending address. The

beginning address is the address of the cell in the top-left corner of

the block whereas the ending address is the cell in the lower-right.

Normally, in the English language we use a dash to indicate a block

of numbers, as in pages 5-20. Excel, however, requires that you

use the colon between the beginning and ending addresses.

Remember that the dash represents subtraction in spreadsheet

programs. For example, the block C3:E14 refers to cells C3

through E14.

There are many commands (e.g., deleting, copying, formatting) that

require the use of blocks.

Microsoft Office 2007

MOUSE SHAPES

When working with Excel, it is very important to keep an eye on the

mouse pointer as it changes shape depending on its current

function, as discussed below:

If the mouse is in the shape of a thick cross, it can be

used to select a single cell or block of cells for editing

purposes.

The mouse changes to the thick cross when placed in

the middle of a cell. Dragging the pointer when it is

this shape simply highlights cells.

If the mouse is in the shape of a diagonal arrow, you

can move the contents of the currently selected cell or

block of cells to another location within the worksheet.

The mouse changes to a pointer only when the tip of

the arrow points to one of the outer borders of the cell

block. Dragging the pointer when it is in this shape

actually picks up the contents of the cell(s) and moves

them to another location.

If the mouse is in the shape of a thin cross-hair, you

can fill a formula or other information into adjacent

cells within the worksheet.

The mouse pointer changes to a thin cross-hair only

when the tip of the arrow is placed in the small square

located in the bottom right-corner of a cell. Dragging

the pointer when it is in this shape fills data.

Microsoft Office 2007

ADJUSTING COLUMN WIDTH & ROW HEIGHT

USAGE: Sometimes cell entries are too long to fit into the standard width

columns. Text will appear to "spill" over into adjacent cells as long

as those cells are empty. If the adjacent cells are not empty, Excel

will truncate the text.

When entering large numbers, however, Excel will display the

number in scientific notation if the column is not wide enough to

display the entire number. However, if you apply formatting (such

as dollar signs), Excel will automatically adjust the column to fit the

largest entry so that the number remains visible.

Should a cell be too narrow for text or numbers that you have

entered, you can widen the column in which the entry is located by

following the steps outlined below:

 Place the mouse pointer in the column heading area to the

right of the lettered column to adjust. Make sure the mouse

pointer is on the column margin line. The pointer changes to

a cross-hair indicating you are on the margin line.

 Click and drag the column margin line either to the right

(expanding it) or to the left (shrinking it).

In the example above, column F is being stretched to the right.

Notice the "cross-hair".

Microsoft Office 2007

WORKING WITH FUNCTION ARGUMENTS

USAGE: General mathematical functions are provided with Excel to carry out

calculations on data within the spreadsheet and can take the place

of certain types of formulas.

Functions begin with the = sign just as formulas do. For example, if

you had a large column of numbers to be added (A1:A100), you

might think you need a long formula to include all of the addresses

(=A1+A2+A3....+A99+A100). However, Excel provides a

mathematical function which is used primarily to add blocks of

numbers. The formula could be re-written as =SUM(A1:A100)

which is much shorter.

To calculate the sum of a block of numbers, move to the cell where

the answer is to be placed and use this function argument:

=SUM(FIRST CELL:LAST CELL)

You must define the block just like any other block by specifying the

first and last cell addresses.

To calculate the average value for a block of cells:

=AVERAGE(FIRST CELL:LAST CELL)

To return the largest value in a block of cells:

=MAX(FIRST CELL: LAST CELL)

To return the smallest value in a block of cells:

=MIN(FIRST CELL:LAST CELL)

To count the number of numeric entries in a block of cells:

=COUNT(FIRST CELL:LAST CELL)

Microsoft Office 2007

WORKING WITH FUNCTION ARGUMENTS

If you would like some guidance, Excel can list the most common

functions and then prompt you for the various arguments required

by displaying the function arguments.

As soon as you type the ™ sign, this button

will be listed along the left side of the Formula

Bar. The last function you chose will be

displayed on the button. If you simply click on

the button that function will be selected.

To choose a different function, click on the

down arrow to the right of the button and

then select a new function from the list.

Once the function has been selected Excel will display the Function

Arguments box, as shown below:

The box will display a description of the currently selected function

and list the arguments required for the function.

The next required argument will be displayed in bold. This helps

guide you through each step properly.

Notice as you begin entering the arguments, the palette displays

the current result.

When you are done, click on

to actually enter the

function and close the box

Microsoft Office 2007

THE AUTOSUM FEATURE

Excel can make somewhat of an intelligent decision on its own and

determine which cells of a row or column should be "summed".

This is called the AutoSum feature.

To quickly add the contents of a column or row, follow the steps

shown below:

 Select the cell either to the right or below the cells that are to

be totaled.

 Double-Click on this tool (which is located

within the Editing section on the Home

Ribbon).

NOTE: If you only click on the AutoSum tool once, Excel will

highlight the cells it assumes you want to include in

the formula. The second click is used to confirm the

selection.

If, by chance, Excel has selected the wrong group of

cells, you can highlight the correct block before

clicking on the tool a second time.

Microsoft Office 2007

USING THE AUTO FILL

USAGE: Excel offers a quick way to fill formulas from one cell to many within

the worksheet. This command instructs Excel to copy cells from

one row/column in a selection to adjacent cells of the selection.

 Place your mouse over the small square in the lower right

corner of the cell containing the formula you want to copy.

The pointer should change to a thin cross-hair

 Click the [LEFT] mouse button and drag so that all

destination cells are selected. When the mouse is released,

the formula will be "filled" in all cells.

Filling also works for text and numbers without formulas, such as

months (shown in the example above). In this example, entering

“Jan 2006” converts to Jan-06 and can then be used to fill a block

of cells with other months.

Excel's auto fill feature will fill a block of cells with either numbers or

text depending on what is located in the first cell.

As you begin filling the destination cells with months, Excel will

display the name of each month as it is being filled so that you

know how far to fill.

TIP: To quickly fill the current cell with the contents of the

cell above it, press

(to fill downward).

To fill the current cell with the contents of the cell to

the left of it, press

(to fill right).

Microsoft Office 2007

When working with numbers, however, you must enter two cells of

data so that Excel knows what increments the numbers should be

increased by each time. If you only enter a single number and then

try to create a fill based on that single cell, Excel will simply copy

the number down the worksheet.

To fill cells with a series of numbers, follow these steps:

 Select the two cells containing the numbers. Once the two

cells have been selected, release the mouse button.

 Move the mouse to the bottom right corner of the second

cell. The pointer should change to a thin cross-hair .

 Click & drag the mouse to fill the other cells.

USING THE FILL TOOL

You can fill cells in any direction and into any range of adjacent

cells using the fill tool.

After selecting the cells to fill, click on this tool

(located within the Editing section on the Home

Ribbon).

A pull-down list of fill options will be displayed:

Select the direction of the fill or define the series to use when filling.

Microsoft Office 2007

AUTO FILL OPTIONS

Once you have used the auto fill feature, a small icon will be

placed in the bottom right corner of the last filled cell.

When you click on this icon, a list of

auto fill options is displayed. The default

option is Copy Cells which instructs

Excel to copy the data and formatting

from the original cell to the destination

cells.

The Fill Formatting Only option is used

to copy the format from the original cell

to the destination cells. This does not

copy the data from the original cell.

Select Fill Without Formatting to copy

the data from the original cell to the

destination cells without changing the

existing format.

NOTE: These auto fill options will vary depending on what you

have just filled (e.g., a formula, a number, a month).

Microsoft Office 2007

CHANGING THE PAGE SETUP

USAGE: Before you actually print a worksheet, you may want to customize

the file to change margins, adjust page orientation, add

headers/footers, or modify other features.

CHANGING MARGINS

Click on the Margins tool (located within the Page

Setup section on the Page Layout Ribbon) to access

a list of preset margins.

Select the new margin setting from the list provided.

If you need a margin setting that is not included in this pull-down

list, click on Customize Margins…. (located at the bottom of the

list) to open a dialog box where you can enter custom margins.

Microsoft Office 2007

SHEET PRINTOUT OPTIONS

Click on the Sheet tab to customize the print features that affect the

overall sheet, as shown below:

Print area Use this section to specify the block to be printed. If

you selected a block before you entered this box, the

block will already be displayed. If not, you may enter

the range as A1:B15 to specify that the block from A1

to B15 should be printed. You can enter more than

one range if you separate the ranges with a comma -

as in A1:B15,D20:F40.

Print titles This section allows you to specify rows to be printed

along the top or the columns to be printed along the

left of each page. To specify a range, click in the row

or column section and then type the block.

Click on this button (to the right of these two sections)

to return to the worksheet to select the block. When

done, reactivate the Page Setup dialog box.

Produktspecifikationer

Varumärke:	Microsoft
Kategori:	Office-programvara
Modell:	Word 2007
Plattform:	PC
Modell:	Ordbehandlare (WP)
Kompatibla operativsystem:	Microsoft Windows XP (SP2)\nMicrosoft Windows Vista\nMicrosoft Windows 7\nMicrosoft Windows Server 2003 (SP1)\nMicrosoft Windows Server 2008
Mediatyper som stöds:	CD
Minsta systemkrav:	CD/DVD-ROM
Antal licenser:	1 licens/-er
Språkversion:	Tyska
Mac-kompatibel:	Nej
Minimum hårddisk utrymme:	1536 MB
Minimikrav, RAM:	256 MB
Minimikrav, processor:	500 MHz
Typ av programvara:	Låda