190 likes | 414 Views
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
E N D
Microsoft Office Software WordWord documents ExcelNumbersPowerPoint PresentationsPublisher Desk top publishingAccessData basesOutlook Calendar and mailFrontPage Web pageInternet explorerBrowser
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
Made Up of Rows and Columns • Intersect at a cell • Columns go up and down • Rows go across
Cells Contain • Characters (or labels) • Numbers constants datesformulasfunctions
Orders of Operations • P - E - M D - A SPlease Excuse My Dear Aunt Sally
Practice with My Dear Aunt Sally.docx Click here to load Practice with My Dear Aunt Sally.docx Practice Problems
Keys On the Computer + - * / ^ ()
File Names • 1-255 characters • Spaces allowed • Case insensitive • Extensions allowed (___.xlsx) • Some special characters allowed • Some special characters not allowed
___.xlsvrs ___.xlsx • Smaller • Programmable • Harder to hide virus • Similar to xml
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
Practice with Formulas Click here to go to Practice with Formulas
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
More Misc • Freezing worksheet titles • Spell check page • System date • Goal seek
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