Liz Bennett

 

  •  

     

     

     

     

     

     

    Objectives

    You will have mastered the material in this chapter when you can:

    ●Create and use a template
    ●Use the Round function
    ●Utilize custom format codes
    ●Define, apply, and remove a style
    ●Copy data among worksheets in a workbook
    ●Drill an entry through worksheets
    ●Add worksheets to a workbook
    ●Create formulas that use 3-D references to ●cells in different sheets in a workbook
    ●Draw a 3D cone Chart
    ●Use Word Art to create a title
    ●Create comments
    ●Add a header and a footer
    ●Use Find/Replace

    BACK

     


     

 

 

 

 

 

 

 

  • Case Perspective

    A creative marketing campaign and unique sales model have helped a recent start-up company, Home Entertainment Systems (HES) grow to become one of the premier small companies in the United States.  The company, which sells a variety of home entertainment systems over the World Wide Web, maintains its inventory at its three former stores in Pittsburgh, Indianapolis, and Phoenix.  The company's sales model is unique in that customers sign up on the Web to purchase a home entertainment system over a two week period.  The price continues to decrease as more customers buy the system.  At the end of two-weeks, the final price is determined.  You have been asked to consolidate the inventory data from the three stores onto one worksheet and to create a chart that compares the gross profit potentials of the systems.

     BACK

     

     

     

     

     

     

     

     

     

     

     

     

  •  

Review

 

 BACK

 

 

 

 

 

 

 

 

 

 

 

Terms/Info

Consolidation - process of summarizing data found on multiple worksheets on one worksheet.

Template - special workbook you can create and then use as a pattern to create new, similar workbooks or worksheets.  Usually consists of a general format (worksheet title, column and row titles, and numeric format) and formulas that are common to all worksheets.  A template is a pattern used as a guide in the creation of a new piece of work

Dummy numbers serve two purposes – first, to check the accuracy of formulas, and second, to test the limits of the formulas. score character.

Series - to create a linear series, select the cell to the right of the start value, then that selected cell must be empty.

Date/time series -- Jan, Feb, March

AutoFill series, 1, 1, 1, etc.

Linear series 1, 2, 3, etc.

Growth series - multiplies values by a constant factor.  You create a growth series by pointing to Fill on the Edit menu and then clicking series.

Round function =ROUND (number, number of digits)

Format Code-Series of format symbols that define how a format displays.

Style - group of format specifications that are assigned to a style name.

Create a Workbook from a Template - once you have saved template, can being second phase by using it.  Can have up to 255 worksheets.  To change default number to worksheets, click Options on the Tools menu, click the general tab, and change the number in the Sheets in new workbook box.

Drilling an Entry through Worksheets-top have same formula on all four sheets.  Lets you enter number once and drill it through worksheets so it displays in the same cell on all selected worksheets.  Hold shift to select tabs.

Sheet reference - you can reference cells in other sheets.

3D Range - range that spans two or more sheets in a workbook.  Reference to this range is a 3D reference.

Comments - comments or notes are used to describe the functions of a cells. You can print comments by going to page setup, click sheet tab, click the comments box arrow and click where you want the comments printed in relation to the worksheet printout)

You can assign comments by using comment command on the Insert menu.

Header - printed at the top of every page in a printout.

Page Break-insert breaks in a worksheet.  Found on the insert menu.  Can remove it same steps, pick remove page break.

Footer - printed at bottom of every page.

Replace command - used to locate and replace a string with another string.

Find - locate a string

Look in box - allows you to select values, formulas, or comments.

Linking - reference to a cell or range of cells in another workbook.

Updating Links - linked workbooks are called the source workbooks.

 BACK