Microsoft®
Windows 7
Download More FREE Quick References! Visit: qr.customguide.com
Quick Reference Card Windows Explorer
Keystroke shortcuts
Address bar Displays the location of the folder that is currently open.
Title bar Click and drag to move the window.
Toolbar Displays buttons and menus for common commands.
General Start menu Search box Enter keywords to search the folder.
Navigation Pane Provides quick navigation to folders and files. Browse to favorite locations, libraries, homegroups, Computer, and the network.
> +
My Computer
+
, and type a keyword for the file or program. Search results are displayed in the menu.
• To Search for a File in a Folder or
Click the Change your view button list arrow on the toolbar and select a view.
• To Change Window Layout: Click the
Organize button on the toolbar, point to Layout, and select a layout option.
Library: Open the folder or library you want to search. Click the Search box in the upper right corner of the window and enter keyword(s) for the file you want to find.
• To Create a Folder: Click the New Folder
button on the toolbar. Type a name for the folder and press .
• To Add a Search Filter: After entering
keywords in the Search box, select a filter from the list that appears.
• To Add a Folder to a Library: Open the
library and click the locations link. Click the Add button. Select the folder and click Include folder.
• To Create a New Library: Open Computer
• To Change How Items are Displayed:
• To Use the Address Bar to Navigate:
Click a location on the Address bar to go to view it in the window. Click a location’s list arrow to view and open subfolders within the location.
• To Preview a File: Click the
and select Libraries in the Navigation pane. Click the New library button on the toolbar. Enter a name for the library press . Double-click the library and select the folders you want to include.
Preview Pane button on the toolbar or press + . Select the file you want to preview.
• To View a File or Folder’s Properties: Select the file or folder and view properties in the Details pane.
Peek at the desktop
+
Show/Hide desktop
+
Minimize all windows
+
Minimize other windows
+
Maximize
+
Minimize/Restore
+
Dock to left
+
Dock to right
+
Jump to left monitor
< > + +
Jump to right monitor < > + + Show/Hide Preview Pane
+
Bring all gadgets to the front
+
Cycle through icons
+
Open new instance
+ click
Taskbar
Launch program < > + (# corresponds to pin order)
Windows Taskbar Window preview: Point to the program icon on the taskbar. Click a preview thumbnail to view the window.
Start button: Opens the Start menu.
Program icon: Click to open the program. Rearrange icons by clicking and dragging.
Customizable Computer Training 9 Courseware
9 Online Learning 9 Skills Assessments
Show Desktop button: Point or click here to make open windows invisible.
Notification area: The Action Center, clock, and other system icons are located here.
© 2009 CustomGuide
www.customguide.com | Phone 888.903.2432
Jump Lists
Aero
Aero Peek makes open windows invisible so you can view the gadgets and icons on the desktop.
Items at the top of the list are pinned to the program’s jump list. The Frequent section displays files or pages that have been frequently used.
• To See Through Windows with Aero Peek: Point to the Show Desktop button on the right edge of the taskbar or press
+ .
• To View Open Windows with Aero Peek: Point to the program
icon on the taskbar that contains the file or window you want to view. Click the thumbnail preview to view the window.
Right-click an icon on the taskbar…
…to view the jump list for the program.
• To Minimize Other Windows with Aero Shake: Click and drag a window's title bar quickly from side to side. Or, press
+ .
• To Compare Windows Side by Side with Aero Snap: Click and drag a window's title bar to the right side of the screen, and drag the other window to the left side of the screen. Or, press < > + < → > and < > + .
• To Maximize an Open Window with Aero Snap: Click and drag
the window's title bar to the top of the screen or, drag the bottom border of the window down to the taskbar. Or, press < > + < ↑ > .
• To Flip through Windows with Flip 3D: Press < continue to hold down the < the open windows.
> + ; > key while pressing to scroll through
Personalization • To Personalize Windows 7 Appearance and Sounds: Right-click the desktop and select Personalize. The Personalization window appears. Click the appropriate links to personalize these settings: • Themes – Change menus, icons, backgrounds and sounds all at once. • Desktop Background – Choose built-in colors and pictures, or use your own. Select more than one picture to start a slide show. • Window Color – Change window color and transparency. • Sounds – Change which sounds play when you perform different tasks. • Screen Savers – Adjust what it displays and when it appears. • Desktop Icons – Add icons to the desktop, such as Computer and Network. • Mouse Pointers – Change how the pointer looks and acts, reverse buttons.
Maintenance • To Defragment your Hard Disk: Open the Computer window (click the Start button and select Computer). Right-click the disk you want to defragment and select Properties from the contextual menu. Click the Tools tab and click the Defragment now button. • To Use Disk Cleanup to Free Space on Your Hard Drive: Open the Computer window (click the Start button and select Computer), right-click the hard disk, select Properties from the contextual menu and click the Disk Cleanup button. • To Uninstall a Program: Click the Start button and select Control Panel. Click the Uninstall a program link under Programs. Select the program you wish to uninstall from your computer, and click the Uninstall button on the toolbar.
• Jump Lists are quick shortcuts to files and commands that a program uses frequently. The items that appear in a jump list change according to the program selected. For example, Internet Explorer displays frequently visited pages, Microsoft Word displays frequently opened documents. • To View a Jump List: Right-click an icon on the Windows 7 taskbar. Or, click the list arrow next to a program icon in the Start menu. • To Pin a Program to the Taskbar: Open the program you want to pin, right-click the program icon on the taskbar and select Pin this program to taskbar from the jump list. • To Pin an Item to the Jump List: View the program jump list. Rightclick the item you want to pin and select Pin to this list. Or, point to an item Pin to this list button. on the jump list and click the • To Remove an Item from the Jump List: View the program jump list. Right-click an item that appears in the jump list and select Remove from this list from the contextual menu.
Gadgets • To Add Gadgets to the Desktop: Right-click the desktop and select Gadgets from the contextual menu. Double-click the gadget you want to add to the desktop. • To View Gadgets: Press < > + . The gadgets on your desktop appear on top of the windows that are open. • To Remove a Gadget from the Desktop: Point to a gadget and click the Close button that appears. • To Download New Gadgets: Right-click the desktop and select Gadgets from the contextual menu. Click the Get more gadgets online link at the bottom of the window, click the Desktop gadgets tab, and click the Download button for the gadget you want to add.
• To View a Gadget’s Options: Point at the gadget, then click the Options button to view and change settings for that gadget.
HomeGroup • To Join a Homegroup: Before you begin, make sure you have the homegroup password. Click the Start button and select Control Panel. Click the Network and Internet link. Click the HomeGroup link and click Join Now. Complete the wizard and enter the homegroup password as prompted. • To Create a Homegroup: Click the Start button and select Control Panel. Click the Network and Internet link. Click the HomeGroup link and click Create a homegroup. Complete the wizard to create the homegroup.
Customizable Computer Training 9 Courseware
9 Online Learning 9 Skills Assessments
© 2009 CustomGuide
www.customguide.com | Phone 888.903.2432
Microsoft®
Office 2010
Customizable T raining M aterials
Quick Reference CARD
(888) 903-2432 | qr.customguide.com
The XXXXRibbon
Quick Access Toolbar
Contextual tab
Tabs
Dialog Box Launcher
Group
• Ribbon: Displays the commands and tools you need to perform various tasks. The Ribbon can also be minimized and customized to fit your work style. • Tabs: Display the commands you can use in a Microsoft Office program. Click a tab to view its commands. • Contextual Tabs: Display commands for a selected object. • Dialog Box Launcher: Click to open a dialog box or task pane. • Group: Related commands that appear under each tab. • Gallery: A list of options and additional choices displayed as thumbnail previews so you can see results before making a choice. • Quick Access Toolbar: Provides quick access to the commands you use most frequently. The Save, Undo, and Redo/Repeat buttons appear on the Quick Access Toolbar by default. • To Minimize the Ribbon: Click the Minimize Ribbon button on the Ribbon. Or, press + . Or, double-click a tab on the Ribbon.
Minimize Ribbon
Help
Gallery
Or, right-click a tab and select Minimize Ribbon from the contextual menu. • To Customize the Ribbon: Right-click a tab and select Customize the Ribbon from the contextual menu. Or, click the File tab, select Options, and click Customize Ribbon. Use the controls in the dialog box to rename and rearrange tabs, and to rearrange tab commands. * Click the New Tab button to create a new tab on the Ribbon. * Click the New Group button to create a new group in a tab on the Ribbon. • To Add a Command to the Quick Access Toolbar: Click the Customize Quick Access Toolbar button and select a command from the menu. Click More Commands to select from a longer list of commands. • Get Help: Click the Help button. Or, press . Or, click the File tab and select Help from the menu.
File Tab and Backstage View and Commands • Info: Set permissions to control who can open or change the document; prepare the file for sharing by removing metadata and other personal information; and view and manage autosaved versions of the document. • Recent: Displays documents most recently opened in the program. • New: Create a new blank document or create a document from a template. Browse templates with the preview feature in Backstage view. • Print: Preview the document and select print settings at the same time. The right pane displays a preview of the file; the center pane displays print options. • Share: Share the file and change file type. There are four ways to share a document: 1. Send Using E-mail: Send the document as an attachment, a link, a PDF or XPS, or fax. 2. Save to SkyDrive: Save to a SkyDrive folder through your Windows Live account. 3. Save to SharePoint: Saves to a SharePoint workspace on your computer. 4. Publish: Publish the document to a service or blog.
Office Quick Reference ©2010 CustomGuide
Quick Tip The File tab replaces the File menu and Office Button found in previous versions of Microsoft Office. Common file management commands – Save, Save As, Open, and Close – appear at the top of the menu. Backstage view appears when you click the File tab. The left panel displays commands in the File tab menu. The center panel displays options related to the selected command. The right panel displays a preview or additional options for a command.
Insert Screenshots • To Insert a Screenshot: Click the Insert tab on the Ribbon and click the Screenshot button in the Illustrations group (Word/Excel/Outlook) or the Images group (PowerPoint), then click an available window. • To Insert a Screen Clipping: Click the Insert tab on the Ribbon and click the Screenshot button in the Illustrations group (Word/Excel/Outlook) or the Images group (PowerPoint), then click Screen Clipping. Click and drag your mouse across the area of the program window that you want to clip.
Picture Tools • To Remove Backgrounds: Click the Format tab on the Ribbon and click the Remove Background button in the Adjust group. Refine the image and click Keep Changes. • To Correct Brightness and Contrast or to Sharpen or Soften a Picture: Click the Format tab on the Ribbon, click the Corrections button in the Adjust group, and select an option from the gallery. • To Change the Color of a Picture: Click the Format tab on the Ribbon, click the Color button in the Adjust group, and select an option from the gallery. • To Apply an Artistic Effect: Click the Format tab on the Ribbon, click the Artistic Effects button in the Adjust group, and select an option from the gallery.
paste with live preview Live Preview now lets you preview and choose from different formatting options that you can apply to the content when it is pasted. • To Paste with Live Preview: Cut or copy content. Click the Paste button list arrow. Or, press + and click the Paste Options button. Point to a paste option to preview it.
Word Art WordArt has received a huge facelift in Office 2010. New WordArt styles and functionality make it easy to add and format WordArt. It is also treated as text instead of a picture, so the text is now searchable in the document. • To Add WordArt: Click the Insert tab on the Ribbon and click the WordArt button in the Text group. Select a WordArt style and type the text in the text box. • To Move WordArt: Click the WordArt object, drag it to the desired location, and release the mouse button. • To Format WordArt: Click the WordArt object, then click the Format tab on the Ribbon under drawing tools. Select a formatting option in the WordArt Styles group or select a new Word Art style from the gallery.
File management Tools Office 2010 offers new and improved tools to help you manage, protect, and share your content. Autosaved Versions: This feature improves on the AutoRecover feature from earlier versions of Office. The AutoRecover feature automatically saves versions of your files at regular intervals. Now, you can access those versions whenever you want. This makes it easy to revert to an earlier version of the file or to recover changes when you forget to save manually. • To Recover Autosaved Versions: Click the File tab on the Ribbon and select Info. Select an autosaved version from the Versions list. Or, click the Manage Versions button and select Recover Draft Versions. Protected view: Protected view protects you from cyber-attacks by Office Quick Reference ©2010 CustomGuide
opening the file as read-only. When a file appears to be from a risky location, such as the Internet, it is opened in Protected view. If you trust the file, you can enable editing and work with the file as usual. Trusted documents: Trusted documents now remembers the trust decisions you make in a document so you don’t have to be asked if a document with active content (e.g. Macros, ActiveX controls, etc.) is safe every time you open it. Accessibility Checker: Helps you identify problems in your files that might keep someone with a disability from accessing your content. • To Use the Accessibility Checker: Click the File tab on the Ribbon and select Info. Click the Check for Issues button and select Check Accessibility.
Microsoft®
Word 2010
Customizable Training Materials
Quick Reference Card
Tel. (888) 903-2432 | www.customguide.com
The Word 2010 Screen
Keyboard Shortcuts
Quick Access Toolbar
General
Minimize Ribbon
Title bar
Close button
File tab
Ribbon Ruler
Open a Document
+
Create New
+
Save a Document
+
Print a Document
+
Close a Document
+
Help
Navigation:
Insertion point
Up One Screen
Down One Screen Vertical scroll bar
Document window
Horizontal scroll bar
Beginning of Line
End of Line
Beginning of
+
Document
View buttons
Status bar
Zoom slider
Open the Go To
Editing
The File tab menu and Backstage view contain commands for working with a program’s files, such as Open, Save, Close, New, and Print.
• To Create a New Document: Click the
File tab, click the New tab, and click the Create button. Or, press + .
• To Move Text with the Mouse: Select
the text you want to move, drag the text to a new location, and release the mouse button.
• To Replace Text: Click the Replace
button in the Editing group on the Home tab. Or, press + .
and click the Open button, or press + .
• To Save a Document: Click the
Save button on the Quick Access Toolbar, or press + .
• To Save a Document with a Different
Name: Click the File tab, click the Save As button, and enter a new name for the document. To Preview a Document: Click the File tab and click the Print tab, or press + . To Print a Document: Click the File tab and click the Print tab, or press + . To View Advanced Printing Options: Click the File tab and click the Print tab. Select from the options under Settings. Undo button on the Quick Access Toolbar, or press + .
Cut
+
Copy
+
Paste
+
Undo
+
Redo or Repeat
+
Formatting
• To Open a Document: Click the File tab • To Close a Document: Click the
Close button, or press + .
• To Correct a Spelling Error: Right-click
the error and select a correction from the contextual menu. Or, press to run the Spell Checker.
• To Use the Thesaurus: Right-click the word you want to look up and select Synonyms from the contextual menu. Select a word or select Thesaurus to search the Thesaurus.
Bold
+
Italics
+
Underline
+
Align Left
+
Center
+
Align Right
+
Justify
+
Text Selection
• To Minimize the Ribbon: Click the
Minimize Ribbon button on the Ribbon. Or, press + . Or, double-click a tab. Or, right-click a tab and select Minimize the Ribbon from the contextual menu.
To Select: A Word
Do This: Double-click the word
A Sentence
Press and hold and click anywhere in the sentence
• To Change Program Settings: Click the
A Line
Click in the selection bar next to the line
• To Get Help: Press to open the
A Paragraph
Triple-click the paragraph
Everything
+
File tab and click the Options button.
Help window. Type your question and press .
Customizable Computer Training 9 Courseware
+
dialog box
The Fundamentals
• To Undo: Click the
End of Document
9 Online Learning 9 Skills Assessments
Word Quick Reference © 2011 CustomGuide
www.customguide.com | Phone 888.903.2432
Navigation
Editing
To Open the Navigation Pane: Click the Find button in the Editing group on the Home tab. Or, press + . To Search for a Word or Phrase: Click the Search box, type the word or phrase, and press . To Search for Graphics, Tables, Equations, or Comments: Click the Magnifying Glass and select an option from the list. Click the Search box, enter the information you are searching for, and press . To View Search Results: Click the Browse the results from your current search tab of the Navigation Pane. To View a Document’s Headings: Click the your document tab. To View a Document’s Pages: Click the document tab.
Browse the headings in Browse the pages in your
• To Cut or Copy Text: Select the text you want to cut or copy and click the Cut or
Copy button in the Clipboard group on the Home tab.
• To Paste Text: Place the insertion point where you want to paste and click the Paste button in the Clipboard group on the Home tab.
To Preview an Item Before Pasting: Place the insertion point where you want to paste, click the Paste button list arrow in the Clipboard group on the Home tab, and select a preview option to view the item.
• To Insert a Comment: Select the text where you want to insert a comment
and click the Review tab on the Ribbon. Click the New Comment button in the Comments group. Type a comment, then click outside the comment text box.
• To Delete a Comment: Select the comment, click the Review tab on the Ribbon, and click the Delete Comment button in the Comments group.
Drawing and Graphics
Styles • To Apply a Style: Select the text to which you want to apply the style and
select the style you want to use from the Styles Gallery in the Styles group on the Home tab.
• To Apply a Document Theme: Click the Themes button in the Themes group on the Page Layout tab of the Ribbon and select a theme.
• To View All Available Styles: Click the Dialog Box Launcher in the Styles group on the Home tab.
• To Change a Style Set: Click the Change Styles button in the Styles group on the Home tab and select Style Set from the menu. Select the Style Set you wish to use.
• To Create a Style: Select the text that contains the formatting of the new
style, right-click the text, and select Styles from the contextual menu. Select Save Selection as a New Quick Style from the contextual menu, enter a name for the style, and click OK.
• To Check Your Styles: Select the text you wish to check. Click the Dialog
Box Launcher in the Styles group on the Home tab of the Ribbon. Click the Style Inspector button in the Styles task pane.
• To Insert a Clip Art Graphic: Click the Insert tab on the Ribbon and click the Clip Art button in the Illustrations group. Type the name of what you’re looking for in the “Search for” box and press .
• To Insert a Picture: Click the Insert tab on the Ribbon and click the Picture
button in the Illustrations group. Find and select the picture you want to insert and click Insert. To Insert a Screenshot: Click the Insert tab on the Ribbon and click the Screenshot button in the Illustrations group. Select an available window from the list, or select the Screen Clipping option to take a screen clip.
• To Draw a Shape: Click the Insert tab on the Ribbon, click the Shapes
button in the Shapes group, and select the shape you want to insert. Then, click where you want to draw the shape and drag until the shape reaches the desired size. Hold down the key while you drag to draw a perfectly proportioned shape or straight line. To Insert WordArt: Click the Insert tab on the Ribbon, click the WordArt button in the Text group, and select a design from the WordArt Gallery. Click the text box and enter your text. If necessary, click the text box and drag it to the desired position.
• To Insert SmartArt: Click the Insert tab on the Ribbon, click the SmartArt button in the Illustrations group, select a layout, and click OK.
Formatting • To Format Text: Use the commands in the Font group on the Home tab, or
click the Dialog Box Launcher in the Font group to open the Font dialog box.
• To Copy Formatting with the Format Painter: Select the text with the Format Painter button in the formatting you want to copy and click the Clipboard group on the Home tab. Then, select the text you want to apply the copied formatting to.
• To Indent a Paragraph: Click the
Increase Indent button in the
Paragraph group on the Home tab.
• To Decrease an Indent: Click the
Decrease Indent button in the
Paragraph group on the Home tab.
• To Create a Bulleted or Numbered List: Select the paragraphs you want to Bullets or bullet or number and click the Paragraph group on the Home tab.
Numbering button in the
• To Change Page Orientation: Click the Page Layout tab on the Ribbon,
click the Orientation button in the Page Setup group, and select an option from the list.
• To Insert a Header or Footer: Click the Insert tab on the Ribbon and click the Header or Footer button in the Header & Footer group.
• To Insert a Manual Page Break: Click the Insert tab on the Ribbon and click the Page Break button in the Pages group.
• To Adjust Text Wrapping: Double-click the object, click the Wrap Text
button in the Arrange group on the Format tab, and select an option from the list.
• To Resize an Object: Click the object to select it, click and drag one of its
sizing handles ( ), and release the mouse button when the object reaches the desired size. Hold down the key while dragging to maintain the object’s proportions while resizing it.
• To Format an Object: Double-click the object and use the commands located on the Format tab.
• To Delete an Object: Select the object and press the key
Tables • To Insert a Table: Click the Insert tab on the Ribbon, click the Table button in the Tables group, and select Insert Table from the menu.
• To Insert a Column or Row: Click the Layout tab under Table Tools on the Ribbon and use the commands located in the Rows & Columns group.
• To Delete a Column or Row: Select the column or row you want to delete,
click the Layout tab under Table Tools on the Ribbon, click the Delete button in the Rows & Columns group, and select an appropriate option from the menu.
• To Adjust Column Width or Row Height: Select the column or row you want to adjust, click the Layout tab under Table Tools on the Ribbon, and use the commands located in the Cell Size group.
Customizable Computer Training 9 Courseware
9 Online Learning 9 Skills Assessments
Word Quick Reference © 2011 CustomGuide www.customguide.com | Phone 888.903.2432
Microsoft®
PowerPoint 2010
Customizable Training Materials
Quick Reference Card
Tel. (888) 903-2432 | www.customguide.com
PowerPoint 2010 Screen
Keyboard Shortcuts General
Close button
Title bar
Quick Access Toolbar
Ribbon Slides tab
Outline tab
Slide pane
Notes pane
Status bar
View buttons Zoom slider
The Fundamentals The File tab menu and Backstage view contain commands for working with a program’s files, including New, Open, Save, Print and Close.
• • •
• • • •
Click the File tab, click New, and click Create. Or, press + . To Open a Presentation: Click the File tab and click Open, or press + . To Save a Presentation: Click the Save button on the Quick Access Toolbar, or press + . To Save a Presentation with a Different Name: Click the File tab, click Save As, enter a new name for the presentation, and click Save. To Preview and Print a Presentation: Click the File tab and click Print, or press + . To Close a Presentation: Click the File tab and click Close, or press + . To Get Help: Press to open the Help window. Type your question and press . To Exit PowerPoint: Click the File tab and click Exit.
Create New
+
Save a Presentation
+
Print a Presentation
+
Close a Presentation
+
Insert a New Slide
+
Help
Editing Cut
+
Copy
+
Paste
+
Undo
+
Redo or Repeat
+
Find
+
Replace
+
Select All
+
Navigation—Go To:
• To Insert a New Slide: Click the Home tab
The Next Slide
• •
•
•
•
and click New Slide in the Slides group, or press + . To Change the Slide Layout: Click the Home tab, click the Layout button in the Slides group, and select a layout. To Return a Slide to its Default Settings: Click the Home tab and click the Reset button in the Slides group. To Apply a Document Theme: Click the Design tab on the Ribbon, click the More button in the Themes group, and select a theme from the gallery. To Change the Slide Background: Click the Design tab on the Ribbon, click the Background Styles button in the Background group, and select a background. To View the Slide Master: Click the View tab on the Ribbon, click the Slide Master button in the Master Views group, and click the Slide Master or the appropriate Layout Master in the Outline pane. To Insert a Header or Footer: Click the Insert tab on the Ribbon and click the Header & Footer button in the Text group. Select the option(s) that you want and click Apply or Apply to All. To Add a Section: Click the Home tab on the Ribbon, click the Section button in the Slides group, and click Add Section.
Customizable Computer Training 9 Courseware
+
Slides
• • To Create a New Presentation:
Open a Presentation
9 Online Learning 9 Skills Assessments
The Previous Slide
Slide Show Delivery Begin Slide Show
Resume Slide Show
+
End Slide Show
Jump to Slide
+
Toggle Screen Black
Toggle Screen White
Pause Show
Show/Hide Pointer
Change Arrow to Pen + Change Pen to Arrow + Erase Doodles
Formatting Bold
+
Italics
+
Align Left
+
Center
+
Justify
+
PowerPoint Quick Reference © 2011 CustomGuide www.customguide.com | Phone 888.903.2432
xX Formatting
Images, Multimedia, and Objects
• To Cut or Copy Text: Select the text you want to cut or copy and click the
• To Insert a Picture: Click the Insert tab on the Ribbon and click the Picture
Cut or Copy button in the Clipboard group on the Home tab. • To Paste Text: Place the insertion point where you want to paste and click Paste button in the Clipboard group on the Home tab. the • To Format Selected Text: Use the commands in the Font group on the Home tab, or click the Dialog Box Launcher in the Font group to open the Font dialog box. • To Copy Formatting with the Format Painter: Select the text with the Format Painter button in the formatting you want to copy and click the Clipboard group on the Home tab. Then, select the text you want to apply the copied formatting to. • To Change Paragraph Alignment: Select the paragraph(s) and click the Center, Align Right, appropriate alignment button ( Align Left, or Justify) in the Paragraph group on the Home tab. • To Create a Bulleted or Numbered List: Select the paragraphs you want to
• •
• •
Bullets or Numbering button in the bullet or number and click the Paragraph group on the Home tab. • To Change Paragraph Line Spacing: Select the paragraph(s), click the Line Spacing button in the Paragraph group on the Home tab, and select an option from the list. • To Correct a Spelling Error: Right-click the error and select a correction from the contextual menu. Or, press to run the Spell Checker.
•
The Outline Pane
•
•
• The Outline tab focuses on the content of the presentation. Use this tab when you • want to adjust the textual structure Transitions and Animation Effects or add large • To Add a Slide Transition: Navigate to the slide you want to add a transition amounts of text. to. Click the Transitions tab on the Ribbon, click the More button in the Transition to This Slide group, and select a transition effect. • To Add an Animation Effect to an Object: Select the object that you want to animate, click the Animations tab on the Ribbon. Click the More button in the Animation group, and select an animation effect. To Copy Animation Effects from One Object to Another: Select the object with the animation effect you want to copy, click the Animations tab on the Normal view: This is the default view in Ribbon, and click the Animation Painter button in the Advanced Animation PowerPoint 2010. Normal view includes the group. Then, click the object you want to apply the copied animation effect to. Outline pane, Slide pane, and Notes pane.
The Slides tab contains a thumbnail image of every slide in the presentation; click a thumbnail to jump to that slide. You can also rearrange, add, or delete slides here.
Views
button in the Illustrations group. Find the picture you want to insert and click Insert. To Insert a Clip Art Graphic: Click the Insert tab on the Ribbon and click the Clip Art button in the Images group. Type the name of what you’re looking for in the “Search for” box and click Go. To Insert a Video file: Click the Insert tab on the Ribbon and click the Video button in the Media group. Find the video you want to insert and click Insert. To Insert a Video from the Web: Click the Insert tab on the Ribbon, click the Video button list arrow in the Media group, and select Video from Web Site. Paste the video’s Embed code into the Insert Video from Web Site dialog box and click Insert. To Insert an Audio clip: Click the Insert tab on the Ribbon, click the Audio button list arrow in the Media group, and select Audio from File. Find the audio clip that you want to insert and click Insert. To Draw a Shape: Click the Insert tab on the Ribbon, click the Shapes button in the Shapes group, and select the shape you want to insert. Then, click where you want to draw the shape and drag until the shape reaches the desired size. Hold down the key while you drag to draw a perfectly proportioned shape or straight line. To Insert SmartArt: Click the Insert tab on the Ribbon and click the SmartArt button in the Illustrations group. Select the SmartArt you want to insert and click OK. To Format an Object: Double-click the object and use the commands located on the Format tab. To Move an Object: Click the object and drag it to a new location. Release the mouse button when you’re finished. To Resize an Object: Click the object to select it, click and drag one of its sizing handles ( ), and release the mouse button when the object reaches the desired size. Hold down the key while dragging to maintain the object’s proportions while resizing it. To Delete an Object: Select the object and press the key.
Slide Sorter view: Displays all the slides in the presentation as thumbnails (tiny images). Use Slide Sorter view when you want to rearrange the order of slides or add transition effects between slides.
Slide Show Delivery • To Present a Slide Show: Click the Slide Show button on the status bar, or
• Reading View: Similar to Slide Show view, it displays the presentation in a window with simple controls, making it easy to review.
Slide Show view: Displays the presentation as an electronic slide show. Whenever you deliver a presentation in front of an audience, Slide Show view is definitely the view you want to use.
• • •
•
press . To Use the Laser Pointer: In Slide Show view, press and hold down the key while clicking and holding the left mouse button. To Use the Pen: In Slide Show view, press + and then draw on the screen. Press + to switch back to the arrow pointer. Press to erase your doodles. To Advance to the Next Slide: Press . Or, click the left mouse button. To Go Back to the Previous Slide: Press or . To Add Slide Timings: Click the Slide Show tab on the Ribbon and click the Rehearse Timings button in the Set Up group. Navigate through the presentation, pausing on each slide for the amount of time you wish to display it during your show. Click Yes to save your timings. To End a Slide Show: Press .
Customizable Computer Training 9 Courseware
9 Online Learning 9 Skills Assessments
PowerPoint Quick Reference © 2011 CustomGuide www.customguide.com | Phone 888.903.2432
Micrrosoft®
E Exce el 2010 2 0
Custom mizable Trainin ng Materials
Qu uick Reference e Card
Tel. (888) 9 903-2432 | www.ccustomguide.com m
The e Excel 20 010 Scree en
Keybo oard Shorrtcuts
Quic ck Access Toolba ar
e bar Title
Formula Bar
C Close button
File ta ab on Ribbo Name e box Collumns
Active cell
Ro ows
View buttons b
Move Betw ween Cells
Zoom sslider
The e Fundam mentals Thee File tab menu annd Backstage view w contain commands for w working with a proogram’s files, suchh as Open, Save, Closse, New, and Print. • To Create a Neew Workbook: Click the File tab andd select New, and click Create, or press + . • To Open a Workbook: Click the File O or press tab and select Open, + . • To Save a Worrkbook: Click the Save button on the Quick Accesss Toolbar, or presss + . To Preview and Print a Workbo ook: Click the File taab and select Print, or press + . • To Undo: Clickk the Undo button on the Quick Acccess Toolbar, or press + . • To Redo or Reepeat: Click the Redo button onn the Quick Accesss Toolbar, or presss + . The T last command iss repeated if Undoo was not previouusly used. • To Close a Wo orkbook: Click thee Close button, or o press + . < • To Get Help: Press P to openn the Help window. Type T your questionn and press .
• Cell addresses: Cells aare referenced by
addressses made from thheir column letter and roow number, such aas cell A1, A2, B1, B2, etc. You can find thee address of a celll by looking at the Name Box.
• To Seelect a Cell: Click a cell or use the keyboard arrow keys to select it.
• To Seelect a Cell Rangee: Click and drag tto select a range of cells. O Or, press and holdd down the key w while using the to movve the mouse pointeer to the last cell off the range.
• To Seelect an Entire Woorksheet: Click thhe Selectt All button wheree column and row headinngs meet. Or, presss + .
To Min nimize the Ribboon: Click the Minim mize Ribbon buttoon on the Ribbon. Or, preess + >. Or, right-click a tab annd select Minimizee Ribbon from thee contexxtual menu. • To Ch hange Program S Settings: Click thee File taab and select Optiions. • To Usse Zoom: Click annd drag the zoom slider to the left or right.. Or, click the m Out and Zoom Inn buttons on Zoom the slider. • To Ch hange Views: Clicck a View button inn the staatus bar. Or, click the View tab and select a view.
Custom mizable Compute er Training 9 Courrseware
Open a W Workbook < + Create Ne ew < + Save < + Preview and Print < + Close a W Workbook < + Help < Run Spelliing Check < Calculate worksheets < Create an absolute, < normal, orr mixed referen nce
Navigattion:
Scroll bars
Wo orksheet tabs
Genera al
9 On nline Learning 9 Skills Assessm ments
Right One e Cell Left One C Cell Down One e Cell Up One C Cell Down One e Screen Up One Screen To Cell A1 1 To Last Ce ell Go To Dia alog Box
< , , < , < < + < < + < < < + < + > <
Editing Cut Copy Paste Undo Redo Find Replace Select All Edit active e cell Clear cell contents
< + < + < + < + < + < + < + < + < <
Formattting Bold
+
Italics
+
Underline
+
Open Form mat Cells Dialog Boxx
+ +<
Select All
+
Select enttire row
+
Select enttire column + > Hide seleccted rows
+
Hide seleccted columns
+
Excel Quickk Reference © 20011 CustomGuid de www.customgguide.com | Pho one 888.903.243 32
Editing
Form matting
• To E Edit a Cell’s Contents: Select the cell and click the Formula F Bar, or double-click the cell. Edit E the cell contents and press .
• To Forrmat Text: Use thee commands in thhe Font group on the Home tab, or click th e Dialog Box Lauuncher in the Fonnt group to open thhe Format Cells dialog bbox.
Clear a Cell’s Contents: Select thee cell(s) and presss the keyy. • To C • To C Cut or Copy Dataa: Select cell(s) annd click the in thhe Clipboard groupp on the Home tabb.
Cu ut or
Copy buttton
• To P Paste Data: Placee the insertion poinnt where you want to paste and click the Paste button in thhe Clipboard groupp on the Home tabb. To P Preview an Item Before B Pasting: Place P the insertionn point where you want to paste, click the Paste button list arrow in the Clippboard group on thhe Hom me tab, and select a preview option to view the item. • To P Paste Special: Seelect the destinatioon cell(s), click thee Paste button listt arroow in the Clipboardd group on the Hoome tab, and selecct Paste Special. Seleect an option and click OK. • To C Copy Using Auto o Fill: Point to the fill handle at the bottom-right b corner of the selected cell(s), thhen drag to the deestination cell(s). • To C Complete a Seriees Using AutoFill: Select the cells that t define the serries. Clicck and drag the fill handle to complete the series. • To M Move or Copy Ceells Using Drag and a Drop: Select the t cell(s) you wannt to movve or copy, positioon the pointer overr any border of thee selected cell(s), then t dragg to the destination cells. To copy, hold h down key while draggingg. • To IInsert a Column or o Row: Right-clicck to the right of thhe column, or beloow the row you want to innsert. Select Inserrt from the contextual menu, or clickk the Inseert button in the Cells C group on the Home tab. • To D Delete a Column or Row: Select thhe row or column heading(s). Right-clickk and select Delette from the contexxtual menu, or clickk the Delete buttoon in the Cells group on thee Home tab. • To IInsert a Commen nt: Select the cell where w you want too insert a commennt and click the Review tab on the Ribbonn. Click the New Comment C button in the Comments group. Type a commentt and click outsidee the comment boxx.
• To Coppy Formatting with the Format Paainter: Select the cell(s) with the Format Paintter button in the formattting you want to coopy and click the Clipboaard group on the H Home tab. Then, sselect the cell(s) you want to apply the coppied formatting to. • To Appply a Cell Style: S Select the cell(s) yyou want to apply a cell style to. Click thhe Cell Styles buttton in the Styles ggroup of the Homee tab on the Ribbonn and select a stylee from the gallery.. • To Forrmat a Cell Rangee as a Table: Seleect the cells you w want to apply table e formattting to. Click the FFormat as Table bbutton in the Styless group of the Home ttab on the Ribbonn and select a tablee format from the gallery. • To Appply a Document TTheme: Click the Page Layout tab on the Ribbon, click th e Themes button in the Themes grroup, and select a theme from the gallery.. To Appply Conditional Formatting: Select the cells to whichh you want to apply coonditional formattiing. Click the Connditional Formattiing button in the Styles ggroup of the Homee tab. Select the foormatting schemee you wish to use, then seet the conditions inn the dialog box. • To Adj ust Column Widtth or Row Heightt: Drag the right boorder of the columnn header, or the boottom border of the row header. Douuble-click the border to AutoFit the coluumn or row accordding to its contentts.
Work kbook Ma anagement • To Inseert a New Worksheet: Click the Inssert Worksheet taab next to the
sheet taabs at the bottom of the program sccreen. Or, press Recurring Appointment.
Quick Click icon on
• To Recall a Message: Open the Sent Items folder. Double-click the message, click the Actions button in the Move group of the Message tab on the Ribbon, and select Recall This Message. Choose to delete the message or replace the message with a new one in the dialog box and click OK. You can only recall a message if you are using MS Exchange Server and the recipient has not opened it. • To Resend a Message: Open the Sent Items folder. Double-click the message, click the Actions button in the Move group of the Message tab on the Ribbon, and select Resend This Message. Edit the message and recipients as necessary and click Send. • To Create a Signature: In the message window, click the Signature button in the Include group of the Message tab on the Ribbon, select Signatures, and create the new signature. • To Change a Message’s Options: In the message window, click the Options tab on the Ribbon and click the More Options dialog box Launcher. Here you can specify: if the message is important or sensitive; importance or sensitivity of the message; if you want to add voting buttons to the message; where replies should be sent to; if you want a read receipt; and if you want to encrypt the message or delay its delivery. • To Move a Message to a Different Folder: Select the item, click the Move button in the Move group of the Home tab of the Ribbon, and select the destination folder. Or, click and drag the item to a different folder in the Navigation Pane. • To Turn On the Out of Office Assistant: Click the File tab, select Info, and click the Automatic Replies button. • To Save a Message as a Draft: Click the Save button on the Quick Access Toolbar in the message window. • To Create a New Rule: Click the Rules button in the Move group of the Home tab on the Ribbon and select Create Rule. • To Manage Rules: Click the Rules button in the Move group of the Home tab on the Ribbon and select Manage Rules and Alerts.
tasks and to-do items • To Open Tasks/To-Do List: Click the Tasks button in the Navigation Pane and select To-Do List or Tasks in the Navigation Pane. • To Create a New Task/To-Do Item: Click the New Task button in the New group on the Home tab. • To Complete a Task: Click the Mark Complete button in the Manage Task group on the Ribbon, or click the task’s check box in Simple List view. • To Delete a Task: Select the task and press the key. Or, click the Delete button in the Delete group of the Home tab. Office Quick Reference ©2010 CustomGuide
• To Schedule a Meeting: Click the New Meeting button in the New group on the Ribbon. Add recipients and meeting details and click Send. • To Schedule an All Day Event: Click the New Items button in the New group on the Ribbon and select All Day Event. • To Reschedule an Item: Click and drag the item to a new date and/ or time on the Calendar. • To Edit an Item: Click the item to view the Calendar Tools contextual tab. Or, double-click the item, make your changes, and click the Save & Close button in the Actions group on the Ribbon. • To Delete an Item: Select the item and press . • To Search the Calendar: Click in the Search box in the upper right corner. Type search keywords and press .
contacts • To Open Contacts: Click the Contacts button in the Navigation Pane. • To Change Views: Click a view option in the Arrange group on the Home tab, or click the View tab and select an option there. • To Create a New Contact: Click the New Contact button in the New group on the Home tab. • To Create a New Contact Group: Click the New Contact Group button in the New group of the Home tab on the Ribbon. Click the Add Members button in the Members group on the Ribbon, select a name in the list, click the Members button, and repeat for each name to be added. Click OK, then click Save & Close in the Actions group of the Contact Group tab. • To Edit a Contact: Double-click the contact and make your changes. • To Find a Contact: Type your search text in the Search Contacts field. Or, click the Find a Contact field in the Find group on the Home tab, enter your search text and press .
Micrrosoft®
O Outlo ook Web W b App p 20 010
Custom mizable Trainin ng Materials
Qu uick Reference e Card
Tel. (888) 9 903-2432 | www.ccustomguide.com m
The e Outlook k Web Ap pp 2010 Screen S
Naviga ation Pan ne
Instant Search
Toolbar
Che eck Mes ssages
Notific cation Alert
Sign Outt
Contains maail-related folders llike your Inbox, Sent Items, and Search Foldeers. Use the Favorites seection at the top off the pane for easyy access to freequently-used foldders. Options button Naviga ation Pane
Readin ng Pane
Enables youu to view and scheedule appointmentts, event, and meeetings. View shared calenndars and comparre calendars by viewing them m side-by-side.
Store and keeep track of addreesses, phone numbers, annd e-mail addressees.
zas Inbox x
Organize to--do lists, track taskk progress, and delegate tassks.
Pro ogram Ba asics
Mail: Basics
• To LLog In to Outlookk Web App: Openn the URL for yourr orgaanization’s Web App. A Choose the seecurity option you wish to uuse while accessinng your Outlook acccount. If necessary, clickk the Use the ligh ht version of Outllook Web App chheck boxx. Enter your e-mail address and passsword in the apppropriate fields andd click Sign In.
• To Create C a New Messsage:
• Messsage Indicators:: Message has not been read. Message has beeen read. File is attached to the t message. Message has higgh or low importance. • To M Move the Reading g Pane: Click the View button on thhe toolbar. Select a position (Right, Bottom m, Off) for the Reaading Panne from the menu. • To R Reset Your Password: Click the Options O button andd seleect the Change Yo our Password linkk. Complete the fieelds as ddirected and click Save. • To C Change Program m Settings: Click the Options buttonn and chooose the settings you wish to changee. • To P Print a Message: Double-click the message to open it in its ownn window. Click thee Printable View button on the toolbar. Chooose the print settings in the Print dialog box and clickk Prinnt. • To G Get Help: Click thhe Help button andd select Help. Typpe your queestion in the Searcch box and press . < Or browsse the helpp topics to find thee topic you want.
Too Access Message Actions: Foor an easy way to vieew all the coommands you can n appply to a message e, click the Actions buutton in the Reeading Pane.
1. Click the New buttoon on the Inbox tooolbar. Or, press
Insert Time +
+
Insert Value from Same Field in Previous Record
+ < ’ > (Apostrophe)
Check Spelling
Switch Applications
+
Editing Cut
+
Copy
+
Paste
+
Find
+
Replace
+
Select All
+
Design View Properties
+
Open object in Design View
+
Save Object
+
Formatting Text Bold
100
Displays records whose field value is greater than 100.
• To Remove a Filter: Click the Toggle Filter button in the Sort & Filter group. • To Change a Field’s Data Type: Select the field you want to change, click the Fields tab on the Ribbon under Table Tools, and click the Data Type list arrow in the Data Type & Formatting group. Select a data type.
• To Create a Report: Click the Create tab on the Ribbon and click the Report Wizard button in the Reports group. Follow the instructions to select the fields you want to use from the desired tables and create the report.
Customizable Computer Training 9 Courseware
9 Online Learning 9 Skills Assessments
Access Quick Reference © 2011 CustomGuide www.customguide.com | Phone 888.903.2432
