Wiley 978-0-471-94002-9 Datasheet

Chapter 1 Navigating in Excel and Understanding the Interface MOS SPECIALIST OBJECTIVES COVERED IN THIS CHAPTER: Enter and edit cell content Naviga

10Chapter 1Navigating in Excel and Understanding the InterfaceMoving Around in Worksheets Moving from sheet to sheet is fairly straightforward; howev

Navigating in Excel11It is important to note that if you click into a cell beyond the data area and just put one space in that cell, or enter data in

12Chapter 1Navigating in Excel and Understanding the InterfaceExcel has many keyboard shortcuts, and it is not possible to show you all of them. How

Adding and Editing Data in a Workbook13FIGURE 1.4 Cells can contain labels or values.EXERCISE 1.4 Adding Data to a Worksheet1. Open the file Exercise

14Chapter 1Navigating in Excel and Understanding the InterfaceOnce data is in a worksheet, there are various ways to modify that data at a later time

Adding and Editing Data in a Workbook15To the right of the Undo button is a small downward-pointing dropdown arrow. Click this arrow to open a list of

16Chapter 1Navigating in Excel and Understanding the InterfaceManaging CellsBecause all cells in a column must be the same width and all cells in a r

Adding and Editing Data in a Workbook17Managing Rows and ColumnsManaging rows and columns involves everything from changing their size to accommodate

18Chapter 1Navigating in Excel and Understanding the InterfaceIf numbers are too wide for a column, Excel will replace the digits with # signs if the

Adding and Editing Data in a Workbook19In Exercise 1.8, we’ll explore an alternative method for resizing the columns and rows pre-cisely, using the me

You know you’re really old if you remember the paper spread-sheets that companies used to use to do their number crunching. The look of Microsoft Exc

20Chapter 1Navigating in Excel and Understanding the InterfaceAdding and Deleting Rows and ColumnsSometimes you just need a little more information:

Adding and Editing Data in a Workbook21As I’m sure you’re aware, if you want to delete all the data in a column or row but leave the empty column or r

22Chapter 1Navigating in Excel and Understanding the InterfaceIf you accidentally drag to select multiple cells using the wrong mouse pointer, cells

Adding and Editing Data in a Workbook23Be aware that many of the actions performed in the exercises in this section cannot be undone by simply clickin

24Chapter 1Navigating in Excel and Understanding the InterfaceOnce the worksheets have self-explanatory names and are categorized by color, the next

Adding and Editing Data in a Workbook253. Your sheets should now be in order, beginning with January and ending with March.4. Click the February Sales

26Chapter 1Navigating in Excel and Understanding the InterfaceDeleting and Hiding WorksheetsAs with rows and columns, sometimes you want to remove sh

Adding and Editing Data in a Workbook27Alternatively, sometimes you don’t want to permanently delete the sheet but instead just want it out of view te

28Chapter 1Navigating in Excel and Understanding the Interfaceyou to the dropdown box where you can choose different file format types when saving. B

Moving and Copying Data29An even quicker way to close your file and close Excel is to click the X on the far-right end of your menu bar to close the f

Understanding Excel’s Interface 3 your screen will say Microsoft Excel – Book1. Book1 is the name temporarily assigned to a new workbook before you

30Chapter 1Navigating in Excel and Understanding the InterfaceEXERCISE 1.15 Methods of Copying and Pasting1. Open Excel and select File  Open. Brows

Moving and Copying Data31Cut and PasteExcel also offers different ways to cut and paste both single cells and ranges of cells. When you select multipl

32Chapter 1Navigating in Excel and Understanding the InterfaceSelecting Contiguous and Noncontiguous RangesNow that you know how to cut, copy, and pa

Moving and Copying Data33other formatting attached to the cells. Column widths must be pasted separately. After you have pasted the data, you will hav

34Chapter 1Navigating in Excel and Understanding the InterfaceSelecting contiguous ranges is fairly straightforward. However, to select noncontiguous

Moving and Copying Data353. Now try to copy that selection. You see this error message:4. Click OK to clear the message. 5. You cannot copy noncontigu

36Chapter 1Navigating in Excel and Understanding the InterfaceUsing the Office ClipboardThe Windows Clipboard is rather limited; it holds only the la

Moving and Copying Data374. Move to the January Sales sheet. Use one of the methods you learned earlier to get into Edit mode in cell A1 and change th

38Chapter 1Navigating in Excel and Understanding the InterfaceUsing the Mouse to Drag and Drop or Fill DataUp to this point, you have used three diff

Moving and Copying Data39FIGURE 1.9 Mouse pointers can make a big difference in Excel.It’s definitely easier to understand these pointers in action, s

4 Chapter 1 Navigating in Excel and Understanding the Interface FIGURE 1.1 The Five Bars at the Top of the Screen The toolbars include tooltips, w

40Chapter 1Navigating in Excel and Understanding the Interface8. Select cell A1 again and, without holding the mouse button down, move your pointer o

Summary41There are many ways to use Auto Fill, and more of them are explained in Chapter 4, “Editing Tools, Comments, and Hyperlinks.”SummaryUnderstan

42Chapter 1Navigating in Excel and Understanding the InterfaceExam EssentialsKnow the terminology. Get familiar with the terms used in Excel so the M

Sample MOS Scenarios43 MOS Scenario 2: Add Worksheets and Find DataRename the worksheet to March 2005, then add two more sheets and name them March 20

4002book.fm Page 44 Friday, March 24, 2006 11:36 PM

Understanding Excel’s Interface 5 You can drag toolbars to the sides and bottom of your screen as well. If a tool-bar is docked on the side of the sc

6 Chapter 1 Navigating in Excel and Understanding the Interface At the top of the task pane is a title bar that shows the name of the task pane you

Understanding Excel’s Interface 7 When you are not using the task pane, you can click the X in the upper-right corner to close it and have more room

8 Chapter 1 Navigating in Excel and Understanding the Interface FIGURE 1.2 Sheet tabs allow you to quickly move from sheet to sheet. When you have a

Navigating in Excel9FIGURE 1.3 The Name box displays the cell address of the active cell.The lines you see defining the cells are called gridlines. Th