Page 263 - Computer - 9(A&B)

To Select the Entire Worksheet
Press Ctrl + A keyboard shortcut.
Or
Click Select All button at the top left corner of the worksheet.

Select All

Name the following.
1. A group of contiguous cells selected along with the active cell __________________
2. A toolbar that shows the icons for most common operations __________________
3. A box that displays the cell address of the active cell __________________

Session 2

Apply Formula and Functions in Spreadsheet

Before entering any data in a worksheet, it is required to select a cell. A cell can be selected by positioning the
pointer in it. The data to be entered can be the label, values or formula.

Types of Data
Three types of data can be entered in a Calc worksheet.
v Label: Label or Text data is a combination of letters, numbers and special characters. By default, text data
or label is left aligned in a cell.
v Values: The numerical data consisting of only numbers are called values. By default values are right
aligned. There are various forms of a values, such as integer, decimal and so on.
v Formula: We can create formulas in a Calc spreadsheet using cell values or cell references. The result of the
formula is right aligned by default. Any expression that begins with an equals ‘=’ is treated as formula. In
a formula, the ‘=’ is followed by values, cell address and functions. When a formula is entered in a cell in a
worksheet, the value of the equation is displayed in the cell and the formula is shown in the formula bar.

125
125