ComputerApps_06_MicrosoftExcelPart1+.pptx - Computer...

This preview shows page 1 - 7 out of 10 pages.

The preview shows page 5 - 7 out of 10 pages.
Microsoft Excel, part 1Computer Applications forManagers
Open from Start menu- alwayshas letter X and is greenCreate new document just likeMicrosoft WordKey termsCell (1)Row (2)Column (3)Creating a New Workbook
Open blank worksheet- first cell is A1, then A2, etc.Move over using TABB1, B2, etc.Enter Data into a Table
Table styleSelect cells that belong in tableClick “Format as Table” buttonChoose style to applyApply cell stylesDefault stylesStyles within Excel
Format methodsHighlight cells, select ”Format”dropdown from “Cells” (1)Use “Number” group (2)Change comma style“Format cell” drop down menu-select “Use 1000 Separator (,)” (1)“Comma Style” in “Number” group(2)“Comma”- 2 decimals“Comma [0]”- no decimals“Currency”0- 2 decimals and $ signChange Default Cell Displays
Add Columns and RowsMethod 1Identify areaRight-click to right of area where column will goSelect “Insert”Method 2

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 10 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Spring
Professor
Holified
Tags

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture