1 / 19

Excel

Excel. Microsoft Office Software. Word Word documents Excel Numbers PowerPoint Presentations Publisher Desk top publishing Access Data bases Outlook Calendar and mail FrontPage Web page Internet explorer Browser. Electronic Spreadsheets are Great Because of Six Things. Fast

cybill
Download Presentation

Excel

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. Excel

  2. Microsoft Office Software WordWord documents ExcelNumbersPowerPoint PresentationsPublisher Desk top publishingAccessData basesOutlook Calendar and mailFrontPage Web pageInternet explorerBrowser

  3. Electronic Spreadsheets are Great Because of Six Things • Fast • Reliable • Edit • Multitask (word and excel or excel and the internet-portfolio) • Create a chart • Math modeling

  4. Made Up of Rows and Columns • Intersect at a cell • Columns go up and down • Rows go across

  5. Cells Contain • Characters (or labels) • Numbers constants datesformulasfunctions

  6. Orders of Operations • P - E - M D - A SPlease Excuse My Dear Aunt Sally

  7. Practice with My Dear Aunt Sally.docx Click here to load Practice with My Dear Aunt Sally.docx Practice Problems

  8. Answers to Practice with My Dear Aunt Sally

  9. Keys On the Computer + - * / ^ ()

  10. File Names • 1-255 characters • Spaces allowed • Case insensitive • Extensions allowed (___.xlsx) • Some special characters allowed • Some special characters not allowed

  11. ___.xlsvrs ___.xlsx • Smaller • Programmable • Harder to hide virus • Similar to xml

  12. Defaults • Calibri font face • 11 points • Margins.75 top/bottom.70 left/right.30 header/footer • Column widths – 8.43 points • Orientation – portrait • File name – Book1.xlsx

  13. First Example

  14. Math Modeling

  15. Practice with Formulas Click here to go to Practice with Formulas

  16. Answers to Practice with Formulas

  17. Misc Topics • Text – left aligned • Numbers – right aligned • Control home/end • Type in a cell and it bleeds over • Edit the text edit box • Highlight a range and the upper left cell is • Clear rest are blue • Hit delete and the above deletes

  18. More Misc • Freezing worksheet titles • Spell check page • System date • Goal seek

  19. Random Numbers • =TRUNC(10*RAND()) between 0 and 9 • =TRUNC(10*RAND())+1 between 1 and 10 • =TRUNC(100*RAND()) between 0 and 99 • =TRUNC(100*RAND())+1 between 1 and 100

More Related