Page 63 - TGPT_V5.0_C5_Flipbook
P. 63
Ribbon: It contains different tabs. The tabs are divided into groups. Groups have commands
tools and buttons.
File Tab: It contains commands such as New, Open, Save, Save As, Print and Close.
Status Bar: It shows the name of the selected command or status information. The warning
messages are also displayed here.
View Bar: It helps us view the worksheets in different modes—Normal View, Page Layout
View and Page Break Preview.
Sheet Tab: It shows the number of worksheets in a workbook and the Active Sheet.
Worksheet: It is divided into Rows and Columns. The rows are numbered as 1, 2, 3, 4….
as indicated by the Row Headers. The columns are labelled alphabetically as A, B, C, D…Z,
AA….AZ,…..XFD as indicated by the Column Headers. The total number of columns in Excel
is 16,384. The total number of rows is 1,048,576.
Rows and Columns: Columns are the vertical sections of the table whereas Rows are the
horizontal sections of the table.
Cell: The intersection of rows and columns is known as cell. It is the smallest unit in a
worksheet and can hold numbers, text or formula.
Active Cell: It is the cell that is currently selected. It can be recognised by its green outline.
You can type data into an active cell only.
Cell Address: It refers to the unique name of a cell, which is identified by the column letter
and row number (e.g., A1, B2). It helps locate and reference specific data in a worksheet.
Formula Bar: It displays the contents of the active cell. You can also type or edit data and
formulas in the formula bar.
Name Box: It displays address of the active cell. It is present on the left side of the formula bar.
Double Tap Century #Technology Literacy
21 st
#Critical Thinking
Skills
Match the following:
1. Row header a. Address of the active cell
2. Column header b. Displays content of active cell
3. Sheet tab c. Row numbers
4. Name box d. Column numbers
5. Formula bar e. Displays number of sheets in worksheet
Introduction to Excel 2021 61

