*Additionally, the file button has been replaced by the Microsoft office sign in the upper left corner and is called the Office Button. The Ribbon is designed to make the features of the application more discoverable and accessible with fewer mouse clicks as compared to the menu-based UI used until Office It is not possible to remove the Ribbon or replace it with menus with the normal Office 2007 functions. Within each tab, various related options may be grouped together. For example, while Excel has a tab for the Graphing capabilities, Word does not feature the same instead it has tabs to control the formatting of a text document. Each application has a different set of tabs which expose the functionality that application offers. 1: Worksheet tabs Updated by Rachael Steller (Summer 2008) 2ģ Ribbon The Ribbon, a panel that houses the command buttons and icons, organizes commands as a set of Tabs, each grouping relevant commands (see Fig. Existing worksheets and associated tabs Click on this tab for a new worksheet Fig.
You can combine many functions and operators in a single formula to obtain more complex results (e.g.: =SUM(A1:A13)). Functions pre-written formulae that perform common (and not so common) calculations, such as summation and averaging. When you type a formula into a cell, that cell will generally display the result obtained by the formula, rather than the formula itself. Often they consist of some combination of the standard mathematical operators ( +, -, *, /) (e.g.: =(A1+A5)/B13), but they may also include functions (see below). Formula a mathematical formula used to calculate a result based on data from one or more other cells. 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).
HOW TO USE MICROSOFT OFFICE TO MAKE LABELS FREE
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)
