Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Microsoft Office Excel 2007
Transcript of Microsoft Office Excel 2007
Microsoft Excel is a powerful spread sheet program that allows users to organize data, complete calculations, make decision, graph data, & develop professional-looking reports.
Workbook- like a notebook containing a collection of worksheets.
Worksheets- individual sheets organized into a rectangular grid of verticle columns & horizontal rows within a workbook. Allows users to enter, calculate, manipulate, & analyze data.
Sheet Tab- displays the sheet name at the botton of a workbook.
Gridlines- horizontal & verticle lines on a worksheet
Cell- the intersection of a row & column, is a basic unit of a worksheet in which you can enter data
Range- a series of two or more adjacent cells
Four Major Parts
Worksheets-allow users to enter, calculate, manipulate and analyze data.
Charts-Pictorially represent data. Excel can draw two or three- demensional charts.
Tables-helps organize and manage data within a worksheet.
Web Support-allows users to save the worksheet in HTML format.
Ribbon-control center in Excel.
OfficeButton-central location for managing and sharing documents.
Quick Access Toolbar-provides easy access to frequently used commands.
Name Box-displays the active cell reference.
Cell Reference-unique address identifying cell coordinates.
Formula Bar-displays an entry as you type.
Status Bar-presents information about the worksheet
Text-is used to place titles and consists of any set of characters containing a letter, hyphen or space. Text is left aligned by default.
Numbers-are used to represent amounts. They are right aligned by default.
The Active Cell is the one which you can enter data.
Function-takes a value or values, computes a statistic, and returns a result to a cell.
All functions start with an equal sign, and include Arguments in parentheses after the function name.
Calculating a Sum
Sum Function computes the sum or total of a range of cells.
AutoSum Button- when selected, Excel selects a range of cells to sum. If the range is wrong you must select the correct range before clicking the button a second time.
AutoSum Button Arrow- provides access to other often used buttons.
Fill Handle- the small black square in the lower right corner of the active cell used to fill or copy a series.
Use the fill handle to copy a cell to adjacent cells.
Copy Area is the cell being copied or source
Paste Area is the cell recieving the copy or the destination.
Relative Reference- when you copy, excel adjusts the cell references for each new position.
Merging Cells involves creating a single cell by combining two or more selected cells. Use the
Merge & Center button to merge cells and center the contents of the cell across columns.
AutoCalculate Area is used in place of a calculator to view range totals. Use the Auto Calculate Area on the status bar to check your work by selecting the range of cells containing the numbers you want to check.
Charts- drawn to graphically represent data based on the values in a worksheet.
When you change a cell value on which a chart is dependent, Excel redraws the chart instantaneously.
Embedded Charts-are drawn on the same worksheet as the data.
Legend-identifies each bar in a chart as titles from the leftmost column.