1 / 87

# Exceed expectations Part 2.

104 views
Category: Food / Beverages
Description
Exceed expectations Part 2 Equations, Capacities, Arranging, and Web Questions Destinations Enter recipes utilizing the console and Point mode Apply the Normal, MAX, and MIN capacities Check an equation utilizing Range Discoverer Apply a subject to an exercise manual Add contingent organizing to cells
Transcripts
Slide 1

Exceed expectations Chapter 2 Formulas, Functions, Formatting, and Web Queries

Slide 2

Objectives Enter equations utilizing the console and Point mode Apply the AVERAGE, MAX, and MIN capacities Verify a recipe utilizing Range Finder Apply a subject to an exercise manual Add restrictive organizing to cells Change segment width and line stature Microsoft Office 2007: Introductory Concepts and Techniques

Slide 3

Objectives Check the spelling of a worksheet Set edges, headers and footers in Page Layout View Preview and print variants of a worksheet Use a Web question to get constant information from a Web webpage Rename sheets in an exercise manual E-mail the dynamic exercise manual from inside Excel Microsoft Office 2007: Introductory Concepts and Techniques

Slide 4

Plan Ahead Plan the worksheet\'s design Determine the vital equations and capacities required Identify how to arrange different components of the worksheet Establish rules for contingent arranging Specify how the printed worksheet ought to show up Gather data in regards to the required Web inquiry Choose names for the worksheets Microsoft Office 2007: Introductory Concepts and Techniques

Slide 5

Starting Excel Click the Start catch on the Windows Vista taskbar to show the Start menu Point to All Programs at the left\'s base sheet on the Start menu to show the All Programs rundown Click Microsoft Office in the All Programs rundown to show the Microsoft Office rundown Click Microsoft Office Excel to begin Excel and presentation a clear worksheet in the Excel window If the Excel window is not augmented, click the Maximize catch beside the Close catch on its title bar to amplify the window tap the Maximize catch by the Close catch on its title bar to boost the worksheet window inside Excel Microsoft Office 2007: Introductory Concepts and Techniques

Slide 6

Entering the Worksheet Title and Subtitle If important, Select cell A1. Sort Silver Dollars Stock Club in the phone and after that press the DOWN ARROW key to enter the worksheet title in cell A1 Type Portfolio Summary in cell A2 and after that press the DOWN ARROW key to enter the worksheet subtitle in cell A2 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 7

Entering the Column Titles With cell A3 chose, sort Stock and after that press the RIGHT ARROW key Type Symbol in cell B3 and after that press the RIGHT ARROW key In cell C3, sort Date and afterward press ALT+ENTER. Sort Acquired and after that press the RIGHT ARROW key In cell D3, sort Shares and after that press the RIGHT ARROW key In cell E3, sort Initial and afterward press ALT+ENTER. Sort Price and after that press ALT+ENTER Type Per Share and afterward press the RIGHT ARROW key Microsoft Office 2007: Introductory Concepts and Techniques

Slide 8

Entering the Column Titles Type Initial in cell F3 and afterward press ALT+ENTER . Sort Cost and after that press the RIGHT ARROW key In cell G3, sort Current and after that press ALT+ENTER. Sort Price and afterward press ALT+ENTER. Sort Per Share and after that press the RIGHT ARROW key Type Current in cell H3 and afterward press ALT+ENTER . Sort Value and afterward press the RIGHT ARROW key In cell I3, sort Gain/Loss and after that press the RIGHT ARROW key In cell J3, sort Percent and afterward press ALT+ENTER. Sort Gain/Loss Microsoft Office 2007: Introductory Concepts and Techniques

Slide 9

Entering the Portfolio Summary Data Select cell A4, sort Apple Computers, and afterward press the RIGHT ARROW key Type AAPL in cell B4 and after that press the RIGHT ARROW key Type 12/1/04 in cell C4 and afterward press the RIGHT ARROW key Type 440 in cell D4 and afterward press the RIGHT ARROW key Type 64.59 in cell E4 and afterward click cell G4 Type 82.99 in cell G4 and afterward click cell A5 Enter the portfolio synopsis information in Table 2â1 for the eight remaining stocks in lines 5 through 12 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 10

Entering the Portfolio Summary Data Microsoft Office 2007: Introductory Concepts and Techniques

Slide 11

Entering the Row Titles Select cell A13. Sort Totals and after that press the DOWN ARROW key. Sort Average in cell A14 and after that press the DOWN ARROW key Type Highest in cell A15 and afterward press the DOWN ARROW key. Sort Lowest in cell A16 and after that press the ENTER key. Select cell F4 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 12

Changing Workbook Properties and Saving the Workbook Click the Office Button, snap Prepare on the Office Button menu, and after that snap Properties Update the record properties with your name and whatever other data obliged Click the Close catch on the Properties sheet With a USB glimmer drive associated with one of the computerâs USB ports, tap the Save catch on the Quick Access toolbar When Excel shows the Save As dialog box, sort Silver Dollars Stock Club Portfolio Summary in the File name content box Microsoft Office 2007: Introductory Concepts and Techniques

Slide 13

Changing Workbook Properties and Saving the Workbook If the Folders rundown is shown beneath the Folders catch, tap the Folders catch to uproot the Folders list. In the event that Computer is not showed in the Favorite Links area, drag the top or base edge of the Save As dialog box until Computer is shown. Click Computer in the Favorite Links area. In the event that fundamental, look until UDISK 2.0 (E:) shows up in the rundown of accessible drives. Double tap UDISK 2.0 (E:) (your USB glimmer drive may have an alternate name and letter). Click the Save catch in the Save As dialog box to spare the exercise manual on the USB fl powder drive utilizing the record name, Silver Dollars Stock Club Portfolio Summary. Microsoft Office 2007: Introductory Concepts and Techniques

Slide 14

Entering a Formula Using the Keyboard With cell F4 chose, sort =d4*e4 in the phone to show the recipe in the equation bar and in cell F4 and to show shaded fringes around the phones referenced in the recipe Press the RIGHT ARROW key twice to finish the number juggling operation demonstrated by the recipe, show the outcome, 28419.6, and to choose cell H4 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 15

Entering a Formula Using the Keyboard Microsoft Office 2007: Introductory Concepts and Techniques

Slide 16

Entering Formulas Using Point Mode With cell H4 chose, sort = (equivalent sign) to start the recipe and after that snap cell D4 to add a reference to cell D4 to the equation Type * (indicator) and after that snap cell G4 to include an augmentation administrator and reference to cell G4 to the recipe Click the Enter box and afterward click cell I4 to choose cell I4 Type = (equivalent sign) and afterward click cell H4 to add a reference to cell H4 to the recipe Type â (short sign) and after that snap cell F4 to include a subtraction administrator and reference to cell F4 to the recipe Microsoft Office 2007: Introductory Concepts and Techniques

Slide 17

Entering Formulas Using Point Mode Click the Enter box to enter the equation in cell I4 Select cell J4. Sort = (equivalent sign) and afterward click cell I4 to add a reference to cell I4 to the recipe Type/(forward cut) and afterward click cell F4 to add a reference to cell F4 to the equation Click the Enter box to enter the equation in cell J4 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 18

Entering Formulas Using Point Mode Microsoft Office 2007: Introductory Concepts and Techniques

Slide 19

Copying Formulas Using the Fill Handle Select cell F4 and afterward indicate the fill handle Drag the fill handle down through cell F12 and keep on holding the mouse catch to choose the destination extent Release the mouse catch to duplicate the recipe in cell F4 to the phones in the reach F5:F12 Select the extent H4:J4 and after that indicate the fill handle Drag the fill handle down through the extent H5:J12 to duplicate the three equations =D4*G4 in cell H4, =H4-F4 in cell I4, and =I4/F4 in cell J4 to the reach H5:J12 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 20

Copying Formulas Using the Fill Handle Microsoft Office 2007: Introductory Concepts and Techniques

Slide 21

Determining the Total Percent Gain/Loss Select cell J12 and after that indicate the fill handle Drag the fill handle down through cell J13 to duplicate the equation in cell J12 to cell J13 Microsoft Office 2007: Introductory Concepts and Techniques â Windows Vista Edition

Slide 22

Determining the Total Percent Gain/Loss Microsoft Office 2007: Introductory Concepts and Techniques

Slide 23

Determining the Average of a Range of Numbers Using the Keyboard and Mouse Select cell D14 Type = av in the phone to show the Formula AutoComplete rundown Point to the AVERAGE capacity name Double-snap AVERAGE in the Formula AutoComplete rundown to choose the AVERAGE capacity Select the reach D4:D12 to embed the extent as the contention to the AVERAGE capacity Click the Enter box to figure the nine\'s normal numbers in the reach D4:D12 and showcase the outcome in cell D14 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 24

Determining the Average of a Range of Numbers Using the Keyboard and Mouse Microsoft Office 2007: Introductory Concepts and Techniques

Slide 25

Determining the Highest Number in a Range of Numbers Using the Insert Function Box Select cell D15 Click the Insert Function enclose the recipe bar to show the Insert Function dialog box When Excel shows the Insert Function dialog box, click MAX in the Select a capacity rundown Click the OK catch When Excel shows the Function Arguments dialog box, sort d4:d12 in the Number 1 box Click the OK catch to show the most astounding worth in the extent D4:D12 in cell D15 Microsoft Office 2007: Introductory Concepts and Techniques

Slide 26

Determining the Highest Number in a Range of Numbers Using the Insert Function Box Microsoft Office 2007: Introductory Concepts and Techniques

Slide 27

Determining the Lowest Number in a Range of Numbers Using

Recommended
View more...