Understanding the Excel Interface

Understanding the Excel Interface

Identifying Parts of the Screen

The Excel window is illustrated in Figure 1-4. The bulk of the screen is occupied by the worksheet window. This grid provides a convenient workspace where you can enter and manage your data. Surrounding the worksheet window are several command interfaces, each of which allows you to receive information about, or apply functions to, the data on the worksheet.

For instructor-led Excel training class in Los Angeles call us on (888) 815-0604.

The Parts of the Excel Window

Worksheet control buttons The worksheet control buttons allow you to minimize, maximize/restore, or close the worksheet.
Formula bar The formula bar allows you to enter and edit data in the worksheet.
Worksheet window The worksheet window contains the open, active worksheet. Worksheet windows can be moved and sized. You can have more than one worksheet window open at the same time.
Scroll bars The vertical and horizontal scroll bars enable you to move quickly through the worksheet, vertically and horizontally.
Ribbon The Ribbon is designed to help you quickly find the commands that you need to complete a task. Commands are organized in logical groups, which are collected together under tabs. Each tab relates to a type of activity, such as writing or laying out a page. To reduce clutter, some tabs are shown only when needed.
Title bar (extreme top right of the Excel window) The title bar contains the name of the application and the active file.
File Button Clicking on the File Button displays a drop down menu containing a number of options, such as open, save, and print.
The options in the File Button menu are very similar to options found under the Office Button and File menu in previous versions of Excel.
Sheet tabs (Worksheet tabs) The sheet tabs let you switch between worksheets in a workbook by clicking the appropriate tab.
Quick Access Toolbar The Quick Access Toolbar (see Figure 1-5) is a customizable toolbar that contains a set of commands that are independent of the tab that is currently displayed. You can move the Quick Access Toolbar from one of the two possible locations, and you can add buttons that represent commands to the Quick Access Toolbar.
The Ribbon

The Ribbon is the strip of buttons and icons, organised into TABS, located above the work area in Excel 2013. The Ribbon (with its various tabs) replaces the menus and toolbars found in earlier versions of Excel. At the top of the actual Ribbon are a number of tabs, such as Home, Insert, and Page Layout. Clicking on a tab displays the options located in this section of the ribbon.

For example, when Excel 2013 opens, the options under the Home tab are displayed (see image to the right). These options are grouped according to their function - such as Clipboard (includes cut, copy, and paste options), and Font (includes current font, font size, bold, italic, and underline options).

Clicking o n an option on the ribbon may lead to further options contained in a Contextual Menu that relate specifically to the option chosen.

Although, as written in the label for Figure 1-4, tab sections can be referred to as [tab name] ribbon, like Home Ribbon, Insert Ribbon, etc, tab sections can also be referred to as only their tab names. Eg. the Home tab, the Insert tab, the Page Layout tab, etc.

 

Group Excel training

Through our network of local trainers we deliver onsite group Excel training right across the country. View our testimonials or obtain a quote for a customized Excel class.