Information Technology
Class-9
Part-B
Unit-4 Electronic Spreadsheet,
Chapter-1 LibreOffice Calc
A. Multiple choice questions:
1. Which of the following techniques can be used to allow only date value in cell?
a. data formatting b. data sorting c. data filtering d. data validation
Answer: Data validation
2. Which of the following options when selected deletes all data validation?
a. delete formatting b. delete all c. delete formula d. delete me
Answer: Delete all
3. We can replace multiple occurrences of a word using which of the following facilities of Calc?
a. find and replace b. by copy only c. by copy command d. by preview command
Answer: Find and Replace
4. What is the name of mechanism to arrange the data in a particular order?
a. sorting b. searching c. filtering d. validating
Answer: Sorting
5. What is the name of mechanism to filter out unnecessary data?
a. sorting b. searching c. filtering d. validating
Answer: Filtering
6. Which of the following types of package does calc refer to?
a. spreadsheet b. double sheet c. multi-sheet d. cannot determine
Answer: Spreadsheet
7. Which of the following is an extension of a worksheet created in Calc?
a. .ods b. .odd c. .xls d. .obj
Answer: .ods
8.How can one calculate the total of values entered in a worksheet column of?
a. by manual entry b. by auto sum c. by formula d. by sum functions
Answer: By auto sum
9. What is the correct way to enter a function in Calc?
a. directly typing function name in a cell
b. using function wizard to selecting from toolbar
c. both a and b.
d. depends on the function.
Answer: Directly typing function name in a cell
10. A function should start with:
a. = sign b. alphabets c. numbers d. all of the above
Answer: = sign
11. Which of the following options is used to print a chart?
a. insert->chart b. file->view c. file->print d. view->chart
Answer: File->Print
12. How many axes does chart in Calc have?
a. two b. three c. two or three d. four
Answer: Two
13. The chart preview can be seen in:
a. page preview b. chart preview c. export chart d. all of these
Answer: Page Preview
B. Fill in the blanks:
1. The column immediately next to column "Z" is _______.
Answer: AA
2. The default extension of a workbook created using a LibreOffice calc spreadsheet is _______.
Answer: .ods
3. The spreadsheet feature used to continue the series is called as _______.
Answer: Fill handle
4. The formula +MIN(C1:C5) stored in cell C6 when copied to cell D6 changes to ________.
Answer: =MIN(D1:D5)
5. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will be changes to _____________.
Answer: C2=D2+E3
6. The cell address of the cell formed by the intersection for the ninth column and the eight row will be _____.
Answer: I8
7. $A1$B2 is an example of ________ referencing in spreadsheet software.
Answer: Mixed
8. Numbers entered into a cell are automatically________ aligned.
Answer: right
9. If A1:A5 contain the number 16,10,3,25 and 6 then=averaged(A1:A5:60) will display_____.
Answer: 20
10. In ___________ referencing, the reference changes rows and columns automatically when it is copied to a new cell.
Answer: Relative
C. State T for true or F for false:
1. Maths operations can be performed in Calc.
Answer: T
2. Calc can store a maximum of 65,536 rows with 1024 columns in each sheet, with a maximum of 256 sheets.
Answer: T
3. Calc sheet is rows and columns format.
Answer: T
4. Date and time are supported as Data Type in Calc.
Answer: T
5. When using functions and formulas in LibreOffice Calc, it is always better to enter cell references rather than typing numbers directly into the formulas.
Answer: T
D. Short answer questions:
1. What is spreadsheet relative and absolute cell address in Calc?
Answer: In a spreadsheet, relative cell addresses change when copied or moved, while absolute cell addresses remain constant:
Relative cell addresses: These change based on the position of the cell where the formula is applied. For example, if you copy the formula=A1+B1 down, it will change to A2+B2. Relative cell addresses are useful for repetitive calculations across different rows or columns.
Absolute cell addresses: These remain fixed even when copied to other cells. For example, if you copy the formula=$A$1+$B$1, it will remain the same regardless of where it is copied.
2. Write steps for addition and subtraction operations in Calc.
Answer: Formulas must begin with an = equal sign. For example to add the values in cells A2:10, you can use the formula=SUM(A2:A10).
Steps for addition and subtraction operations:
* You can use the function wizard.
* If your formula starts with a+ or -, Calc automatically adds the =symbol.
* If you enter a positive or negative number, Calc does not add an =.
* You can change the default font for formulas by going to format>fonts on the menu bar.
3. Write steps to create new spreadsheet in Calc.
Answer: To create a new spreadsheet in LibreOffice Calc, you do the following:
1. Click file
2. Click new
3. Click spreadsheet.
You can also use the keyboard shortcut Ctrl+N to create a new spreadsheet.
4. What is cell in Calc?
Answer: Cell is a specific location in a spreadsheet where data is stored. To make a spreadsheet easier to modify, you can add comments to cells and use labels and headings. You can also use the zoom function to show more or fewer cells in the window.
5. What is Active Cell in Calc?
Answer: The active cell in LibreOffice Calc is the cell in a spreadsheet that is currently selected for data entry. You can change the active cell by clicking on a cell with the left mouse button or using the arrow keys on the keyboard.
You can do the following with the active cell:
* Enter or modify data
* Perform calculations
* Apply formatting
* Define a data type
6. What is Pivot table?
Answer: A pivot table is a tool that summarizes and analyzes data in a spreadsheet or database table. It allow users to quickly analyze large amounts of data, and answer questions about it.
You can do the following with pivot table:
* Summarize data
* Create custom calculations
* Filter and sort
* Pivot data
* Drill down
* Make decisions
7. What are type of charts in Calc?
Answer: Calc includes different charts: Column charts, Bar charts, Pie charts, Area charts, Line charts, Scatter or XY charts, Bubble charts, and Net charts. The default chart type is a bar diagram with vertical bars. To create a different type of chart, you can apply a different diagram type to the initial chart.
8. Name and explain 5 math's formulas.
Answer: Five math's formulas in Calc:
* SUM: Adds up a range of numbers.
* AVERAGE: Calculate the average of a range of numbers.
* COUNT: Counts the number of cells that contain numbers in a range.
* Addition, subtraction, multiplication and division: These operators identify a characteristic of the number found in the cell.
* Negation and percent: these operators identify a characteristic of the number found in the cell.
9. Explain the steps to find mean of 10 numbers in Calc.
Answer: Enter your 10 numbers in a single column (for example, from cell A1 to A10). Click on an empty cell where you want to display the mean. Type the formula =AVERAGE(A1:A10) into the selected cell and press Enter. This formula calculates the mean of the numbers in cells A1 through A10.
Some other links:
No comments:
Post a Comment