1 / 12

Intro to Microsoft Excel 2010

Intro to Microsoft Excel 2010. The Microsoft Excel window will open up ready for you to create a new spreadsheet. 1 The ribbon , which sits above the spreadsheet, includes a set of buttons and commands that allow you to do things in and with your spreadsheet (like print it).

chul
Télécharger la présentation

Intro to Microsoft Excel 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Intro to Microsoft Excel 2010

  2. The Microsoft Excel window will open up readyfor you to create a new spreadsheet • 1 The ribbon, which sits above the spreadsheet, includes a set of buttons and commands that allow you to do things in and with your spreadsheet (like print it). • 2 A blank spreadsheet, a grid made up of rows and columns, takes up most of the window. 1 2

  3. Rows In a spreadsheet the ROW is defined as the horizontal space that is going across the window . Numbers are used to designate each ROWS’ location. In the above diagram the ROW labeled 2 is highlighted.

  4. Columns In a spreadsheet the COLUMN is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN'S location. In the above diagram the COLUMN labeled B is highlighted

  5. Cells In a spreadsheet the CELL is defined as the space where a specified row and column intersect. Each CELL is assigned a name according to its’ COLUMN letter and ROW number. In the above diagram the CELL labeled D5 is highlighted. When referencing a cell you should put the COLUMN first and the ROW second .

  6. Calculations/Formulas Formula Bar

  7. Functions Calculated Sum

  8. Choose a alternate currency format for a selected cell Format Numbers Decrease Decimal. Show less precise values by showing fewer decimal places. Increase Decimal. Show more precise values by showing more decimal places. Display the value of the cell as a percentage Display the value of the cell with a thousands separator.

  9. Change the row height or column width

  10. Add formatting to make your text stand out

  11. Preparing to Print Preview before printing

  12. Add Headers, Footers & Grid Lines to your spreadsheet!

More Related