Unit – 4 Electronic Spreadsheet

 

Unit – 4 Electronic Spreadsheet

 

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

Ans. A spreadsheet is a grid which interactively manages and organises data in rows and columns. It is also called as Electronic Spreadsheet.

 Q2. Write three uses of spreadsheet.

Ans. Spreadsheet is used for:

1.      Managing financial and accounting documents.

2.      Creating data reports, generating invoices.

3.      Data analysis from scientific and statistical researches.

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

Ans. Four activities are :

1.      Filtering the required data.

2.      Calculations using formula and functions.

3.      Check the validity of data.

4.      Arranging 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. In which operating system Open Office installed by default?

Ans. Linux(Ubuntu)

Q6. Name any three components of Open Office.

Ans. Three components of Open Office are:

1.      OpenOffice Calc

2.      OpenOffice Writer

3.      OpenOffice Impress

Q7. How to start the OpenOffice Calc in Windows?

Ans. Steps to start the OpenOffice Calc in Windows are:

Double click the shortcut of OpenOffice on the Desktop.

OR

Click the window menu, select OpenOffice application, then click OpenOffice Calc.

 Q8. How to start the OpenOffice Calc in Linux?

Ans. In Ubuntu Linux, find the Calc icon on application launcher or search it by clicking on “Show Application” and then click on icon.

Q9. Name any seven parts of User interface of Open Office Calc.

Ans. Seven parts of User interface of Open Office Calc are:

1.      Quick Access Tool bar

2.      Title bar

3.      Ribbon

4.      Control Buttons

5.      Name Box

6.      Formula bar

7.      Formatting Tool bar

8.      Zoom Control

9.      Column Heading

10.     Row Heading.

  Q10. 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

 Q11. Name the bar which is located at the top of the Open Office Calc window.

Ans. Title bar

Q12. ______________ bar shows the name of the current spreadsheet.

Ans. Title

 Q13. What is the default name of the first file opened in Open Office Calc?

Ans. Untitled 1

Q14. Name any four items/options available on Menu bar.

Ans. Four items/options available on Menu bar are : (write any four)

1.      File

2.      Edit

3.      Insert

4.      View

5.      Format

6.      Styles

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

Ans. Two toolbars are :

1. Standard Toolbar : The standard tool bar 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 and indentation, etc.

 Q16. 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.

 Q17. What do you mean by Worksheet in Calc?

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

Q18. Differentiate between Row and Column.

Ans. Differences are:

Row	Column
The horizontal lines in worksheet are called rows	The vertical lines in 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.

 Q19. Name the basic element or building block of spreadsheet.

Ans. Cell

 Q20. What do you mean by Cell?

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

 Q21. What do you mean by Active Cell?

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

 Q22. 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

 Q23. Write the shortcut to move the cell to the end of the data range in a particular direction.

Ans. Ctrl + Arrow Keys

Q24. Write the shortcut to move the cell pointer to A1 position.

Ans. Ctrl + Home

 Q25. Write the shortcut to move the cell pointer to bottom right cell of the data range.

Ans. Ctrl + End

 Q26. What do you mean by Range of cells?

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

 Q27. 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

 Q28. Write the shortcut to open Format cell dialog box.

Ans. Ctrl + 1

 Q29. 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

 Q30. What do you mean by Formula in Calc?

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

 Q31. Evaluate the expression = (5*4)^2

Ans. 400

 Q32. Evaluate the following equations using operator precedence and then test the result in the spreadsheet.

1.      8-4/2

2.      5*5+8

3.      3+5*4

4.      2^5+8

5.      3+2^2

6.      5+6*2^2

7.      8/4*4

8.      -4/2+2

9.      1+2^2-2

10.     4*3/2

Ans.

1. 6

2. 33

3. 23

4. 40

5. 7

6. 29

7. 8

8. 0

9. 3

10. 6

 Q33. If you forgot to put the ‘=’ before the formula, it will be treated as a ________________

Ans. Label

 Q34. Identify the correct formula from the following :

1.      =A1 + B1

2.      B2 = C1 * 2

3.      B1 + C1*4

4.      =A1 = D3

Ans. Correct formula is = A1 + B1

 Q35. Write the steps to insert a column before any column.

Ans. To insert a column before any column, position the cursor on any cell of the column before which you want to insert the column and select
Sheet → Insert Columns → Columns → Columns left

 Q36. What do you mean by Function in Calc?

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

 Q37. 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 cell. for example =average(A1 : A5) will return the average of values present in cell A1, A2, A3, A4 and A5.

3. Max : This function return 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 return 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 some any value.

Q38. What is 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.

 Q39. Write the shortcut for the following:

1.      Copy the formula

2.      Paste the formula

Ans. Shortcuts are :

1.      Ctrl + C

2.      Ctrl + V

 Q40. Write the steps to format a cell to the required number of decimal places.

Ans. The steps to format a cell to the required number of decimal places are :

1.      Select the range of cells.

2.      Open the ‘format cells dialog’ box

3.      Click the ‘Number’ tab

4.      Select the ‘Number’

5.      Change the decimal places as required

6.      Click ‘OK’

 Q41. Write the steps to format a range of cells as text.

Ans. Steps to format a range of cells as text:

1.      Select the range of cells

2.      Open the ‘format cells dialog’ box

3.      Click the Number tab

4.      Select Text

5.      Click ‘OK’

6.      Enter numbers

 Q42. Aman is writing telephone number along with 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 number 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 number starting from zero in a cell by formatting the cell consisting of telephone number as ‘text’.

 Q43. 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 expressions that begins with an equals ‘=’ is treated as formula. When a formula is entered in a cell the formula bar gets activated.

 Q44. What do you mean by Referencing in Calc?

Ans. Referencing is the way to refer the cell or range of cell in a formula or function.

 Q45. Name the three types of referencing in Calc.

Ans. Three types of referencing in Calc are:

1.      Relative referencing

2.      Mixed referencing

3.      Absolute referencing

 Q46. Explain the Relative referencing in Calc with 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.

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

Ans. In Mixed Referencing, the $ sign is used before 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.

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

Ans. In Absolute referencing, a $ symbol is used before the column name as well as 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.

 Q49. 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

 Q50. Write the steps to create column chart in Calc.

Ans. Steps to create column chart in Calc are:

1.      Select the range of data.

2.      Click on Insert → Chart

3.      Select the type of chart

4.      Select the chart (Column Chart)

5.      Click finish.