DAV Class 6 Computer Chapter 8 Spreadsheet – II CALC (Open Source) Question Answer Notes
DAV Class 6 Computer Chapter 8 Spreadsheet – II CALC (Open Source) Question Answer Notes Solution by Expert Computer Teacher. DAV Class 6 Computer 8th Chapter Spreadsheet – II CALC (Open Source) for Students of DAV Schools.
Lesson No 8
Spreadsheet – II CALC (Open Source)
Q1.) Fill in the blanks :-
1.) OpenOffice.org Calc helps to arrange the rows of a data list alphabetically or numerically in ascending or descending order
2.) Ascending (A-Z) helps to sort the lowest number, the beginning of the alphabet or the earliest data first.
3.) Descending (Z-A) helps to sort the highest number, the end of the alphabet, or the latest data first.
4.) Cell address is a column letter followed by row number.
5.) Fill Handle is used for generating series of numbers, days, months etc and also copies formulas for us.
6.) Functions are the pre-defined or built in formulas in OpenOffice Calc that performs calculations using specific values known as Arguments in a particular order.
Q2.) State whether the following statements are True or False :-
1.) Average is the sum of all the values. – False
2.) Column is the basic element of a spreadsheet. – False
3.) A formula contains Value, Operators, Cell Addresses, Functions etc. – True
4.) Formatting means general arrangement of data. – True
5.) Every formula must begin with “=” is equal to sign. – True
Q3.) Answer the following questions in two or three sentences each :-
1.) State the use of OpenOffice.org Calc
Ans :- OpenOffice.org Calc is used for organizing the data (alphabetically or numerically) in the rows either in ascending order or descending order. The ascending and descending buttons you will find on the standard toolbar.
- Ascending (A-Z) :– It is used for arranging the data in the lowest form either by the first of the alphabets or by the earliest/oldest date.
- Descending (Z-A) :– It is used for arranging the data in the highest form either by the last of the alphabets or by the recent/latest dates first.
Before sorting the data in Ascending and Descending order first the data needs to be selected and choose the icon as per the need.
2.) State the difference between Ascending and Descending
Ans :- The difference between Ascending and Descending order is as followed :-
- Ascending (A-Z) :- It is used for arranging the data in the lowest form either by the first of the alphabets or by the earliest/oldest date.
- Descending (Z-A) :- It is used for arranging the data in the highest form either by the last of the alphabets or by the recent/latest dates first.
3.)What is the basic element of a spreadsheet
Ans :- Cell is the basic element of a spreadsheet. Cell is a small rectangle box and is a single unit of rows of columns.
4.) What is a formula
Ans :- A formula is an expression or method which is used for calculating the values of the cell. A formula can contain
- Values :- ex 5, 6, 2 etc
- Operators :- + , – , /, * etc
- Cell Addresses :- ex B15, G100
- Function :- ex Sum (), Average (), Min () etc
5.) What is a Cell Address
Ans :- Cell Address is present near to the Formula bar. It displays the actual position of your current cell on which you are working. In cell address, you may see the column letter and the row number which clearly states the actual position of your cell.
6.) What is a Fill handle
Ans :- Fill Handle is specially made used for creating the series of numbers, days, months etc. It also performs the work of copying the formulas and functions. Hence there is no need to enter the formula when ever we are making use of the Fill handle.
7.)What is function
Ans :- In the Open Office Calc you may get some built in formulas or pre-defined formulas which are known as functions. It is mostly used for doing calculation work by making use of the specific values which are known as Arguments in a particular order.
8.) Name the things involved in editing cell contents.
Ans :- The things involved in editing the cell contents are as followed :-
- Replacing and Overwriting in the cell contents.
- Making changes in the cell contents by removing some contents and keeping some.
- Making the deletion of cell contents.
9.) What is a Clipboard.
Ans :- Clipboard is an storage area which is temporary where you may find the cutted or copied material from the location and is been kept for pasting/placing to the another location.
Q4.) Answer the following questions :-
1.) What do you mean by Formatting a Worksheet?
Ans :- Formatting of a worksheet means that worksheet data is properly adjusted. Formatting helps the worksheets to look in a professional or presentable way. The formatting can be done on the data that is available in text or in numeric form. Formatting Numbers includes showing of percentage, date/time etc. Formatting of text includes change in the font, color, size, alignment etc of the text. You can apply formatting by selecting the data to whom you wish to apply formatting and then by choosing the options from the Formatting toolbar or clicking Format ——- Cells.
2.) Write down the steps for printing a worksheet
Ans :- The steps for printing the worksheet are as followed :-
Step : 1
Click on the File menu ————- and select the Print option from the list
OR
You can press the shortcut key combination of Ctrl + P from the Keyboard
OR
On the standard toolbar, you can click on the Print button/icon
After following anyone of the steps you may see that Print dialog box appears on the screen
Step : 2 Make the necessary changes into the Print dialog box. The changes that could be setted are make a click on the Printer which is already installed in the PC from the list and select the paper size (on which you want the print), mode (how you want the print i.e means in Landscape or Portrait), input the number of copies required etc.
Step : 3 Once you’ve done with adjusting the necessary or required changes, then you may click on Print button.
3.) Explain the steps for creating a Chart
Ans :- Following are the steps through which we can easily create the charts
Step : 1
You need to select any one method to open Chart Wizard Click on Insert tab ———- Chart
OR
Click on the Chart button that is available on the Standard toolbar
Step : 2
Now from the Chart wizard, you can select any one of the chart of your wish and that may be suitable to your data.
Step : 3
Now you are needed to select the range of cells to whose data you wish to apply the chart.
Step : 4
Here, if you wish you can add or remove the data from the series.
Step : 5
It’s the almost final step in creation of charts where you can choose the titles, legends and their placements. Once you are done with it, then click on the Finish button.
4.) State the rules for writing the formulas in OpenOffice.org Calc
Ans :- The rules for writing formulas in OpenOffice.org Calc are Before applying any formula in a worksheet, formula must start with the “=” is equal to sign and should not contain any space before the “=” is equal to sign. If “=+ is equal to sign is not added before the formula, then you formula will have an error.
For the operation of the values, there is a need for mentioning the arithmetic operators. We can state/declare the arithmetic operators like add (+) , Subtract (-), Multiply (*), Divide (/), or find exponentiation (^) using the formula.