CBSE, Class 6, IT- computer ,Unit/Ch -2, introduction to open office calc
Notes
Spreadsheet Application
A spreadsheet application is in the form of a grid or a table that organises data into rows and columns. It is used to organise, manipulate and perform calculations on numerical data.
The following can be done in a spreadsheet application.
· enter text and numeric data
· edit data
· format data
· perform calculations on data
· present data in a graph
Components of OpenOffice 4 Calc
1. Menu bar : File, Save
2. Standard toolbar : Options New, Open, Print, Copy, Paste and so on
3. Formatting toolbar : Select a font, font color, alignments, number formats, border options and background colors.
4. Formula toolbar : contains the Name Box and the Input Line textbox.
5. Workbook and Worksheet: When you start OpenOffice Calc, the file that opens is called a workbook. By default, the name of the first workbook is Untitled1. àA workbook contains many worksheets.
Columns and Rows
· The column header identifies each column. The first 26 column headings are A through Z. The next 26 column headings are AA through AZ.
· A cell is the fundamental element of a worksheet. The intersection of a column and a row forms a cell. For example, the first cell in the upper left corner is A1 (column A, row 1).
Editing a worksheet
Editing a worksheet refers to entering data in the cells, along with modifying, deleting and formatting.
The following types of data can be entered in Calc.
· strings or text
· numbers
· formula
Entering Data in a Spreadsheet
Inserting and Deleting Rows and Columns
Formatting Cells
Shortcut Keys
Bold – Ctrl + B
Italic – Ctrl + I
Underline – Ctrl + U
Cell Formats
· Number:
· Currency:
· Date:
· Time
· Percentage:
· Fraction:
· Scientific
· Text:
AutoFill: The AutoFill feature is used to fill a series of values into a selected range of cells automatically.
Calculations in OpenOffice Calc
Calc helps you to quickly perform calculations with the help of predefined formulas. These formulas are called functions. A function starts with an “=” sign.
1. The Sum() function: add the various number present into cell.
syntax: = sum (rnage)
Ex: =sum(B4:B8)
2. The Average() function :The AVERAGE function is used to calculate the average of the values in a selected range of cells.
Syntax:=average()
3. The Min() function : The MIN function is used to find the lowest value within the selected cell range.
EX: =MIN(D2:D6)’.
4. The Max() function :The Max function is used to find the highest value within the selected cell range.
EX: ‘=Max(D2:D6)’.
Exercise
Q:1 Fill in the blanks.
1. An application that can be used to organise numerical data in the form of tables and perform calculations on it is called a spreadsheet application.
2. The cell is a fundamental element of a worksheet.
3. A workbook is a collection of worksheets.
4. The Scientific cell format displays the content of a cell in exponential notation.
5. In OpenOffice Calc, the AutoFill feature is used to fill a series of numbers such as 2,4,6,8 and so on.
Q:2 Answer the following questions.
a. What is a spreadsheet? List its uses.
Ans: A spreadsheet application is in the form of a grid or a table that organises data into rows and columns. It is used to organise, manipulate and perform calculations on numerical data.
You can do the following in a spreadsheet application.
· enter text and numeric data
· edit data
· format data
· perform calculations on data
· present data in a graph
b. Differentiate between a workbook and a worksheet.
Workbook | Worksheet | |
1. | Workbook is an Calc file containing many worksheets. | A worksheet has a single spreadsheet containing data. |
2. | Workbook cannot be added within the worksheet. | Worksheets can be added in a workbook |
3. | Workbooks are used to work in a professional environment. | Worksheet is preferred in a learning or educational setup. |
c. List the types of data that can be entered in the Calc.
Ans: The following types of data can be entered in Calc.
· strings or text
· numbers
· formula
d. Which feature of OpenOffice Calc should be used for the following?
i. To display the content in multiple lines in the same cell when it exceeds the width of the cell.
Ans: The wrap text feature is used.
ii. To display a series of values such as Monday, Tuesday and so on. in a selected range of cells.
Ans: AutoFill feature will be used.
Extra Questions
Choose the correct option.
1. ___________is in the form of a grid or a table that organises data into rows and columns.
a. power point
b. system application
c. A spreadsheet application
d. None of Above
2. ___________ is a open source electronic spreadsheet that is freely available.
a. Ms- Excel
b. OpenOffice 4 Calc
c. Word
d. None of above
3. Components of OpenOffice 4 Cals is / are _____________
a. Menu bar
b. Standard toolbar
c. Formatting toolbar
d. Formula toolbar
e. all of above
4. _________ toolbar contains the Name Box and the Input Line textbox.
a. Menu bar
b. Standard toolbar
c. Formatting toolbar
d. Formula toolbar
5. ____________ has icons and drop-down menus that allows you to select a font, font color, alignments, number formats, border options and background colors.
a. Menu bar
b. Standard toolbar
c. Formatting toolbar
d. Formula toolbar
6. _________ is used to find the highest value within the selected cell range.
a. The Max function
b. the sum function
c. the Average function
d. none
7. The ___________ function is used to find the lowest value within the selected cell range.
a. MIN
b. max
c. sum
d. none
8. The _______function is used to calculate the average of the values in a selected range of cells.
a. AVERAGE
b. max
c. min
d. sum
9. The ________feature is used to fill a series of values into a selected range of cells automatically.
a. AutoFill
b. cell formatting
c. automatic
d. none
10. ______- format multiplies the cell value by 100 and displays the result with a percent symbol.
a. currency
b. number
c. scientific
d. none of above
11. Which of the following is / are valid format in Cals?
a. 09/17/2016
b. 17th-Sep-16
c. Saturday, September 17, 2016
d. 17-Sep
e. all of above
Comments
Post a Comment