Worksheet Properties


In this topic, we will identify the properties of an Excel worksheet


Steps:

  1. The Quick Access Toolbar is a customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed.  You may modify this toolbar by adding and or deleting commands on the toolbar.

     

    Step 1

  2. The Ribbon Bar displays the commands that are most relevant for each of the task areas in the application.

     

    Step 2

  3. Sizing Buttons are used to manipulate the size of the spreadsheet window.

     

    Step 3

  4. The Name Box displays the active cell.

    Step 4

  5. The Dialog Launcher appears in the lower right corner of a Group, providing access to the Group's corresponding dialog box.

    Step 5

  6. The Formula Bar displays the data in the active cell

     

    Step 6
  7. Worksheet Tabs are ledger sheets.  You can rename these sheets using up to 31 characters.

     

    Step 7

  8. The New Worksheet Tab allows you to add worksheets to your workbook.

    Step 8

  9. The Status Bar displays the current settings and commands in Excel.  Also, when two or more cells are selected, and one or more contains a value, the status bar displays a total for the selected cells.

    Step 9

  10. The View Control allows you to view your worksheet in normal, layout, and page break views.

    Step 10

  11. The Zoom Control will allow you to magnify your spreadsheet.   Click and drag the slider to the right to increase magnification or to the left to decrease the magnification.

    Step 11

After completing this topic, you are able to identify the properties of an Excel worksheet.