Microsoft Office Tutorials and References
In Depth Information
Excel’s Ribbon User Interface
✓ Customizable Quick Access toolbar that contains buttons you can click
to perform common tasks, such as saving your work and undoing and
redoing edits. This toolbar is preceded by an Excel program button
(sporting the Excel 2013 icon) with a drop-down menu of options that
enable you to control the size and position of the Excel window and
even close (exit) the program.
✓ Ribbon that contains the bulk of the Excel commands arranged into a
series of tabs ranging from Home through View.
✓ Formula bar that displays the address of the current cell along with the
contents of that cell.
✓ Worksheet area that contains the cells of the worksheet identified by
column headings using letters along the top and row headings using
numbers along the left edge; tabs for selecting new worksheets; a
horizontal scroll bar to move left and right through the sheet; and a vertical
scroll bar to move up and down through the sheet.
✓ Status bar that keeps you informed of the program’s current mode and
any special keys you engage and enables you to select a new worksheet
view and to zoom in and out on the worksheet.
To the immediate left of the Home tab on the Ribbon right below the Quick
Access toolbar, you find the File button.
When you select File, the Backstage view opens. This view contains a menu
similar to the one shown in Figure 1-3. When you open the Backstage view
with the Info option selected, Excel displays at-a-glance stats about the
workbook file you have open and active in the program.
This information panel is divided into two panes. The pane on the left
contains large buttons that enable you to modify the workbook’s protection
status, check the document before publishing, and manage its versions. The
pane on the right contains a list of fields detailing the workbook’s various
Document Properties, some of which you can change (such as Title, Tags,
Categories, Author, and Last Modified By), and many of which you can’t
(such as Size, Last Modified, Created, and so forth).
Below the Info option, you find the commands (New, Open, Save, Save As,
Print, Share, Export, and Close) you commonly need for working with Excel
workbook files. Near the bottom, the File tab contains an Account option
that, when selected, displays an Account panel in the Backstage view. This
panel displays user, connection, and Microsoft Office account information.
Below the Account menu item, you find options that you can select to change
the program’s settings.