Excel 2016 Introduction

Excel 2016

Lesson – Exploring Excel

At the left end of the row below the Ribbon is the Name Box , which displays the name of the Active Cell . To the right of the Name Box is the Insert Function button, which lets you access Excel’s extensive range of built-in functions when creating formulas. To the right of the Insert Function button is the Formula Bar in which you can view and edit the data in the Active Cell .

Excel opens with a new, blank Workbook window containing one Worksheet displayed in the work area. The Workbook window is maximized within the Excel Application Window . The Minimize Window , Restore Window/Maximize, and Close Window buttons for the Workbook window are on the far right of the Ribbon . At the bottom of the Workbook window, there are Tabs for each Worksheet , together with a button for inserting more worksheets. To the left of the Worksheet Tabs , are buttons for scrolling the tabs.

Each Worksheet is divided into columns and rows to provide millions of Cells in which you can enter text, numbers or formulas. At the right and bottom of each Worksheet, scroll bars are provided for viewing other areas of the worksheet.

The Status Bar appears at the bottom of the application window. At the left end of the Status Bar a Cell Mode indicator is displayed. Towards the right-hand side of the Status Bar, three View Shortcut buttons are provided for switching between Normal , Page Layout and Page Break Preview views of the worksheet. At the far right of the Status Bar are the Zoom Slider and the Zoom Level button. Additional information appears on the Status Bar as you perform certain types of actions. The Status Bar is customizable, letting you control the information displayed.

Many of the objects in the Excel window (such as buttons on the Ribbon) display brief descriptions called ScreenTips that pop up whenever you point to the objects.

Several Workbooks can be open within the Excel Application Window at the same time. By default, each Workbook is maximized within the Application Window. You can switch between the open Workbooks either by using a button on the View tab or by clicking its icon on the Windows Taskbar . Alternatively, you can click the Restore Window button at the far right of the Ribbon to display the Workbooks as resizable windows and arrange them as desired within the Application Window.

OFFICEPRO, Inc.

Page 5