5 2 Microsoft Excel Microsoft Excel Microsoft Excel
![5. 2 Microsoft Excel 5. 2 Microsoft Excel](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-1.jpg)
![Microsoft Excel… …Microsoft Excel is the spreadsheet component of the Microsoft Office Suite. It Microsoft Excel… …Microsoft Excel is the spreadsheet component of the Microsoft Office Suite. It](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-2.jpg)
![Objectives • Identify the main parts of the Excel window. • Identify the purpose Objectives • Identify the main parts of the Excel window. • Identify the purpose](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-3.jpg)
![Objectives • Explain the purpose of options available for printing a spreadsheet. • Enter Objectives • Explain the purpose of options available for printing a spreadsheet. • Enter](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-4.jpg)
![Objectives • Successfully move from one cell to another containing formulas and text. • Objectives • Successfully move from one cell to another containing formulas and text. •](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-5.jpg)
![Objectives • Understand cell references. • Perform basic mathematical operations in a spreadsheet. • Objectives • Understand cell references. • Perform basic mathematical operations in a spreadsheet. •](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-6.jpg)
![Screen Components The opening screen for Microsoft Excel 2010 looks like this… Screen Components The opening screen for Microsoft Excel 2010 looks like this…](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-7.jpg)
![Terminology While different versions have different appearances, they all have most of the same Terminology While different versions have different appearances, they all have most of the same](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-8.jpg)
![](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-9.jpg)
![The area outlined in red is called the title bar. It displays the names The area outlined in red is called the title bar. It displays the names](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-10.jpg)
![The area outlined in red contains the minimize, maximize/restore and close buttons for the The area outlined in red contains the minimize, maximize/restore and close buttons for the](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-11.jpg)
![These three buttons are on almost every window that opens in a Windows based These three buttons are on almost every window that opens in a Windows based](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-12.jpg)
![When you click the minimize button the program becomes a button on the Windows When you click the minimize button the program becomes a button on the Windows](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-13.jpg)
![You can restore the document to its original shape and size by either: Clicking You can restore the document to its original shape and size by either: Clicking](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-14.jpg)
![If you have multiple files from the same program open you will need to If you have multiple files from the same program open you will need to](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-15.jpg)
![When you click the maximize / restore button the program assumes the same shape When you click the maximize / restore button the program assumes the same shape](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-16.jpg)
![When you click the close button the program will ask you if you want When you click the close button the program will ask you if you want](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-17.jpg)
![The area outlined in red is called the quick access toolbar. It contains the The area outlined in red is called the quick access toolbar. It contains the](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-18.jpg)
![Microsoft Office 2007 & 2010 use what is referred to as the “Ribbon” interface. Microsoft Office 2007 & 2010 use what is referred to as the “Ribbon” interface.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-19.jpg)
![You may customize the ribbon and or a group on the ribbon on your You may customize the ribbon and or a group on the ribbon on your](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-20.jpg)
![The words File, Home, Insert, etc… outlined in red are referred to as tabs. The words File, Home, Insert, etc… outlined in red are referred to as tabs.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-21.jpg)
![The area outlined in red is referred to as the worksheet and most of The area outlined in red is referred to as the worksheet and most of](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-22.jpg)
![The name bar tells you the column and row of the cell that is The name bar tells you the column and row of the cell that is](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-23.jpg)
![The File Tab menu contains the commands most commonly associated with the file. The File Tab menu contains the commands most commonly associated with the file.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-24.jpg)
![The Home Tab Groups contain the commands most commonly associated with the formatting and The Home Tab Groups contain the commands most commonly associated with the formatting and](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-25.jpg)
![The Insert Tab Groups contain the commands most commonly associated with adding something to The Insert Tab Groups contain the commands most commonly associated with adding something to](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-26.jpg)
![The Page Layout Groups contain the commands most commonly associated with settings that would The Page Layout Groups contain the commands most commonly associated with settings that would](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-27.jpg)
![The Formulas Groups contain the commands most commonly associated with Excel’s formulas and functions. The Formulas Groups contain the commands most commonly associated with Excel’s formulas and functions.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-28.jpg)
![The Data Tab groups contain the commands most commonly associated with data from external The Data Tab groups contain the commands most commonly associated with data from external](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-29.jpg)
![The Review Tabs groups contain the commands most commonly associated with the text portions The Review Tabs groups contain the commands most commonly associated with the text portions](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-30.jpg)
![The View Tab groups contain the commands most commonly associated with the variety of The View Tab groups contain the commands most commonly associated with the variety of](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-31.jpg)
- Slides: 31
![5 2 Microsoft Excel 5. 2 Microsoft Excel](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-1.jpg)
5. 2 Microsoft Excel
![Microsoft Excel Microsoft Excel is the spreadsheet component of the Microsoft Office Suite It Microsoft Excel… …Microsoft Excel is the spreadsheet component of the Microsoft Office Suite. It](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-2.jpg)
Microsoft Excel… …Microsoft Excel is the spreadsheet component of the Microsoft Office Suite. It is used primarily to enter, edit, format, sort, perform mathematical computations, save, retrieve and print numeric data.
![Objectives Identify the main parts of the Excel window Identify the purpose Objectives • Identify the main parts of the Excel window. • Identify the purpose](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-3.jpg)
Objectives • Identify the main parts of the Excel window. • Identify the purpose of the commands on the menu bar. • Work with the buttons on the toolbar.
![Objectives Explain the purpose of options available for printing a spreadsheet Enter Objectives • Explain the purpose of options available for printing a spreadsheet. • Enter](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-4.jpg)
Objectives • Explain the purpose of options available for printing a spreadsheet. • Enter and format text and numbers into cells.
![Objectives Successfully move from one cell to another containing formulas and text Objectives • Successfully move from one cell to another containing formulas and text. •](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-5.jpg)
Objectives • Successfully move from one cell to another containing formulas and text. • Copy, Cut and Paste text and formulas. • Understand cell references.
![Objectives Understand cell references Perform basic mathematical operations in a spreadsheet Objectives • Understand cell references. • Perform basic mathematical operations in a spreadsheet. •](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-6.jpg)
Objectives • Understand cell references. • Perform basic mathematical operations in a spreadsheet. • Copy, Cut and Paste text and formulas.
![Screen Components The opening screen for Microsoft Excel 2010 looks like this Screen Components The opening screen for Microsoft Excel 2010 looks like this…](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-7.jpg)
Screen Components The opening screen for Microsoft Excel 2010 looks like this…
![Terminology While different versions have different appearances they all have most of the same Terminology While different versions have different appearances, they all have most of the same](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-8.jpg)
Terminology While different versions have different appearances, they all have most of the same features. If you know what to call it, you should be able to find it in other versions.
![](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-9.jpg)
![The area outlined in red is called the title bar It displays the names The area outlined in red is called the title bar. It displays the names](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-10.jpg)
The area outlined in red is called the title bar. It displays the names of the open program (in this case Microsoft Excel) and the name of the current file.
![The area outlined in red contains the minimize maximizerestore and close buttons for the The area outlined in red contains the minimize, maximize/restore and close buttons for the](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-11.jpg)
The area outlined in red contains the minimize, maximize/restore and close buttons for the program window.
![These three buttons are on almost every window that opens in a Windows based These three buttons are on almost every window that opens in a Windows based](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-12.jpg)
These three buttons are on almost every window that opens in a Windows based platform. They are on Mac windows as well, but they are circles instead of squares.
![When you click the minimize button the program becomes a button on the Windows When you click the minimize button the program becomes a button on the Windows](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-13.jpg)
When you click the minimize button the program becomes a button on the Windows taskbar located at the bottom of the screen.
![You can restore the document to its original shape and size by either Clicking You can restore the document to its original shape and size by either: Clicking](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-14.jpg)
You can restore the document to its original shape and size by either: Clicking on the button on the task bar one time to restore it to active mode,
![If you have multiple files from the same program open you will need to If you have multiple files from the same program open you will need to](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-15.jpg)
If you have multiple files from the same program open you will need to select the one you want to restore to active mode.
![When you click the maximize restore button the program assumes the same shape When you click the maximize / restore button the program assumes the same shape](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-16.jpg)
When you click the maximize / restore button the program assumes the same shape and size it was before you minimized it. Or The program window will fill the screen.
![When you click the close button the program will ask you if you want When you click the close button the program will ask you if you want](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-17.jpg)
When you click the close button the program will ask you if you want to save the changes if you have made any changes. Once you have responded to this question the program will close.
![The area outlined in red is called the quick access toolbar It contains the The area outlined in red is called the quick access toolbar. It contains the](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-18.jpg)
The area outlined in red is called the quick access toolbar. It contains the most commonly used commands in Microsoft Word: 1. Save 2. Undo 3. Repeat
![Microsoft Office 2007 2010 use what is referred to as the Ribbon interface Microsoft Office 2007 & 2010 use what is referred to as the “Ribbon” interface.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-19.jpg)
Microsoft Office 2007 & 2010 use what is referred to as the “Ribbon” interface. The area outlined in red is the Ribbon. The ribbons we are going to go over today are the default ribbons.
![You may customize the ribbon and or a group on the ribbon on your You may customize the ribbon and or a group on the ribbon on your](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-20.jpg)
You may customize the ribbon and or a group on the ribbon on your personal computer to have only the features you want to use. In order to do this all you have to do is right mouse click on the ribbon or the group you want to customize.
![The words File Home Insert etc outlined in red are referred to as tabs The words File, Home, Insert, etc… outlined in red are referred to as tabs.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-21.jpg)
The words File, Home, Insert, etc… outlined in red are referred to as tabs. Each Tab has several Groups attached to it.
![The area outlined in red is referred to as the worksheet and most of The area outlined in red is referred to as the worksheet and most of](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-22.jpg)
The area outlined in red is referred to as the worksheet and most of its components remain the same regardless of which tab you are currently using.
![The name bar tells you the column and row of the cell that is The name bar tells you the column and row of the cell that is](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-23.jpg)
The name bar tells you the column and row of the cell that is selected.
![The File Tab menu contains the commands most commonly associated with the file The File Tab menu contains the commands most commonly associated with the file.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-24.jpg)
The File Tab menu contains the commands most commonly associated with the file.
![The Home Tab Groups contain the commands most commonly associated with the formatting and The Home Tab Groups contain the commands most commonly associated with the formatting and](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-25.jpg)
The Home Tab Groups contain the commands most commonly associated with the formatting and editing of cells and their contents. Clipboard Number Alignment Font Styles Cells Editing
![The Insert Tab Groups contain the commands most commonly associated with adding something to The Insert Tab Groups contain the commands most commonly associated with adding something to](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-26.jpg)
The Insert Tab Groups contain the commands most commonly associated with adding something to the document. Tables Illustrations Charts Filter Sparklines Text Links Symbols
![The Page Layout Groups contain the commands most commonly associated with settings that would The Page Layout Groups contain the commands most commonly associated with settings that would](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-27.jpg)
The Page Layout Groups contain the commands most commonly associated with settings that would affect the entire page or worksheet. Themes Page Setup Paragraph Page Background Arrange
![The Formulas Groups contain the commands most commonly associated with Excels formulas and functions The Formulas Groups contain the commands most commonly associated with Excel’s formulas and functions.](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-28.jpg)
The Formulas Groups contain the commands most commonly associated with Excel’s formulas and functions. Function Library Defined Names Calculation Formula Auditing
![The Data Tab groups contain the commands most commonly associated with data from external The Data Tab groups contain the commands most commonly associated with data from external](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-29.jpg)
The Data Tab groups contain the commands most commonly associated with data from external sources, and evaluating or arranging data. Get External Data Connections Data Tools Sort & Filter Outline
![The Review Tabs groups contain the commands most commonly associated with the text portions The Review Tabs groups contain the commands most commonly associated with the text portions](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-30.jpg)
The Review Tabs groups contain the commands most commonly associated with the text portions of a spreadsheet and sharing changes. Proofing Comments Language Changes
![The View Tab groups contain the commands most commonly associated with the variety of The View Tab groups contain the commands most commonly associated with the variety of](https://slidetodoc.com/presentation_image_h2/ced52c3d08744c1171855ad75c7ce597/image-31.jpg)
The View Tab groups contain the commands most commonly associated with the variety of ways you can “look at” a worksheet or workbook. Show Zoom Workbook Views Window Macros
Microsoft excel merupakan program aplikasi ....
Microsoft official academic course microsoft excel 2016
Microsoft excel chapter 1
Deretan menu untuk menjalankan sebuah perintah disebut
Microsoft excel
Jenis-jenis operator pada microsoft excel
Excel lesson 4 vocabulary
Microsoft excel environment with label
Apa kegunaan operator rasional pada microsoft excel
Boolean logic in excel
Modul microsoft excel
Orientasi program ms excel adalah pada pengolahan
Microsoft excel 2016 basics vocabulary
Microsoft excel conditional formatting
El software utilitario microsoft excel es:
Fungsi menu microsoft excel
Microsoft excel 2010 training
Apa kegunaan operator rasional pada microsoft excel
Excel vocabulary
Sebutkan ikon yang ada pada menu bar ms excel
Excel xp
Microsoft excel program
Excel adalah
Excel macro adalah
Uraikan tentang efektivitas rumus pada microsoft excel 2013
Group adalah perintah untuk
Que representa
How to apply savon theme in excel
Pengenalan microsoft excel
Excel xp
Exploring microsoft office excel 2016 comprehensive
John walkenbach