Unit: 4 Electronic Spreadsheet

  

Unit: 4 Electronic Spreadsheet

 

Q1. What do you mean by Spreadsheet/Electronic Spreadsheet?

Ans. A spreadsheet is a grid that interactively manages and organizes data in rows and columns. It is also called an Electronic Spreadsheet.

 Q2. Write three uses of the spreadsheet.

Ans. A spreadsheet is used for:

1.      Managing financial and accounting documents.

2.      Creating data reports, and generating invoices.

3.      Data analysis from scientific and statistical research.

 Q3. List any four activities that can be done accurately or efficiently on Open Office Calc.

Ans. Four activities are :

1.      Filtering the required data.

2.      Calculations using formulas and functions.

3.      Check the validity of data.

4.      Arrange data in ascending and descending order.

Q4. Write any three Spreadsheet software.

Ans. Three Spreadsheet software are :

1.      Microsoft Excel

2.      OpenOffice Calc

3.      Libre Office Calc

4.      Apple Inc. Numbers

  Q5. Name the three types of data that can be entered in a cell.

Ans. Three types of data that can be entered in a cell are :

1.      Label

2.      Values

3.      Formulae

  Q6. Name and explain in brief any two toolbars that provide a wide range of common commands and functions in Open Office Calc.

Ans. Two toolbars are :

1. Standard Toolbar: The standard toolbar shows the icons for most common operations, such as editing, arranging, filtering, etc.

2. Formatting Toolbar: It includes buttons for font selection, size of text, alignment, cell value formatting indentation, etc.

 Q7. What do you mean by Tooltip?

Ans. When we place the mouse cursor over any icon, it displays a small box called a tooltip. It gives a brief explanation of the icon function.

 Q8. What do you mean by Worksheet in Calc?

Ans. The worksheet in Calc is also referred to as a spreadsheet. Each sheet can have many individual cells arranged in rows and columns.

Q9. Differentiate between Row and Column.

Ans. Differences are:

Row	Column
The horizontal lines in the worksheet are called rows	The vertical lines in the worksheet are called columns
Row headings are represented by numbers like 1, 2, 3, etc.	Column headings are shown by Capital Alphabet like A, B, C, etc.

 Q10. What do you mean by Cell?

Ans. The intersection of a row and column is called a cell.

 Q11. What do you mean by Active Cell?

Ans. The selected cell is called an Active Cell. It is always highlighted, with a thick border. The address of the active cell is displayed in the name box.

 Q12. Write the cell address of the following

1.      First row and first column ………..

2.      First column and last row …………

3.      First row and last column ………..

4.      Last column first row ……..

5.      Seventh column and tenth row …….

6.      Tenth column and nineteenth row ……..

7.      The cell address LK89 is situated in row number……… and column letter ……..

Ans.

1.      A1

2.      A1048576

3.      AMJ1

4.      AMJ1

5.      G10

6.      J19

7.      89 and LK

 

 Q13. What do you mean by Range of cells?

Ans. A block of adjacent cells in a worksheet that is highlighted or selected is called a range of cells. for example A1 : C3

 Q14. Identify the following range of cells as Row range, Column range, Row and Column range.

1.      A1 : A7

2.      A1 : D1

3.      A3 : D7

4.      B4 : B12

5.      C9 : J9

Ans.

1.      A1 : A7 – – – – – Column Range

2.      A1 : D1 – – – – – Row Range

3.      A3 : D7 – – – – – Row and Column Range

4.      B4 : B12 – – – – – Column Range

5.      C9 : J9 – – – – – Row Range

 Q15. Name any four types of charts that can be created in Open Office Calc.

Ans. Four types of Charts are :

1.      Bar Chart

2.      Column Chart

3.      Pie Chart

4.      Line Chart

 Q16. What do you mean by Formula in Calc?

Ans. Any expression that begins with an equals sign (‘=’) is treated as a formula. for example =A1 + B1

 

 Q17. What do you mean by Function in Calc?

Ans. A function is a predefined formula that help to do mathematical, and statistical operations.

 Q18. Explain the following functions with examples:

1.      sum

2.      average

3.      max

4.      min

5.      count

 Ans.

1. Sum: This function adds the values contained in a range of cells. for example = sum(A1 : A5) will add all the values of cell A1, A2, A3, A4 and A5.

 2. Average: This function finds out the average of the values contained in a range of cells. for example =average(A1 : A5) will return the average of values present in cell A1, A2, A3, A4 and A5.

3. Max: This function returns the largest value contained in a range of cells. for example =max(A1 : A5) will return the largest value present in cell A1, A2, A3, A4 and A5.

 4. Min: This function returns the smallest value contained in a range of cells. for example =min(A1 : A5) will return the smallest value present in cell A1, A2, A3, A4 and A5.

5. Count: This function counts the number of non-empty cells within a range of cells. for example =count(A1: A5) will return 5, if all cells contain any value.

Q19. What is the fill handle in Calc?

Ans. The small black square in the bottom-right corner of the selected cell or range is called a fill handle.

Q20. Aman is writing the telephone number along with the STD code (starting from zero ‘0’). He noticed that the first digit zero (‘0’), disappears from the telephone number. Write the reason for this. What can be done to store telephone numbers starting from zero in a cell?

Ans. This is because the telephone number is stored as a numeric value, and the numeric value does not have a preceding zero.

We can store telephone numbers starting from zero in a cell by formatting the cell consisting of a telephone number as ‘text’.

 Q21. Name and explain the three types of data that can be entered in a cell.

Ans. Three types of data that can be entered in a cell are :

1. Label: Label is any text entered by using a keyboard. It may be any letter, number, or special symbol. By default, the labels are left aligned.

2. Values: The numerical data consisting of only numbers are called values. By default values are right aligned.

3. Formula: Any expression that begins with an equals ‘=’ is treated as a formula. When a formula is entered in a cell the formula bar gets activated.

 Q22. What do you mean by Referencing in Calc? Name the three types of referencing in Calc

Ans. Referencing is the way to refer to the cell or range of cells in a formula or function.  Three types of referencing in Calc are:

1.      Relative referencing

2.      Mixed referencing

3.      Absolute referencing

 Q23. Explain the Relative referencing in Calc with an example.

Ans. When you drag any formula in any row or column in any direction, the formula gets copied in the new cell
with the relative reference. for example =C1 is an example of relative referencing, as this formula changes automatically when we drag it vertically or horizontally.

 Q24. What do you mean by mixed referencing in Calc?

Ans. In Mixed Referencing, the $ sign is used before the row number or column name to make it constant. for example, = C$1 is an example of mixed referencing, as this formula changes only when you drag it horizontally.

Q25. What do you mean by absolute referencing in Calc?

Ans. In Absolute referencing, a $ symbol is used before the column name as well as the row number to make it constant in any formula. For example, $C$12, $D$5, etc. In this case, even if you drag your formula in any
direction, the cell name remains constant.

 Q26. Identify the types of referencing from the following

1.      =C1

2.      =D$2

3.      =$W2

4.      =$E$4

Ans.

1.      Relative Referencing

2.      Mixed Referencing

3.      Mixed Referencing

4.      Absolute Referencing