Understanding Workbooks in Microsoft Excel, How to Create, Functions, and Parts

Understanding Worksheets and Workbooks in Microsoft Excel

A. Definition of Workbook

Workbook is a standard format from Microsoft Excel that consists of 1 or more Worksheets. In an analogy, a Workbook is a book and a Worksheet is a sheet of paper in a book. So, it can be concluded that when you work for the first time using Microsoft Excel, what opens is a Workbook in which there are several worksheets that are used as a place to process data, graphs and so on.

B. Workbook Functions in Microsoft Excel and Its Parts

In the image below, you will see the appearance of the Workbook in Excel and the meaning of each component is provided in a list.

  1. Title Bar – Displays the name of the currently active or open Workbook. By default the workbook name in Microsoft Excel is “Book1”.
  2. Quick Access Toolbars – Has a function to display frequently used commands in Microsoft Excel, you can reduce or increase the commands displayed on the Quick Access Toolbar.
  3. Window Control – Serves to adjust the appearance of the Microsoft Excel window, namely; maximize, minimize, and close the Microsoft Excel window.
  4. Menu Bar – Is a collection of commands in Microsoft Excel. Each menu bar consists of a ribbon. The Ribbon is where commands are mostly equipped with a command icon or command button. Each command button has certain functions.
  5. Name Box (NameBox)Serves to display the index or name of the cell that is currently active.
  6. Formula Bar – Serves to provide formulas to cells that are currently active. You can also define numeric values ​​as well as text on the formula bar.
  7. Column (Column) – Serves to display the column names identified by the letters A-XFD. You can use CTRL + to go to the last column of Microsoft Excel 2016.
  8. line (Row) – Serves to display the index row in Microsoft Excel identified by the number 1-1048576. You can use CTRL + to go to the last row of Microsoft Excel 2016.
  9. Active Cell – The active cell means the cell that is pointed at the computer pointer and the cell index will be displayed in the Name Box.
  10. Worksheet Tabs – Functions to add and remove worksheets and select worksheets to be used on the worksheet.
  11. Excel worksheet – All cells displayed Workbook
  12. Horizontal Scroll Bar – Function to shift the worksheet to the right or left
  13. Vertical Scroll Bar – Function to change the view of the worksheet and reduce or enlarge the view of the worksheet.
  14. Page View – Function to change the view of the worksheet and reduce or enlarge the view of the worksheet
  15. Status Bar – Serves to display information related to the process that occurs as well as recommendations for moving orders that will be carried out by the user.

C. How to Create New Workbooks and Worksheets in Microsoft Excel

Here are some ways to create workbooks, worksheets and how to save them.

How to Create a New Workbook in Microsoft Excel

1. Click File on the Menu Bar

2. Click New, so a dialog window appears New Workbook

3.Click Blank Workbook

4. The new workbook has been created successfully

You can also use keyboard shortcuts to create a new workbook by pressing CTRL + N

How to Save a New Workbook in Microsoft Excel

1. Click File on the Menu Bar

2. Click Save so that the Save dialog appears

3. Click Browse so that the Save As window appears

4. Select the directory to save the Workbook

save workbook

5. Create a file name for the workbook that will be stored in the column Filename

6. Select the type of file in the column Save as type, Use type Excel Workbook (*.xlsx) to save in standard Microsoft Excel format

7.Click Save

8. Workbook saved successfully

How to Create a New Worksheet in Microsoft Excel

To create a new worksheet, click the + sign on the worksheet tab

Someone who has an aloof personality, without knowing the outside world only through the online world.

  • Facebook
  • WhatsApp
  • Instagram