Column columns travel vertically and are assigned letters. Row rows travel horizontally and are numbered. the cell in column B at row 3 is referenced as cell B3). They are assigned an address, generally referred to as a cell reference, according to their column and row (e.g. As with a binder, you can: Add sheets to your Workbook: Insert > Worksheet, or click on the new worksheet tab to the right of the tabs for your existing worksheets Delete worksheets: by right-clicking on the tab of the worksheet you wish to delete, then selecting delete Re-arrange them: by clicking on the worksheet tab and dragging it to the location you desire Rename worksheets: by double-clicking on the worksheet title Cell cells are the basic rectangular building blocks of a spreadsheet. Think of a three ring binder with three sheets of paper in it. It is called Book because it is a Workbook that is initially made up of three Worksheets (accessible from the tabs in the lower left corner of your excel window - see Fig. Worksheet when you open Excel, a new file is created called Book 1 (until you name it differently). If you have any questions, feel free to ask a TLC staff consultant for assistance during staffed hours at your center.
Spreadsheets are commonly be used to perform many different types of calculations. Spreadsheets allow information to be organized in rows and tables and analyzed with automatic mathematics. In this tutorial, learn how to: Navigate Cells Manipulate Data Use Formulas and Functions Create Charts and Tables Contents Getting Started 2-3 Definitions 2 Ribbon 3 Navigating Cells 3 Data 4-7 Entering Data/Text 4 Editing Data/Text 4 Autofill 5-6 Controlling Your View of Data 6 Sorting and Filtering 6-7 Formulas 7-9 Cell References Autofill with Formulae 7 AutoSum 8 Functions 8 AutoCalculate 9 Name Manager 9 Charts 9 Pivot table Trouble-shooting 11 Printing 12 Updated by Rachael Steller (Summer 2008) 1Ģ Getting Started Microsoft Office Excel is a powerful tool used to create and format spreadsheets.
1 Microsoft Office Excel is a powerful tool used to create and format spreadsheets.
0 kommentar(er)
