Exceed expectations Lesson 1 Exceed expectations Rudiments.


89 views
Uploaded on:
Category: Food / Beverages
Description
Exceed expectations Lesson 1 Exceed expectations Nuts and bolts Microsoft Office 2007: Early on Goals Characterize the terms spreadsheet and worksheet. Recognize the parts of a worksheet. Open a current exercise manual. Save an exercise manual. Move the dynamic cell in a worksheet. Select cells and enter information in a worksheet.
Transcripts
Slide 1

Exceed expectations Lesson 1 Excel Basics Microsoft Office 2007: Introductory

Slide 2

Objectives Define the terms spreadsheet and worksheet. Recognize the parts of a worksheet. Open a current exercise manual. Spare an exercise manual. Move the dynamic cell in a worksheet. Select cells and enter information in a worksheet. Microsoft Office 2007: Introductory

Slide 3

Objectives (proceeded with) Edit information in cells. Discover and supplant information. Zoom in a worksheet. See and print a worksheet. Close an exercise manual. Microsoft Office 2007: Introductory

Slide 4

Active cell Active worksheet Cell reference Column Formula Bar Microsoft Office Excel 2007 (Excel) Name Box Range reference Row Sheet tab Spreadsheet Workbook Worksheet Vocabulary Microsoft Office 2007: Introductory

Slide 5

Introduction to Spreadsheets Microsoft Office Excel 2007 (or Excel) is a spreadsheet program. A spreadsheet is a framework of lines and segments in which you enter content, numbers, and the aftereffects of estimations. The reason for a spreadsheet is to tackle issues that include numbers. PC spreadsheets can finish perplexing and dreary estimations rapidly and precisely. In Excel, an electronic spreadsheet is known as a worksheet. The document used to store worksheets is known as an exercise manual. As a rule, exercise manuals contain a gathering of related worksheets. Microsoft Office 2007: Introductory

Slide 6

Starting Excel You begin Excel from the Start menu in Windows. Click the Start catch, click All Programs, click Microsoft Office, and after that snap Microsoft Office Excel 2007. At the point when Excel begins, the project window shows a clear exercise manual titled Book1 , which incorporates three clear worksheets titled Sheet1 , Sheet2 , and Sheet3 . Microsoft Office 2007: Introductory

Slide 7

Exploring the Worksheet\'s Parts The name of every worksheet shows up in the sheet tab at the worksheet\'s base window. Sections show up vertically and are distinguished by letters. Columns show up on a level plane and are distinguished by numbers. A cell is the crossing point of a line and a segment. Every cell is recognized by an extraordinary cell reference, which is framed by joining the cell’s section letter and column number. For instance, the cell that meets at section C and line 4 has the cell reference C4. Microsoft Office 2007: Introductory

Slide 8

Exploring the Worksheet\'s Parts (proceeded with) The phone in the worksheet in which you can sort information is known as the dynamic cell. The Name Box, or cell reference range situated underneath the Ribbon, shows the cell reference of the dynamic cell. The Formula Bar appears to one side of the Name Box and presentations a recipe when the cell of a worksheet contains an ascertained worth (or the equation\'s consequences). A recipe is a comparison that figures another quality from qualities right now in a worksheet, for example, including the numbers in cell A1 and A2. Microsoft Office 2007: Introductory

Slide 9

Opening an Existing Workbook Opening an exercise manual means stacking a current exercise manual record from a circle into the system window. You can open an exercise manual put away on any accessible circle or envelope. To open a current exercise manual, you tap the Office Button to show the Office menu, and after that snap Open. The Open dialog box shows up. The Open dialog box demonstrates every one of the exercise manuals in the showed organizer that were made with Excel. Microsoft Office 2007: Introductory

Slide 10

Saving a Workbook Saving is done two ways. The Save charge spares a current exercise manual on a plate, utilizing its present name and spare area. The Save As summon gives you a chance to spare an exercise manual with another name or to another area. Microsoft Office 2007: Introductory

Slide 11

Moving the Active Cell in a Worksheet The most effortless approach to change the dynamic cell in a worksheet is to move the pointer to the cell you need to make dynamic and snap. You can change the dynamic cell by using so as to squeeze the keys or console easy routes. You may need to change the dynamic cell to a cell in a worksheet\'s piece that you can\'t find in the work zone. The quickest approach to move to that cell is with the Go To dialog box. Microsoft Office 2007: Introductory

Slide 12

Selecting a Group of Cells A gathering of chose cells is known as a reach. In a contiguous extent, all cells touch one another and structure a rectangle. The reach is distinguished by its extent reference, which is the cell in its upper-left corner and the cell in its lower-right corner, isolated by a colon (for instance, A3:C5). To choose a nearby range, tap the cell in one corner of the reach, drag the pointer to the cell in the inverse corner of the extent, and after that discharge the mouse catch. Microsoft Office 2007: Introductory

Slide 13

Selecting a Group of Cells (proceeded with) A non-nearby range incorporates two or more adjoining ranges and chose cells. The reach reference for a nonadjacent extent isolates every reach or cell with a semicolon (for instance, A3:C5;E3:G5). To choose a non-adjoining extent, select the first neighboring reach or cell, press the Ctrl key as you select alternate cells or reaches you need to incorporate, and after that discharge the Ctrl key and the mouse catch. Microsoft Office 2007: Introductory

Slide 14

Entering Data in a Cell Worksheet cells can contain content, numbers, or recipes. Content is any blend of letters and numbers and images, for example, headings, marks, or illustrative notes. Numbers are values, dates, or times. Recipes are mathematical statements that compute a quality. You enter information in the dynamic cell. To begin with, sort the content, numbers, or equation in the dynamic cell. At that point, tap the Enter catch on the Formula Bar or press the Enter or Tab key on the console. Microsoft Office 2007: Introductory

Slide 15

Changing Data in a Cell When you have to roll out a minor improvement to information in a cell, you can alter it in the Formula Bar or in the cell. When you have to roll out critical improvements to cell information, you can supplant the whole cell substance. To supplant cell substance, select the cell, sort the new information, and after that enter the information by tapping the Enter catch on the Formula Bar or by squeezing the Enter or Tab key. Clearing a phone uproots all the information in the phone. To clear the dynamic cell, you can utilize the Ribbon, the console, or the mouse. Microsoft Office 2007: Introductory

Slide 16

Searching for Data The Find charge finds information in a worksheet, which is especially useful when a worksheet contains a lot of information. The Replace summon is an expansion of the Find charge. Trading information substitutes new information for the information found. In the Editing gathering on the Home tab of the Ribbon, tap the Find & Select catch, and after that snap either Find or Replace. Microsoft Office 2007: Introductory

Slide 17

Zooming Worksheets You can amplify or diminish the perspective of a worksheet with the Zoom controls on the status bar. The default amplification for the exercise manuals is 100%. For a closer perspective of a worksheet, tap the Zoom In catch or drag the Zoom slider to one side to build the zoom rate. In the event that you need to see more cells in the work zone, tap the Zoom Out catch or drag the Zoom slider to one side to diminish the zoom rate. Microsoft Office 2007: Introductory

Slide 18

Previewing and Printing a Worksheet You can print a worksheet by tapping the Office Button, and afterward clicking Print to open the Print dialog box Before you utilize the assets to print a worksheet, you ought to utilize Print Preview to perceive how the printed pages will look. To change to Print Preview, snap Preview in the Print dialog box. Microsoft Office 2007: Introductory

Slide 19

Closing a Workbook You can close an exercise manual by tapping the Office Button to show the Office menu and clicking Close. On the off chance that you utilize the Close summon on the Office menu to close an exercise manual, Excel stays transparent for you to open or make another exercise manual. On the off chance that you attempt to close an exercise manual that contains transforms you haven’t spared, a dialog box opens, requesting that whether you need spare the document. Microsoft Office 2007: Introductory

Slide 20

Summary The reason for a spreadsheet is to take care of issues including numbers. The upside of utilizing a PC spreadsheet is that you can finish unpredictable and monotonous counts rapidly and precisely. A worksheet comprises of sections and columns that converge to shape cells. Every cell is distinguished by a cell reference, which joins the section\'s letter and the line\'s quantity. The first occasion when you spare an exercise manual, the Save As dialog box opens so you can enter an unmistakable name and select a spare area. After that, you can utilize the Save summon on the Office menu or the Save catch on the Quick Access Toolbar to occasionally spare the most recent adaptation of the exercise manual. Microsoft Office 2007: Introductory

Slide 21

Summary (proceeded with) You can change the dynamic cell in the worksheet by tapping the cell with the pointer, squeezing keys, or utilizing the parchment bars. The Go To dialog box gives you a chance to rapidly move the dynamic cell anyplace in the worksheet. A gathering of chose cells is known as a reach. An extent is distinguished by the cells in the upper-left and lower-right corners of the reach, isolated by a colon. To choose an adjoining extent, drag the pointer over the rectangle of cells you need to incorporate. To choose a nonadjacent extent, select the first adjoining reach, hold down the Ctrl key, select each extra cell or reach, and after that discharge the Ctrl key. Microsoft Office 2007: Introductory

Slide 22

Summary (proceeded with) Worksheet cells can contain content, numbers, and recipes. After you enter information or an equation in a cell, you can change t

Recommended
View more...