ExcelLecture-Full+Slides.pdf - Apco 1p01 u2013 Working...

This preview shows page 1 - 8 out of 22 pages.

Apco 1p01 Working within a Spreadsheet Creating a Worksheet
What is a Spreadsheet? n Spreadsheet is a tool to organize numerical data n Spreadsheet, sheet and worksheet are terms that are used interchangeably n Used in business today for: Budgets Cash flow analysis Business plans Projections What - if analysis
Advantages of Electronic Spreadsheets n Accuracy of calculating numbers n Ease of making changes and corrections n Speed in creating the spreadsheet n Ability to prepare and present an attractive report n Ease of creating graphs and charts using the data in the worksheet n Ability to make business decisions n Access to internet and ability to retrieve data into your worksheet n Multiple users can share and edit the same file
Workbook n A workbook contains a collection of worksheets saved as one file n Only one worksheet is visible when Excel is started n The worksheets are identified by the tabs at the bottom of the sheet n Clicking on a tab will access a different worksheet in the Workbook
The Worksheet n Comprised of a grid of horizontal rows and vertical columns n Column letters A - Z, AA - AZ, BA - BZ,… maximum of 256 columns n Row numbered from 1 to 65,536 n Cell the place where a row and a column intersect maximum of 16.7 million cells in a worksheet active cell is identified by the dark border surrounding it n Cell Reference formed by the letter of the column followed by the number of the row. Eg E27
Parts of the Excel Sheet n Title Bar identifies the file name of the document n Menu Bar displays all of the various commands that are used to interact with Excel n Control Buttons used to control viewing, minimizing and closing Excel n Toolbars Standard used for common commands such as Save, Printing, Copying, etc… Formatting used to quickly format the worksheet Formula used to enter of change values in cells
Ways to Move Around Worksheet n Use the scroll bars located at the bottom and right edge of the worksheet n Use the arrow keys on the keyboard

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture