Page 297 - TP_IT_V1.0_C9_flipbpookl
P. 297
• Formula Bar: It is the most important bar in a spreadsheet and is used for entering and editing a formula.
Name Box Select Funtion Input Line
Formula
Function Wizard
It contains different options explained as follows:
w Name Box: It displays the name or reference of an active cell or a selected cell range.
w Function Wizard: It is used to insert functions through interactive step-by-step processes.
w Sum: It is used to insert a sum function directly for the currently selected cell range.
w Function: It adds a formula to the current cell. By clicking on the Function icon inserts an equals (=) sign into the
selected cell and the Input line allows formula to be entered.
w Input Line: It is used to enter a formula that needs to be applied in the current cell or selected cell range. It also
displays the contents of the selected cell (i.e., data, formula, or function) and allows editing of the cell contents.
To edit inside the Input line area, click in the area, then type the changes. To edit within the current cell, just
double-click in the cell.
Spreadsheet
The sheet in Calc is also referred to as spreadsheet. The spreadsheet can have many sheets. Each sheet can have many
individual cells arranged in rows and columns. The sheet tab shows its default name as Sheet1, Sheet2, Sheet3.
• Rows: Rows are accessed horizontally on a sheet and are identified by numbers 1, 2, 3, 4, and so on, written on the
left side of the sheet. Each sheet has a maximum of 1,048,576 (2 ) rows.
20
• Columns: Columns are accessed vertically on a sheet and are identified by alphabets A, B, C, …, Z, AA, AB, AC, …., AZ,
14)
BA to BZ, CA, to CZ, and so on, written on the top of each sheet. Each sheet has a maximum of 16384 (2 columns,
i.e., from A to XFD.
• Cell: The intersection of a row and column is called a cell. Each cell in a spreadsheet is referred to by an address
which is formed by a combination of the column alphabet first and the row number later. For example, the D5
th
address refers to a cell formed by the intersection of the D column and the 5 row. A cell can have any data like text,
numbers, formulas, etc.
Write the cell address of:
uiz Bee • 12th row and 10th column
• 10th row and 16th column
• 26th row and 31th column
• 15th row and 39th column
• Active Cell: In a spreadsheet, the cell is the place where we enter the data. Before entering any data in the cell, it
has to be first selected by placing a cursor on it. When we position the mouse cursor on a cell, it gets selected, and
is ready to take data from the user. The currently selected cell is called an active cell. The address of the active cell
is displayed in the name box and is always highlighted with a black thick border.
Electronic Spreadsheet 295

