{"id":44,"date":"2023-12-09T09:11:25","date_gmt":"2023-12-09T09:11:25","guid":{"rendered":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-1-an-overview-of-microsoft-excel\/"},"modified":"2024-09-18T00:51:36","modified_gmt":"2024-09-18T00:51:36","slug":"chapter-1-an-overview-of-microsoft-excel","status":"publish","type":"chapter","link":"https:\/\/openbook.ums.edu.my\/excelforabsolutebeginners\/chapter\/chapter-1-an-overview-of-microsoft-excel\/","title":{"raw":"Chapter 1: An Overview","rendered":"Chapter 1: An Overview"},"content":{"raw":"
\r\n
\r\n

Learning Objectives<\/h4>\r\n<\/header>\r\n
\r\n
    \r\n \t
  1. Create a workbook.<\/li>\r\n \t
  2. Identify a cell reference.<\/li>\r\n \t
  3. Add and edit content.<\/li>\r\n \t
  4. Save a workbook.<\/li>\r\n<\/ol>\r\n<\/div>\r\n<\/div>\r\n

    Microsoft Excel, or simply Excel is an [pb_glossary id=\"156\"]application software[\/pb_glossary] within the Microsoft 365 suite. You can buy the [pb_glossary id=\"158\"]Microsoft 365[\/pb_glossary] suite with a yearly or monthly subscription. Excel is known for its ability to perform numerical calculations and create charts. Other uses of Excel include organising data, manipulating text, and creating graphical dashboards, to name a few. The meaningful information produced by Excel can be used to make both personal and business decision makings. You can use Excel to record your expenses, to make a budget, or to calculate how much you should save for your retirement days. Businesses can use Excel to calculate total sales, keep track of product stocks, and produce profit and loss statements.<\/p>\r\n

    This is an Excel logo from 2019 until the Microsoft 365 version.<\/p>\r\n

    \"image\"<\/p>\r\n

    Let\u2019s get started.<\/p>\r\n

    Click an Excel button on your computer to launch the application. The first screen you get when you open Excel is called a start screen.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1377\"]\"image\" Figure 1.1 An Excel start screen.[\/caption]\r\n

    An Excel file is called a [pb_glossary id=\"160\"]workbook[\/pb_glossary], with the file extension, .xlsx.<\/p>\r\n

    Click \u2018Blank Workbook\u2019 to create a workbook.<\/p>\r\n

    When you create a blank workbook, Excel presents you with a blank [pb_glossary id=\"162\"]worksheet[\/pb_glossary]. You can have many worksheets inside one workbook. A worksheet is made up of [pb_glossary id=\"164\"]columns[\/pb_glossary], which are positioned vertically, and [pb_glossary id=\"166\"]rows[\/pb_glossary], which are placed horizontally. The columns are indicated by letters at the top of each column as A, B, C, etc. called column headings. The rows are indicated by the numbers of each row at the left as 1, 2, 3, etc. called row headings. The intersection between a column and a row defines a [pb_glossary id=\"168\"]cell[\/pb_glossary] and its location. The location of a cell is referred to as a cell address or a cell reference. For example, if column G intersects with row 5, the cell reference is G5.<\/p>\r\n

    Excel will assign a default file name to the blank workbook such as Book1 in the Title Bar, in which later you need to save it in your hard drive using your preferred file name. The default name for the worksheet is Sheet1<\/em> as shown in the Worksheet Tab, in which later you can rename it, or even add more worksheets in the same workbook.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1382\"]\"image\" Figure 1.2 The intersection between a column and a row is a cell.[\/caption]\r\n

    The dark outline indicates the currently selected cell in a worksheet is called an [pb_glossary id=\"170\"]active cell[\/pb_glossary]. Only one cell is active at a time. Once you click any cell to make it active, its cell reference appears in the Name Box. For example, if the active cell is cell A1, thus A1 is displayed in the Name Box.<\/p>\r\n

    You can observe that the mouse pointer turns into a white plus sign. This is the default mouse pointer shape that allows you to select a single cell by clicking on it. Excel has other mouse pointer shapes that change according to a specific task which you may find later as you with more features.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1201\"]\"image\" Figure 1.3 An active cell is indicated by the dark outline.[\/caption]\r\n

    An active cell is ready to accept any content when you begin typing.<\/p>\r\n

    Let\u2019s type some contents in the worksheet.<\/p>\r\n

    Click cell A1 to make it an active cell. Type Month in cell A1. Once you type content in the cell, you can see that the content appears in the cell, as well as in the Formula Bar.<\/p>\r\n

    You can also observe the blinking vertical line in the cell. This is an Edit Cursor; some refer to it as the I-Beam. It indicates the current insertion point within a cell that allows you to enter or edit text directly into the current cell. You can use the Edit Cursor to type or modify the contents of a cell such as text or formula.<\/p>\r\n

    See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"attachment_43\" align=\"alignnone\" width=\"740\"]\"\" Figure 1.4 Type Month in cell A1.[\/caption]\r\n

    If you make a mistake at this point, just press Backspace, and retype the correct word. Then, press Enter to save the content in cell A1.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.5 Content is saved in the cell after pressing Enter.[\/caption]\r\n

    If you make a mistake after the content is saved in the cell, you can edit the cell content by using one of the following ways:<\/p>\r\n\r\n

      \r\n \t
    1. Double-click the cell to edit the content directly in the cell.<\/li>\r\n \t
    2. Select the cell and press F2 to edit the content directly in the cell.<\/li>\r\n \t
    3. Select the cell that you want to edit and then click inside the Formula Bar to edit the content in the Formula Bar.<\/li>\r\n \t
    4. Click the cell to make it active and type the new content to replace the previous content.<\/li>\r\n<\/ol>\r\n

      Now, type the following contents in their respective contents as shown in the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.6 Type these contents in their respective cells.[\/caption]\r\n

      Let\u2019s Bold the content in cell A1.<\/p>\r\n

      Click cell A1 to make it an active cell. Click the Home Tab to open the Home [pb_glossary id=\"172\"]Ribbon[\/pb_glossary]. On the Home Ribbon, find the Bold button which is in the Font group. Click the Bold button.<\/p>\r\n

      See the Figures below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1378\"]\"image\" Figure 1.7 Bold the content in cell A1.[\/caption]\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.8 The content in cell A1 is bold.[\/caption]\r\n

      Now, let\u2019s centre the content in cell A1. Make sure cell A1 is an active cell. On the Home Ribbon, find the Centre button which is in the Alignment group. Click the Centre button.<\/p>\r\n

      See the Figures below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.9 Centre the content in cell A1.[\/caption]\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.10 The content in cell A1 is centred.[\/caption]\r\n

      Let\u2019s add more content. Bold and centre only the content in cell B1.<\/p>\r\n

      See the Figure below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.11 Type all contents as shown above.[\/caption]\r\n

      Now it\u2019s time to save your work to a file on your hard drive.<\/p>\r\n

      To save your work, click the Save button on the Quick Access Toolbar. Excel then gives you a Dialog Box to type a new file name and choose your preferred location. Then, click the Save button. The new file name should appear in the Title Bar.<\/p>\r\n

      See the Figures below.<\/p>\r\n\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.12 Click the Save button.[\/caption]\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1377\"]\"image\" Figure 1.13 In the Dialog Box; type a file name, choose a location, then click the Save button.[\/caption]\r\n\r\n[caption id=\"\" align=\"alignnone\" width=\"1379\"]\"image\" Figure 1.14 The new file name should appear in the Title Bar.[\/caption]\r\n

      That's all for this Chapter.<\/p>\r\n

      You're awesome!<\/p>\r\n

      <\/p>\r\n\r\n<\/div>","rendered":"

      \n
      \n
      \n

      Learning Objectives<\/h4>\n<\/header>\n
      \n
        \n
      1. Create a workbook.<\/li>\n
      2. Identify a cell reference.<\/li>\n
      3. Add and edit content.<\/li>\n
      4. Save a workbook.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n

        Microsoft Excel, or simply Excel is an application software<\/a> within the Microsoft 365 suite. You can buy the Microsoft 365<\/a> suite with a yearly or monthly subscription. Excel is known for its ability to perform numerical calculations and create charts. Other uses of Excel include organising data, manipulating text, and creating graphical dashboards, to name a few. The meaningful information produced by Excel can be used to make both personal and business decision makings. You can use Excel to record your expenses, to make a budget, or to calculate how much you should save for your retirement days. Businesses can use Excel to calculate total sales, keep track of product stocks, and produce profit and loss statements.<\/p>\n

        This is an Excel logo from 2019 until the Microsoft 365 version.<\/p>\n

        \"image\"<\/p>\n

        Let\u2019s get started.<\/p>\n

        Click an Excel button on your computer to launch the application. The first screen you get when you open Excel is called a start screen.<\/p>\n

        See the Figure below.<\/p>\n

        \"image\"
        Figure 1.1 An Excel start screen.<\/figcaption><\/figure>\n

        An Excel file is called a workbook<\/a>, with the file extension, .xlsx.<\/p>\n

        Click \u2018Blank Workbook\u2019 to create a workbook.<\/p>\n

        When you create a blank workbook, Excel presents you with a blank worksheet<\/a>. You can have many worksheets inside one workbook. A worksheet is made up of columns<\/a>, which are positioned vertically, and rows<\/a>, which are placed horizontally. The columns are indicated by letters at the top of each column as A, B, C, etc. called column headings. The rows are indicated by the numbers of each row at the left as 1, 2, 3, etc. called row headings. The intersection between a column and a row defines a cell<\/a> and its location. The location of a cell is referred to as a cell address or a cell reference. For example, if column G intersects with row 5, the cell reference is G5.<\/p>\n

        Excel will assign a default file name to the blank workbook such as Book1 in the Title Bar, in which later you need to save it in your hard drive using your preferred file name. The default name for the worksheet is Sheet1<\/em> as shown in the Worksheet Tab, in which later you can rename it, or even add more worksheets in the same workbook.<\/p>\n

        See the Figure below.<\/p>\n

        \"image\"
        Figure 1.2 The intersection between a column and a row is a cell.<\/figcaption><\/figure>\n

        The dark outline indicates the currently selected cell in a worksheet is called an active cell<\/a>. Only one cell is active at a time. Once you click any cell to make it active, its cell reference appears in the Name Box. For example, if the active cell is cell A1, thus A1 is displayed in the Name Box.<\/p>\n

        You can observe that the mouse pointer turns into a white plus sign. This is the default mouse pointer shape that allows you to select a single cell by clicking on it. Excel has other mouse pointer shapes that change according to a specific task which you may find later as you with more features.<\/p>\n

        See the Figure below.<\/p>\n

        \"image\"
        Figure 1.3 An active cell is indicated by the dark outline.<\/figcaption><\/figure>\n

        An active cell is ready to accept any content when you begin typing.<\/p>\n

        Let\u2019s type some contents in the worksheet.<\/p>\n

        Click cell A1 to make it an active cell. Type Month in cell A1. Once you type content in the cell, you can see that the content appears in the cell, as well as in the Formula Bar.<\/p>\n

        You can also observe the blinking vertical line in the cell. This is an Edit Cursor; some refer to it as the I-Beam. It indicates the current insertion point within a cell that allows you to enter or edit text directly into the current cell. You can use the Edit Cursor to type or modify the contents of a cell such as text or formula.<\/p>\n

        See the Figure below.<\/p>\n

        \"\"
        Figure 1.4 Type Month in cell A1.<\/figcaption><\/figure>\n

        If you make a mistake at this point, just press Backspace, and retype the correct word. Then, press Enter to save the content in cell A1.<\/p>\n

        \"image\"
        Figure 1.5 Content is saved in the cell after pressing Enter.<\/figcaption><\/figure>\n

        If you make a mistake after the content is saved in the cell, you can edit the cell content by using one of the following ways:<\/p>\n

          \n
        1. Double-click the cell to edit the content directly in the cell.<\/li>\n
        2. Select the cell and press F2 to edit the content directly in the cell.<\/li>\n
        3. Select the cell that you want to edit and then click inside the Formula Bar to edit the content in the Formula Bar.<\/li>\n
        4. Click the cell to make it active and type the new content to replace the previous content.<\/li>\n<\/ol>\n

          Now, type the following contents in their respective contents as shown in the Figure below.<\/p>\n

          \"image\"
          Figure 1.6 Type these contents in their respective cells.<\/figcaption><\/figure>\n

          Let\u2019s Bold the content in cell A1.<\/p>\n

          Click cell A1 to make it an active cell. Click the Home Tab to open the Home Ribbon<\/a>. On the Home Ribbon, find the Bold button which is in the Font group. Click the Bold button.<\/p>\n

          See the Figures below.<\/p>\n

          \"image\"
          Figure 1.7 Bold the content in cell A1.<\/figcaption><\/figure>\n
          \"image\"
          Figure 1.8 The content in cell A1 is bold.<\/figcaption><\/figure>\n

          Now, let\u2019s centre the content in cell A1. Make sure cell A1 is an active cell. On the Home Ribbon, find the Centre button which is in the Alignment group. Click the Centre button.<\/p>\n

          See the Figures below.<\/p>\n

          \"image\"
          Figure 1.9 Centre the content in cell A1.<\/figcaption><\/figure>\n
          \"image\"
          Figure 1.10 The content in cell A1 is centred.<\/figcaption><\/figure>\n

          Let\u2019s add more content. Bold and centre only the content in cell B1.<\/p>\n

          See the Figure below.<\/p>\n

          \"image\"
          Figure 1.11 Type all contents as shown above.<\/figcaption><\/figure>\n

          Now it\u2019s time to save your work to a file on your hard drive.<\/p>\n

          To save your work, click the Save button on the Quick Access Toolbar. Excel then gives you a Dialog Box to type a new file name and choose your preferred location. Then, click the Save button. The new file name should appear in the Title Bar.<\/p>\n

          See the Figures below.<\/p>\n

          \"image\"
          Figure 1.12 Click the Save button.<\/figcaption><\/figure>\n
          \"image\"
          Figure 1.13 In the Dialog Box; type a file name, choose a location, then click the Save button.<\/figcaption><\/figure>\n
          \"image\"
          Figure 1.14 The new file name should appear in the Title Bar.<\/figcaption><\/figure>\n

          That’s all for this Chapter.<\/p>\n

          You’re awesome!<\/p>\n

          \n<\/div>\n

          definition<\/span>