office 2010 windows
DESCRIPTION
Winddows XP and MS Office 2010 for CAOT 85 - Microcomputer Office Applications - ExcelTRANSCRIPT
![Page 1: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/1.jpg)
MicrosoftExcel 2010
Office 2010 and Windows 7: Essential Concepts and Skills
(Customized Excel 2010)
![Page 2: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/2.jpg)
2
• Start Windows and log on to the computer• Discuss basic mouse operations• Identify the objects on the Windows desktop• Start a program• Identify components of a Microsoft Office Ribbon• File Management– Create folders– Save files
Objectives
Office 2010 and Windows : Essential Concepts and Skills
![Page 3: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/3.jpg)
3
• Change screen resolution• Perform basic tasks in Microsoft Office Excel• Use Microsoft Office Help and Windows Help• Entering text into a Worksheet cell
Office 2010 and Windows : Essential Concepts and Skills
Objectives
![Page 4: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/4.jpg)
4
• Windows is the most popular and widely used operating system
• An operating system is a computer program (set of computer instructions) that coordinates all the activities of computer hardware such as memory, storage devices, and printers, and provides the capability for you to communicate with the computer
• Windows is used to run application software
Office 2010 and Windows : Essential Concepts and Skills
Introduction to the Windows 7 Operating System
![Page 5: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/5.jpg)
5Office 2010 and Windows : Essential Concepts and Skills
Using a Mouse
![Page 6: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/6.jpg)
6
• A scroll bar is a horizontal or vertical bar that appears when the contents of an area may not be visible completely on the screen
Office 2010 and Windows : Essential Concepts and Skills
Scrolling
![Page 7: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/7.jpg)
7
• Click the user icon on the Welcome screen to either display a password text box or the Windows 7 desktop
• If Windows 7 displays a password text box, type your password in the text box and then click the arrow button to log on to the computer and display the Windows 7 desktop
Office 2010 and Windows : Essential Concepts and Skills
Logging On to the Computer
![Page 8: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/8.jpg)
8Office 2010 and Windows : Essential Concepts and Skills
Logging On to the Computer
![Page 9: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/9.jpg)
9
• Microsoft Office 2010 is the version of Microsoft Office that we will using, offering features that provide users with better functionality and easier ways to work. The MS Office suite consists of:– Microsoft Word 2010– Microsoft PowerPoint 2010– Microsoft Excel 2010– Microsoft Access 2010
Office 2010 and Windows : Essential Concepts and Skills
Introduction to Microsoft Office 2010
![Page 10: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/10.jpg)
10
• Excel is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional-looking reports, publish organized data to the Web, and access real-time data from Web sites
• Four major parts:– Workbooks and worksheets– Charts– Tables– Web support
Office 2010 and Windows : Essential Concepts and Skills
Excel
![Page 11: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/11.jpg)
11
• Click the Start button on the Windows 7 taskbar to display the Start menu
• Click All Programs at the bottom of the left pane on the Start menu to display the All Programs list
• If the program you wish to start is located in a folder, click or scroll to and then click the folder in the All Programs list to display a list of the folder’s contents
• Click, or scroll to and then click, the program name in the list to start the selected program
Office 2010 and Windows: Essential Concepts and Skills
Starting a Program Using the Start Menu
![Page 12: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/12.jpg)
12Office 2010 and Windows : Essential Concepts and Skills
Starting a Program Using the Start Menu
All Programs Command
![Page 13: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/13.jpg)
13Office 2010 and Windows : Essential Concepts and Skills
Starting a Program Using the Start Menu
Microsoft Office Folder
![Page 14: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/14.jpg)
14Office 2010 and Windows : Essential Concepts and Skills
Starting a Program Using the Start Menu
Microsoft Office Excel Command
![Page 15: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/15.jpg)
15
• Click the Maximize button next to the Close button on the window’s title bar to maximize the window
Office 2010 and Windows: Essential Concepts and Skills
Maximizing a Window
![Page 16: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/16.jpg)
16Office 2010 and Windows: Essential Concepts and Skills
The Excel Worksheet Window, Ribbon, and Elements Common to Office Programs
![Page 17: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/17.jpg)
17
• Click the tab on the Ribbon to display
Office 2010 and Windows : Essential Concepts and Skills
Displaying a Different Tab on the Ribbon
![Page 18: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/18.jpg)
18Office 2010 and Windows : Essential Concepts and Skills
Minimizing, Displaying, and Restoring the Ribbon
![Page 19: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/19.jpg)
19Office 2010 and Windows : Essential Concepts and Skills
Displaying and Using a Shortcut Menu
![Page 20: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/20.jpg)
20Office 2010 and Windows : Essential Concepts and Skills
Customizing the Quick Access Toolbar
![Page 21: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/21.jpg)
21
• Connect the USB flash drive to an available USB port on the computer to open the AutoPlay window
• Click the ‘Open folder to view files’ link in the AutoPlay window to open the USB flash drive window
• Click the New folder button on the toolbar to display a new folder icon with the name, New folder, selected in a text box
• Type the desired folder name, and then press the ENTER key
Office 2010 and Windows : Essential Concepts and Skills
Creating a Folder
![Page 22: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/22.jpg)
Office 2010 and Windows 7: Essential Concepts and Skills 22
Creating a Folder
![Page 23: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/23.jpg)
Office 2010 and Windows 7: Essential Concepts and Skills 23
• Double-click the desired folder to display its contents and display a black arrow to the left of the folder icon
• Double-click the folder identifying your class to collapse the folder
Expanding a Folder, Scrolling through Folder Contents, and Collapsing a Folder
![Page 24: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/24.jpg)
Office 2010 and Windows 7: Essential Concepts and Skills 24
Expanding a Folder, Scrolling through Folder Contents, and Collapsing a Folder
![Page 25: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/25.jpg)
Office 2010 and Windows 7: Essential Concepts and Skills 25
• Point to the program button on the taskbar to see a live preview of the window
• Click the program button or the live preview to make the program associated with the program button the active window
Switching from One Program to Another
![Page 26: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/26.jpg)
26
• Click the Save button on the Quick Access Toolbar to display the Save As dialog box
• Type the desired file name in the File name text box to change the file name
• Navigate to the desired save location• Click the Save button to save the workbook in the
selected folder on the selected drive with the entered file name
Office 2010 and Windows : Essential Concepts and Skills
Saving a File in a Folder
![Page 27: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/27.jpg)
27Office 2010 and Windows : Essential Concepts and Skills
Saving a File in a Folder
![Page 28: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/28.jpg)
28
• Click the Minimize button on the program’s title bar to minimize the window
• Click the program button on the taskbar to restore the minimized window
Office 2010 and Windows : Essential Concepts and Skills
Minimizing and Restoring a Window
![Page 29: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/29.jpg)
29
• Right-click an empty area on the Windows 7 desktop to display a shortcut menu that displays a list of commands related to the desktop
• Click Screen resolution on the shortcut menu to open the Screen Resolution window
• Click the Resolution button in the Screen Resolution window to display the resolution slider
• If necessary, drag the resolution slider to the desired screen resolution• Click an empty area of the Screen Resolution window to close the
resolution slider• Click the OK button to change the screen resolution• Click the Keep changes button to accept the new resolution
Office 2010 and Windows : Essential Concepts and Skills
Changing the Screen Resolution
![Page 30: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/30.jpg)
30
• Click the Close button on the right side of the program’s title bar to close the document and quit the program
Office 2010 and Windows : Essential Concepts and Skills
Quitting a Program with One File Open
![Page 31: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/31.jpg)
31Office 2010 and Windows : Essential Concepts and Skills
Changing the Screen Resolution
![Page 32: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/32.jpg)
32
• Click File on the Ribbon to open the Backstage view
• Click Open in the Backstage view to display the Open dialog box
• Navigate to the location of the file to be opened• Click the file to be opened to select the file• Click the Open button to open the selected file
and display the opened file in the current program window
Office 2010 and Windows : Essential Concepts and Skills
Opening an Existing Office File from the Backstage View
![Page 33: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/33.jpg)
33Office 2010 and Windows : Essential Concepts and Skills
Opening an Existing Office File from the Backstage View
![Page 34: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/34.jpg)
34
• Click File on the Ribbon to open the Backstage view
• Click the New tab in the Backstage view to display the New gallery
• Click the Create button in the New gallery to create a new workbook
Office 2010 and Windows : Essential Concepts and Skills
Creating a New Workbookfrom the Backstage View
![Page 35: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/35.jpg)
35Office 2010 and Windows : Essential Concepts and Skills
Creating a New Document from the Backstage View
![Page 36: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/36.jpg)
36
• Click File on the Ribbon to open the Backstage view
• Click Close in the Backstage view to close the open file without quitting the active program
Office 2010 and Windows : Essential Concepts and Skills
Closing a File Using the Backstage View
![Page 37: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/37.jpg)
37
• Click File on the Ribbon to open the Backstage view
• Click the Recent tab in the Backstage view to display the Recent gallery
• Click the desired file name in the Recent gallery to open the file
Office 2010 and Windows : Essential Concepts and Skills
Opening a Recent File Using the Backstage View
![Page 38: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/38.jpg)
38Office 2010 and Windows : Essential Concepts and Skills
Opening a Recent File Using the Backstage View
![Page 39: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/39.jpg)
39
• In Windows Explorer, display the folder in which you want to create the new document
• Right-click an open area in the right pane of the folder window to display a shortcut menu
• Point to New on the shortcut menu to display the New submenu
• Click Microsoft Excel Worksheet on the New submenu to display an icon and text box for a new file in the current folder window
• Type the desired file name in the text box, and then press the ENTER key
Office 2010 and Windows : Essential Concepts and Skills
Creating a New Blank Workbookfrom Windows Explorer
![Page 40: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/40.jpg)
40Office 2010 and Windows : Essential Concepts and Skills
Creating a New Blank Document from Windows Explorer
![Page 41: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/41.jpg)
41
• Display the folder window containing the file you wish to open
• Right-click the file icon or file name to display a shortcut menu
• Click Open on the shortcut menu to open the selected file in the program used to create the file
Office 2010 and Windows : Essential Concepts and Skills
Starting a Program from Windows Explorer and Opening a File
![Page 42: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/42.jpg)
42
• Click the Save button on the Quick Access Toolbar to overwrite the previously saved file
Office 2010 and Windows : Essential Concepts and Skills
Saving an Existing Filewith the Same File Name
![Page 43: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/43.jpg)
43
• Navigate to the location of the file to be renamed• Right-click the file to be renamed to display a
shortcut menu that presents a list of commands related to files
• Click Rename on the shortcut menu to place the current file name in a text box
• Type the new file name in the text box and then press the ENTER key
Office 2010 and Windows : Essential Concepts and Skills
Renaming a File
![Page 44: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/44.jpg)
44Office 2010 and Windows : Essential Concepts and Skills
Renaming a File
![Page 45: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/45.jpg)
45
• Navigate to the location of the file to be moved• Display the folder in the navigation pane to which
you want to move the file• Drag the file from the right pane to the desired
folder in the navigation pane
Office 2010 and Windows : Essential Concepts and Skills
Moving a File
![Page 46: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/46.jpg)
46Office 2010 and Windows : Essential Concepts and Skills
Moving a File
![Page 47: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/47.jpg)
47
• Navigate to the location of the file to be deleted• Right-click the file to be deleted to display a
shortcut menu• Click Delete on the shortcut menu to display the
Delete File dialog box• Click the Yes button to delete the selected file
Office 2010 and Windows : Essential Concepts and Skills
Deleting a File
![Page 48: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/48.jpg)
48Office 2010 and Windows : Essential Concepts and Skills
Deleting a File
![Page 49: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/49.jpg)
49
• Click the Microsoft Excel Help button near the upper-right corner of the program window to open the Excel Help window
Office 2010 and Windows : Essential Concepts and Skills
Opening the Help Window in an Office Program
![Page 50: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/50.jpg)
50
• Drag the window title bar to the desired location
Office 2010 and Windows : Essential Concepts and Skills
Moving a Window by Dragging
![Page 51: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/51.jpg)
51
• Point to the lower-right corner of the window until the mouse pointer changes to a two-headed arrow
• Drag the bottom border to display more of the active window
Office 2010 and Windows : Essential Concepts and Skills
Resizing a Window by Dragging
![Page 52: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/52.jpg)
52
• Type the search text in the ‘Type words to search for’ text box at the top of the Excel Help window
• Click the Search button arrow to display the Search menu• Select the desired option on the Search menu, and then
click the Search button arrow again to close the Search menu
• Click the Search button to display the search results• Click the desired link to open the Help document• Click the Home button on the toolbar to clear the search
results and redisplay the Help home pageOffice 2010 and Windows : Essential Concepts and Skills
Obtaining Help Using the ‘Type words to search for’ Text Box
![Page 53: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/53.jpg)
53Office 2010 and Windows : Essential Concepts and Skills
Obtaining Help Using the ‘Type words to search for’ Text Box
![Page 54: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/54.jpg)
54
• Click the desired link on the Help home page to display the associated page
Office 2010 and Windows : Essential Concepts and Skills
Obtaining Help Using the Help Links
![Page 55: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/55.jpg)
55
• With the Help window open, click the Home button on the toolbar to display the Help home page
• Click the Show Table of Contents button on the toolbar to display the Table of Contents pane on the left side of the Help window
• Click the desired link to view a list of Help subtopics• Click the desired subtopic to view the associated
article
Office 2010 and Windows : Essential Concepts and Skills
Obtaining Help Using the Help Table of Contents
![Page 56: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/56.jpg)
56Office 2010 and Windows : Essential Concepts and Skills
Obtaining Help Using the Help Table of Contents
![Page 57: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/57.jpg)
57
• Windows Help and Support is available when using Windows 7 or when using any Microsoft program running under Windows 7– Displays help for Windows 7
Office 2010 and Windows : Essential Concepts and Skills
Using Windows Help and Support
![Page 58: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/58.jpg)
58
• Click the Start button on the taskbar to display the Start menu
• Click Help and Support on the Start menu to open the Windows Help and Support window
• After reviewing the Windows Help and Support window, click the Close button to quit Windows Help and Support
Office 2010 and Windows : Essential Concepts and Skills
Starting Windows Help and Support
![Page 59: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/59.jpg)
59Office 2010 and Windows : Essential Concepts and Skills
Starting Windows Help and Support
![Page 60: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/60.jpg)
60
• To enter data into a cell, you must first select it• The easiest way to select a cell is to click on it• Type the desired text and press ENTER
Office 2010 and Windows : Essential Concepts and Skills
Entering Text in a Workbook
![Page 61: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/61.jpg)
Office 2010 and Windows : Essential Concepts and Skills 61
• In Excel, any set of characters containing a letter,
hyphen, or space is considered text.
• Text is used to place titles, such as workbook titles,
column and row titles, & worksheet names
• By default, text will be left-justified in a cell
• Calculations can not be performed on cells that
contain text.
Entering Text in a Workbook
![Page 62: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/62.jpg)
62
• Perform basic mouse operations• Start Windows and log on to the computer• Identify the objects on the Windows 7 desktop• Identify the programs in and versions of Microsoft
Office• Start a program• Identify the components of the Microsoft Office
Ribbon
Chapter Summary
Office 2010 and Windows : Essential Concepts and Skills
![Page 63: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/63.jpg)
63
• Create folders• Save files• Change screen resolution• Perform basic tasks in Microsoft Office programs• Manage files• Use Microsoft Office Help and Windows Help
Office 2010 and Windows : Essential Concepts and Skills
Chapter Summary
![Page 64: Office 2010 windows](https://reader034.vdocuments.us/reader034/viewer/2022042601/545b8744af79592b448b6306/html5/thumbnails/64.jpg)
Chapter Complete
MicrosoftExcel 2010