Wiley 978-0-471-79845-3 Datasheet

Chapter 1Entering the Spreadsheet DataIn This Chapter䊳 Launching Excel and opening a new workbook䊳 Moving around the workbook䊳 Selecting cell ranges i

Check your completed spreadsheet table against the one in Solved1-9.xls. (Open thisworkbook in the Chap1 folder inside the My Practice Spreadsheets fo

Instead of filling in these recognized data series with AutoFill, you can force Excel tocopy the entry you’ve made in the current cell by holding down

Exercise 1-11: Copying a Formula with AutoFillComplete the Spring Sale table by using the following steps to enter the formula thatcalculates the sale

Exercise 1-12: Saving a SpreadsheetSave the Spring Sales table in a new My Spreadsheets folder inside the My Documentsfolder on your hard disk:1. With

22Part I: Creating Spreadsheets 05_798452 ch01.qxp 3/13/06 7:52 PM Page 22

Exercise 1-1: Launching ExcelThe last three methods listed previously for launching Excel are available only ifyou’ve added the Excel program icon to

Exercise 1-2: Opening a New WorkbookLaunch Excel and then open a new workbook (Book2). Switch to Book1 (notice thechange in the Excel program title ba

Moving around the WorkbookThe key to doing both data entry and data editing in any spreadsheet is selecting thecell or cells you want to fill or modif

⻬ If you use a mouse with a wheel button, scroll up and down the rows of the work-sheet by rotating the wheel button forward (to scroll up) and backwa

Moving to a different sheet in the workbookEach new workbook you start uses the general Excel Worksheet template that auto-matically includes three bl

A cell range is most often described by the reference of its first and last cell (that is,the cell in the upper-left corner and the lower-right corner

numbers or calculable formulas. Text entries are those that consist of all letters or acombination of letters, numbers, and punctuation on which Excel

Exercise 1-9: Making Simple Data EntriesComplete the data entry for the simple Spring Sale table shown in Figure 1-1 by doingthe following:1. Enter th