What is Spreadsheet software explain?
Spreadsheet software is combination of rows and columns where data can be arranged in an order. It provides formulas and functions to generate results and report in printable format. It converts data in chart to compare and analyze complex data. It helps to export and import data from other files. This software is flexible to work with tables. These are the examples of spreadsheet software.
 |
| Spreadsheet |
What is workbook and worksheet in MS Excel?
1) Workbook: A workbook is a collection of worksheet. By default MS Excel has three worksheets in a workbook. We can insert new worksheet and can rename them.
2) Worksheet: A worksheet is a combination of rows and columns. Each column is addressed with alphabets A, B, C and each row is addressed with numbers 1, 2, 3. The intersection of row and column is called cell and each cell has a unique address like A1.
--------------------------------------------------
Other Topic of this Chapter
What is range of cell in Spreadsheet?
A group of close cells is called cell range. A range could be horizontal, vertical, or mixed. There are three types of cell range.
 |
| Cell Range in Spreadsheet |
2) Horizontal Range: In horizontal range row cells are selected. For example: D1:F1
3) Mixed Range: In mixed range rows and column, both are selected. For example: D5:F8
--------------------------------------------------
Chapter 1 – Introduction to IT - ITeS Industries
Chapter 2– Data Entry & Keyboard Skills
Chapter 3 – Digital Documentation
Chapter 4 – Electronic Spreadsheet
Chapter 5 – Electronic Presentation
What does operator do in Excel?
In spreadsheet, operators are used to perform calculation. There are three types of operators:
1) Arithmetic Operator: These operators are mathematical symbols such as +(add), -(subtract), *(multiply), /(division), ^(exponential). These operators are used for calculation.
|
Operator |
Name |
Example |
|
+ |
Addition |
7+2 = 9 |
|
- |
Subtraction |
7-2 = 5 |
|
* |
Multiplication |
7*2 = 14 |
|
/ |
Division |
7/2 = 3 |
|
% |
Percent |
7%2 = 1 |
|
^ |
Exponential |
7^2 = 49 |
2) Comparison Operator: These operators are used to compare two values and returns true or false. Some common operators are =(equal to), <(less than), >(greater than), <=(less than equal to), >=(greater than equal to), <>(not equal to)
|
Operator |
Name |
Example |
Result |
|
= |
Equal to |
7 = 29 |
False |
|
< |
Less than |
7 < 2 |
False |
|
> |
Greater than |
7 > 2 |
True |
|
<= |
Less than equal |
7 <= 2 |
False |
|
>= |
Greater than equal |
7 >= 2 |
True |
|
<> |
Not equal |
7 <> 2 |
True |
3) Reference Operator: These operator used to combine cell range such as intersection operator, space operator, colon operator, union operator.
|
Operator |
Name |
Example |
|
Space Character |
Intersection |
=A1:B1 C2:D2 |
|
Space Character |
Space |
=A1:B1 C2:D2 |
|
Colon Operator |
Colon |
=A1:B1 |
|
Comma Operator |
Union |
=A1:B1,C2:D2 |
--------------------------------------------------
What is formula in spreadsheet?
A formula is a mathematical expression using cell or range of cells and gives a result. Three elements are used in a formula.
1) Reference: Cell or range of cells is used in a formula. For example: A1, B1:B8
2) Operator: (+, -, *, /, %, ^) Arithmetic Operators are used in mathematical expression.
3) Constants: Value that doesn’t change.
There are three types of formula:
1) Simple Formula: In simple formula only one operator is used. For example: =A2 + B2 + C2 + D2
2) Compound Formula: In compound formula more than one operator is used. For example: = A2 + B2 * C2 - D2
3) Text Formula: In text formula words or sentences are joined together using ‘&’ ampersand. For example: = A1&B1
No comments:
Post a Comment