Learn about Ms Excel Workbook Layout: Menubar, Formula Bar, Function Bar
Layout defines the page view of the worksheet file. Layout of the excel is structured in the following format.
Customize Access Toolbar:
Customizable Access Toolbar is located at the top left corner of the workbook. By default, customize access toolbar have the shortcut for Save, Undo and Redo option. Click on the drop down menu near to redo to select other shortcuts.
Once you open new workbook in excel, it will be created with the name "Book1 - Excel" as shown in the below image.
Title Bar Buttons:
Title bar buttons are present at the top right corner of the excel file. Buttons included in the title bar are Ribbon Display options, Minimize button, Maximize button and Close button.
Menu bar is located at the top of the workbook. It contains the following tabs like File, Home, Insert, Page layout, Formula, Data, Review and View.
Name box will show the cell reference of the selected cell.
Function bar is prefixed with the symbol "fx". Click the symbol fx to list all the predefined functions in ms excel 2013.
Formula bar is used to enter/edit the formulas. Formula bar displays the data entered in the active cell. All formulas starts with "=" sign.
Worksheet is the collection of cells where data is entered and stored.
Footer layout is present at the bottom of the workbook. You can view the page layout of the workbook using Normal, Page Layout and Page Break Preview options. You can also zoom the workbook by adjusting the pointer over the slide bar.