Page 69 - PlusGPT_V2.1_C7_Flipbook
P. 69
Formula Bar: It is used to enter and edit formulas in a cell and perform calculations on your worksheet
data. It is also used for entering and editing the contents of a cell.
Name Box: The address of the active cell is displayed in this box.
Worksheet Window: It is a single page in Excel also called spreadsheet.
Status Bar: The horizontal bar at the bottom that shows information about the file in which you are
working. The right section of the status bar has view control buttons for the spreadsheet.
Row: The horizontal divisions on a worksheet are called rows. There are 10,48,576 rows in an Excel
worksheet. Each row is represented by a number such as 1, 2, 3, and so on.
Column: The vertical divisions on a worksheet are called columns. There are 16,384 columns in an
Excel worksheet. Each column is represented with alphabetic value such as A, B, C and so on.
Row and Column Heading Buttons: Work area is divided into rows and columns.
The rows are reffered using numbers and columns using the alphabets. The row headings range from
1 to 10,48,576 and column headings range from A to XFD.
Cell: The intersection of a row and a column is called a cell. A cell in Excel worksheet looks like a
rectangular box.
Active Cell: A cell is formed by the intersection of a row and a column. The currently selected cell that
appears highlighted with green border is an active cell. The data we type is entered in an active cell.
Mouse Pointer: The mouse pointer is displayed as a block plus sign ( ), whenever it is located in a
cell on the worksheet. Another common shape of the mouse pointer is the block arrow.
Worksheet Tab: There can be more than one worksheet in Excel workbook and each has a specific
name. Any worksheet can be activated by clicking on its name in worksheet tab.
Worksheet Tab Scrolling Buttons: These are arranged on the left side of the worksheet tab. These
are used to display the worksheet tabs which are invisible. The tab is clicked to make a worksheet
active.
Workbook: A workbook is a collection of different worksheets. By default, a workbook contains
one worksheet i.e., Sheet1, that can be increased or decreased as per the requirement.
Ribbon: Microsoft Excel ribbon is the row of tabs and icons at the top of the Excel window that allows
you to quickly find, understand and use commands for completing a certain task.
CREATING A NEW WORKBOOK
You can create a new workbook any time by following these steps:
Step 1: Click on File tab.
Backstage view will appear.
Step 2: Click on the New option.
Step 3: Click on Blank workbook option in the Available Templates list.
The new workbook file will open and you can start adding your own data.
Introduction to Excel 2016 67

