DAV Class 6 Computer Chapter 7 Spreadsheet – I CALC (Open Source) Question Answer Notes
DAV Class 6 Computer Chapter 7 Spreadsheet – I CALC (Open Source) Question Answer Notes Solution by Expert Computer Teacher. DAV Class 6 Computer 7th Chapter Spreadsheet – I CALC (Open Source) for Students of DAV Schools.
Lesson No 7
Spreadsheet – I CALC (Open Source)
Q1.) Fill in the blanks :-
1.) Spreadsheet is an electronic software which is an arrangement of data in the form of rows and columns.
2.) Grid is the pattern of crisscrossed bars, i.e is horizontal and vertical bars.
3.) Open Office Calc is a free spreadsheet software.
4.) Worksheet is a single spreadsheet that contains cells which are organized in rows and columns.
5.) A cell is the intersection of a column (Vertical Lines) and row (Horizontal Lines) in the form of grid.
6.) Active cell is a cell with the highlighted boundary around it.
Q2.) State whether the following statements are True or False :-
1.) More than one cells can be active at a time. – False
2.) Analogy is the smallest unit of the Spreadsheet Software (Calc) – True
3.) A spreadsheet workbook is saved with an extension .xls – True
4.) In the Spreadsheet worksheet Alphabets represents the rows while the numbers represents the columns. – False
5.) Tessellation (repeating /tiling) off squares using Paper folding is another example of grid you must have used. – True
Q3.) Answer the following questions in two or three sentences each :-
1.) What is a Spreadsheet
Ans :-Spreadsheet involves the concept of grids of rows and columns similar to a graph papers which is mostly used for writing numbers and doing calculations. This application is used in computers electronically, hence it is termed to be the electronic spreadsheet. In the spreadsheet, you can organize the data in the form of rows and columns.
2.) What is Open Office Calc
Ans :-
It is the free spreadsheet software. Open office calc is the part of the Apache Open Office suite.
3.) What is Analogy
Ans:- Analogy is the smallest unit of the Spreadsheet software (Calc). It is similar to the cells which is the very smallest part or unit in the human body.
4.) What do you understand by worksheet, cell and workbook.
Ans:- Worksheet is a single spreadsheet which contains the group of cells which are arranged in the form of rows and columns. In the Spreadsheet worksheet Alphabets represents the columns while the numbers represents the rows. Workbook is the collection of worksheets. By default there are three worksheets named as Sheet 1, Sheet 2, Sheet 3 in a workbook.
5.) What is a Grid
Ans :- Grid is a form of crisscrossed bars, that are in horizontal and vertical lines.
Q4.) Answer the following questions :-
1.) Explain the uses of Spreadsheet
Ans :- The spreadsheet is used for various purposes, some of them are as follows :-
- Spreadsheet is much useful for working/completing simple and difficult/complicated tasks.
- It is mostly helpful in accomplishing the tasks related to the financial calculations such as budgeting and making the accounting much easier. We can create simple records, generate salary statements and maintain accounts etc.
- In short Spreadsheet works like a calculator.
- Spreadsheet even helps you for calculating the mathematical formulas by making use of built in functions and calculate the averages and percentages.
- If incase there is any changes been made in the entered data, then spreadsheet is able to perform recalculations automatically.
- It can also work on the data which is not numeric. You can also create and edit all kinds of lists such as birthday party, list of schools, directory, mother’s grocery list etc.
- On the basis of the entered data, you can also create graphs and charts within the table.
2.) Write the steps for opening the Openoffice.org Calc
Ans :-Following are the steps for opening Openoffice.org Calc :-
Step : 1
Go to the Start menu ——– Select All Programs
Step : 2
From the OpenOffice Suit, select the OpenOffice.Calc
OR
Step : 1
On the desktop, you will see the Openoffice.org icon, make a double click on it.
Step : 2
The window will appear, from which you can click on Spreadsheet.
Openoffice.org Calc Window will open as shown below
3.) Explain the components of the Openoffice.Org Calc window?
Ans :-The components of the Openoffice.Org Calc window are as followed :-
- Title Bar :-On this bar you can find or notice the name of the application or name of the file that is been currently opened. On the left side of the title bar, you may find the control bar and the control buttons like Minimize, Maximize and Restore buttons on the right side.
ii.) Menu Bar :-On this bar, you will find many options such as File, Edit, View etc.
photo
iii.) Toolbars :-On this bar, you may notice several icons which will help you to access to the main functions and commands. There are two main toolbars which are Standard toolbar and the other one is Formatting toolbar.
iv.) Formula Bar :-On this bar you will be able to see the contents of the selected cell. It is helpful in entering of data into the cells.
v.) Navigation buttons and Sheet Tabs :-These buttons or tabs are been located at the bottom. By making use of this button, it makes user to navigate between the worksheets or workbook.
vi.) Status Bar :-On this bar, you will notice that the current worksheet, total number of worksheets, current page style, current selection mode, and helps to enlarge/reduce the display.
4.) How to enter the data ? Explain the steps.
Ans:- The steps to enter the data are as followed :-
Step:1
Make a click on any of the cell that you wish to enter in. For ex :- cell A1 (topmost cell on the left of the spreadsheet).
Step : 2
You will notice that the dark black colour border will appear all around your cell i.e is cell A1 (the cell which is at the top of the first column and the first row). Both are been highlighted. The highlighting shows that cell A1 is the active cell.)
Step : 3
Now you can type the text into the cell . For ex :- Type WELCOME TO CALC and then press enter.
Note :- Whatever the data you enter into the cell, the data gets displayed in two places one is in the cell itself and the another place is in the Formula Bar.
Step : 4
After you press the Enter key from the keyboard, you will notice that A2 cell will become the active cell as if the words/statement as WELCOME TO CALC is in cell A1
5.) What are the different categories of data
Ans :- The different categories of data are :-
- Numbers :- It contains the data in the number form from 0 – 9. When we enter the numbers into the cell, the numbers are been aligned to the right hand side of the cell.
- ii) Text :- This data category consists of the alpha numeric which consists of combination of alphabets form A-Z, spaces, digits, special symbols etc. When the text data is entered into the cell, then the alphabets appear on the left side of the cell.
iii) Date and Time :- It used for calculating and tracking the date and time in the worksheet. When we enter the date in the cell, we can use it “/” or “-“ characters for separating the numbers in the dates.
iv) Functions and Formulas:- It contains the values , operators like +,-,/,* and the addresses of the cells which states the relationship between the cells. Before making use of any formula in the cell, we must make sure that “=” is equal to sign is used.
6.) What are the steps for saving a Workbook
Ans :- The steps for saving a Workbook are as follows :-
Step : 1
Go to the File tab ——– Save
OR
Press CTRL + S key from the keyboard
OR
Make a click on the icon (Save button) on the Standard Tool bar
Step : 2
You will see the Save As dialog box will appear on the screen.
You will see the file name already appearing as Untitled 1 in the file name box.
Now press the backspace key from the keyboard and erase/delete the previous file name from the file name box and then the type the name of the file as per your wish and select the place or desired folder where you want to save the workbook.