Page 66 - Code & Click - 5

Quick Access Toolbar

The Quick Access Toolbar, present on the top-left corner of the Excel window, provides
shortcuts for commonly used commands.

Ribbon
The Ribbon, present below the Title bar, contains various commands for working with
a workbook. It is divided into various Tabs and groups.
The Tabs present on Excel 2016 Ribbon are – File, Home, Insert, Page Layout, Formulas,
Data, Review, and View. Some Tabs are context sensitive which appear when a specific
task is performed.

Tabs

Groups

File Tab
The File Tab is present below the Quick Access Toolbar. When clicked, it opens the
Backstage view. It displays information about the current workbook and provides
commands for various file activities, such as Open, Save, and Print.

Worksheet Area
The Worksheet area is present between the Ribbon and the Status bar. It has a tabular
structure made up of horizontal rows and vertical columns.

Worksheet Tab

The Worksheet Tab, present below the Worksheet area, displays all the worksheets in
a workbook. It also provides options to add more worksheets.

Rows Column headings
Rows are the arrangement of cells in
the horizontal direction. A worksheet in
Excel 2016 contains 1048576 rows. Rows are Row
numbered from top to bottom in ascending headings
order, starting from 1 to 1048576.

Columns
Columns are the arrangement of cells in the vertical direction. A worksheet in
Excel 2016 contains 16384 columns. Columns are labelled from left to right as A, B, C ...
to Z, then from AA to ZZ, and then from AAA to XFD.

Cell and Active Cell
A Cell is the smallest unit of a worksheet. It is formed by the intersection of a row and
a column. Each cell has a unique address, formed by a combination of its column label

64