{"id":64,"date":"2016-09-27T17:23:29","date_gmt":"2016-09-27T17:23:29","guid":{"rendered":"https:\/\/pressbooks.usnh.edu\/math502\/chapter\/entering-editing-and-managing-data\/"},"modified":"2023-03-24T14:25:35","modified_gmt":"2023-03-24T14:25:35","slug":"entering-editing-and-managing-data","status":"publish","type":"chapter","link":"https:\/\/pressbooks.usnh.edu\/mth402\/chapter\/entering-editing-and-managing-data\/","title":{"raw":"Entering, Editing, and Managing Data","rendered":"Entering, Editing, and Managing Data"},"content":{"raw":"
\n

Learning Objectives<\/h3>\n
    \n \t
  1. Understand how to enter data into a worksheet.<\/li>\n \t
  2. Examine how to edit data in a worksheet.<\/li>\n \t
  3. Examine how Auto Fill is used when entering data.<\/li>\n \t
  4. Understand how to delete data from a worksheet and use the Undo command.<\/li>\n \t
  5. Examine how to adjust column widths and row heights in a worksheet.<\/li>\n \t
  6. Understand how to hide columns and rows in a worksheet.<\/li>\n \t
  7. Examine how to insert columns and rows into a worksheet.<\/li>\n \t
  8. Understand how to delete columns and rows from a worksheet.<\/li>\n \t
  9. Learn how to move data to different locations in a worksheet.<\/li>\n<\/ol>\n<\/div>\nIn this section, we will begin the development of the workbook shown in\u00a0Figure 1.1<\/strong>. The skills covered in this section are typically used in the early stages of developing one or more worksheets in a workbook.\n

    Entering Data<\/h2>\nYou will begin building the workbook shown in\u00a0Figure 1.1<\/strong> by manually entering data into the worksheet. The following steps explain how the column headings in Row 2 are typed into the worksheet:\n
      \n \t
    1. Click cell location A2 on the worksheet.<\/li>\n \t
    2. Type the word\u00a0Month<\/strong>.<\/li>\n \t
    3. Press the RIGHT ARROW key. This will enter the word into cell A2 and activate the next cell to the right.<\/li>\n \t
    4. Type\u00a0Unit Sales<\/strong>\u00a0and press the RIGHT ARROW key.<\/li>\n \t
    5. Repeat step 4 for the words\u00a0Average Price<\/strong>\u00a0and\u00a0then again for Sales Dollars<\/strong>.<\/li>\n<\/ol>\nFigure 1.15<\/strong> shows how your worksheet should appear after you have typed the column headings into Row 2. Notice that the word\u00a0Price\u00a0<\/strong>in cell location C2 is not visible. This is because the column is too narrow to fit the entry you typed. We will examine formatting techniques to correct this problem in the next section.\n\n \n
      \n\n[caption id=\"\" align=\"aligncenter\" width=\"1496\"]\"Cell<\/a> Figure 1.15\u00a0Entering Column Headings into a Worksheet[\/caption]\n\n<\/div>\n
      \n

      Integrity Check<\/h3>\nColumn Headings<\/strong>\n\nIt is critical to include column headings that accurately describe the data in each column of a worksheet. In professional environments, you will likely be sharing Excel workbooks with coworkers. Good column headings reduce the chance of someone misinterpreting the data contained in a worksheet, which could lead to costly errors depending on your career.\n\n<\/div>\n
        \n \t
      1. Click cell location B3.<\/li>\n \t
      2. Type the number\u00a02670\u00a0<\/strong>and press the ENTER key. After you press the ENTER key, cell B4 will be activated. Using the ENTER key is an efficient way to enter data vertically down a column.<\/li>\n \t
      3. Enter the following numbers in cells B4 through B14:\u00a02160<\/strong>,\u00a0515,\u00a0590,\u00a01030,\u00a02875,\u00a02700,\u00a0900,\u00a0775,\u00a01180,\u00a01800<\/strong>, and\u00a03560<\/strong>.<\/li>\n \t
      4. Click cell location C3.<\/li>\n \t
      5. Type the number\u00a09.99<\/strong>\u00a0and press the ENTER key.<\/li>\n \t
      6. Enter\u00a0the following numbers in cells C4 through C14:\u00a012.49,\u00a014.99,\u00a017.49,\u00a014.99,\u00a012.49,\u00a09.99,\u00a019.99,\u00a019.99,\u00a019.99,\u00a017.49<\/strong>, and 14.99<\/strong>.<\/li>\n \t
      7. Activate cell location D3.<\/li>\n \t
      8. Type the number\u00a026685\u00a0and press the ENTER key.<\/li>\n \t
      9. Enter\u00a0the following numbers in cells D4 through D14:\u00a026937,\u00a07701,\u00a010269,\u00a015405,\u00a035916,\u00a026937,\u00a017958,\u00a015708,\u00a023562, 31416<\/strong>, and\u00a053370<\/strong>.<\/li>\n \t
      10. When finished, check that the data you entered matches\u00a0Figure 1.16<\/strong>.<\/li>\n<\/ol>\n
        \n

        Why?<\/h3>\nAvoid Formatting Symbols When Entering Numbers<\/strong>\n\nWhen typing numbers into an Excel worksheet, it is best to avoid adding any formatting symbols such as dollar signs and commas. Although Excel allows you to add these symbols while typing numbers, it slows down the process of entering data. It is more efficient to use Excel\u2019s formatting features to add these symbols to numbers after you type them into a worksheet.\n\n<\/div>\n
        \n

        Integrity Check<\/h3>\nData Entry<\/strong>\n\nIt is very important to proofread your worksheet carefully, especially when you have entered numbers. Transposing numbers when entering data manually into a worksheet is a common error. For example, the number 563<\/strong> could be transposed to 536.<\/strong> Such errors can seriously compromise the integrity of your workbook.\n\n<\/div>\n
        \n

        Integrity Check<\/h3>\nFigure 1.16<\/strong> shows how your worksheet should appear after entering the data. Check your numbers carefully to make sure they are accurately entered into the worksheet.\n\n[caption id=\"\" align=\"aligncenter\" width=\"570\"]\"Numbers<\/a> Figure 1.16 \u00a0Completed Data Entry for Columns B, C, and D[\/caption]\n\n<\/div>\n

        Editing Data<\/h2>\nData that has been entered in a cell can be changed by double clicking the cell location or using the\u00a0Formula\u00a0Bar. You may have noticed that as you were typing data into a cell location, the data you typed appeared in the Formula Bar. The Formula Bar can be used for entering data into cells as well as for editing data that already exists in a cell. The following steps provide an example of entering and then editing data that has been entered into a cell location:\n
          \n \t
        1. Click cell A15 in the Sheet1 worksheet.<\/li>\n \t
        2. Type the abbreviation\u00a0Tot\u00a0<\/strong>and press the ENTER key.<\/li>\n \t
        3. Click cell A15.<\/li>\n \t
        4. Move the mouse pointer up to the Formula Bar. You will see the pointer turn into a cursor. Move the cursor to the end of the abbreviation Tot<\/strong> and left click.<\/li>\n \t
        5. Type the letters\u00a0al\u00a0<\/strong>to complete the word\u00a0Total.<\/li>\n \t
        6. Click the checkmark to the left of the Formula Bar (see\u00a0Figure 1.17<\/strong>). This will enter the change into the cell.\n\n[caption id=\"\" align=\"aligncenter\" width=\"541\"]\"Checkmark<\/a> Figure 1.17\u00a0Using the Formula Bar to Edit and Enter Data[\/caption]\n\n <\/li>\n \t
        7. Double click cell A15.<\/li>\n \t
        8. Add a space after the word\u00a0Total\u00a0and type the word\u00a0Sales<\/strong>.<\/li>\n \t
        9. Press the ENTER key.<\/li>\n<\/ol>\n
          \n

          Keyboard Shortcuts<\/h3>\nEditing Data in a Cell<\/strong>\n