Excel Chapter 2: Gaining Proficiency:...
Objectives

  1. Gain proficiency in the use of relative and absolute references to create a spreadsheet; explain the importance of isolating the assumptions in a worksheet.

  2. Use the fill handle to copy a cell formula to a range of adjacent cells.

  3. Use pointing to enter a formula; explain the advantage of pointing over explicitly typing cell references.

  4. Insert a hyperlink into an Excel worksheet.

  5. Save a worksheet as a Web page; explain how the concept of "round trip html" applies to editing a Web page.

  6. Import data from a Web query into an Excel workbook; explain how to refresh the query to obtain current information.

  7. Describe the Today function and its use in date arithmetic.



Copyright © 1995-2004 by Prentice-Hall, Inc. A Pearson Company Legal Notice