Class-IX
Unit 4 Electronic Spreadsheet
Q1.)
Multiple choice questions
1. Which of the
following technique can be used to allow only date value in cell?
(a) Data formatting (b) Data sorting
(c) Data
filtering (d)
Data validation
Ans: (a)
Data formatting
2. Which of the
following options when selected deletes all data validation?
(a) Delete formatting (b) Delete all
(c) Delete
formula (d)
Delete me
Ans: (a)
Delete formatting
3. We can replace multiple occurrences of a word
using which of the following facilities of Calc? (a) Find and replace (b)
By replace only
(c) By copy
command
(d) By preview command
Ans: (c) By
copy command
4. What is
the name of mechanism to arrange the data in a particular order?
(a) Sorting (b)
Searching
(c)
Filtering
(d) Validating
Ans: (a)
Sorting
5. What is
the name of mechanism to filter out unnecessary data?
(a) Sorting
(b) Searching
(c)
Filtering
(d) Validating
Ans: (d)
Validating
6. Which of
the following type of package does Calc refer to?
(a)
Spreadsheet
(b) Double sheet
(c) Multi-sheet (d) Cannot
determine
Ans: (d)
Cannot determine
7. Which of
the following is an extension of a worksheet created in Calc?
(a) .ods (b) .odd
(c) .xls
(d) .obj
Ans: (a)
.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 function
Ans: (d) By
sum function
9. If we
move a cell containing a formula having reference to another cell in the
worksheet what will happen to the cell numbers used in the formula?
(a) The cell
row and columns are changed at destination.
(b) The cell row change at destination.
(c) The cell
columns are changed at destination.
(d) No
change will scour.
Ans: (c) The
cell columns are changed at destination.
10. What is
the correct way to enter a function in Calc?
(a) Directly
typing function name in a cell
(b) Using function wizard or selecting from
toolbar
(c) Both (a)
and (b)
(d) Depends
on the function
Ans: (d)
Depends on the function
11. A
function should start with__________________.
(a) ‘=’ sign (b)
alphabets
(c) numbers (d)
All of the these
Ans: (a) ‘=’
sign
12. Which of
the following option is used to print a chart?
(a) Insert → Chart (b) File → View
(c) File → Print (d) View →
Chart
Ans: (c)
File → Print
13. How many
axes does charts in Calc have?
(a) Two
(b) Three
(c) Two or three (d) Four
Ans: (a) Two
14. The
chart preview can be seen in________________.
(a) Page
preview (b)
Chart preview
(c) Export chart (d) All of these
Ans: (d) All
of these
B. Fill in the blanks
1. The
column immediately next to column “Z” is AA .
2. The
default extension of a workbook created using a LibreOffice Calc spreadsheet is
.ods .
3. The
spreadsheet feature used to continue the series is called as Fill handle .
4. The
formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to =MIN(D1:D5)
.
5. The formula in cell A2 is =B2+C3. On
copying this formula to cell C2, C2 will change to =D2+E3 .
6. The cell address of the cell formed by the
intersection of the ninth column and the eighth row will be 18 .
7. $A1$B2 is
an example of mixed referencing in spreadsheet software.
8. Numbers
entered into a cell are automatically right aligned.
9. If A1:A5
contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display 20
.
10. In Relative referencing, the reference changes rows and
columns automatically when it is copied to a new cell.
C. State whether the
statements given below are True or False.
1. A cell is a combination of row and column. False
2. A spreadsheet is also called as worksheet.
True
3. There are ‘n’ number of sheets in a
spreadsheet. False
4. In
a spreadsheet, we can change the column width and row height. True
5. $A1$B2 is an example of mixed referencing.
True
D. Short answer questions (50
words)
1.
Cell A1
contains the number 10 and B1 contains 5. What will be the contents of cell C1,
if the formula =A1+B1*2^3 is entered in cell C1?
Ans: 50
2.
The contents of Cell A1, B1, C1 and D1 are 5,
–25, 30 and –35, respectively. What will be the value displayed in cell E1
which contains the formula =MIN(A1:D1).
Ans: -35
3.
Cell D5 contains the formula =$B$5+C5 and this
formula is copied to cell E5, what will be the copied formula in cell E5?
Ans: =$B$5 +
D5
4.
Cell D5
contains the formula =$B5 + C5 and this formula is copied to cell E5, what will
be the copied formula in cell E5?
Ans: =$B5 +
D5
5.
Cell D5 contains the formula =$B5 + C$5 and
this formula is copied to cell E6, what will be the copied formula in cell E6?
Ans: $B5 +
D5
E. Short answer questions (50
words)
1. What do
you call the document created in a spreadsheet application?
Ans: Workbook. We call the 'Spreadsheet Document' as 'Workbook'
2. What are
the steps to create a new spreadsheet?
Ans: Use File > New on the Menu bar and select
the type of document from the context menu. Use the keyboard shortcut Ctrl+N
to create a new document. The type of document created depends
on which LibreOffice component is open and active. For
example, if Calc is open and active, a new spreadsheet is
created.
3. What is
the difference between spreadsheet, worksheet and sheet?
Ans:
Spreadsheet :’ Spreadsheet
is a long sheet of rows and columns on the computer screen to do data analysis
and calculation. In other words, a spreadsheet is a grid which interactively
manages and organises data in rows and columns. It is also called as Electronic
Spreadsheet.
Worksheet : The worksheet in Calc is also referred to as
spreadsheet. The spreadsheet can have many sheets. Each sheet can have many
individual cells arranged in rows and columns. The sheet tab shows its default
name as Sheet1, Sheet2, Sheet3, ….
Sheet : sheet containing cells arranged in rows
and columns. A particular cell is identified by its row number and column letter.
Cells hold the individual elements – text, numbers, formulas, and so on – that
make up the data to display and manipulate.
4. What is
the default name of the worksheet? How can it be renamed?
Ans: By default, Excel names worksheets Sheet1, Sheet2, Sheet3 and
so on, but you can easily rename them. Double-click the sheet tab, and type the
new name. Right-click the sheet tab, click Rename, and type the new name.
5. Write the
steps to insert and delete the worksheet in Calc.
Ans: Steps to insert the worksheet in calc :
1.
Select on the Insert tab and
choose Sheet, or.
2.
Click Right mouse button on
the sheet tab and choose Insert Sheet, or.
3.
Choose an empty space at the
end of the line of sheet tabs.
Steps to
delete the worksheet in calc :
1.
select on the insert tab
and chosse sheet, or
2.
Click Right mouse button on
the sheet tab and chosse insert Sheet, or.
3.
Choose an empty space at the
end of the line sheets tabs
6. What is
an active cell? How to delete the contents of an active cell?
Ans: Active
cell: In a spreadsheet, cell is the
place where we enter the data. Before entering any data in the cell, it has to
be first selected by placing a cursor on it. When we position the mouse cursor
on a cell, it gets selected, and is ready to take data from the user. This
selected or activated cell is called as active cell. It is always highlighted,
with a thick border. The address of the active cell is displayed in the name
box. For example -- B3 as the active cell in the worksheet.
To delete
the contenmts of an active cell :
If you want to delete the content
of an active cell, then select the cell and right-click
and choose delete cell. The contents will get
deleted from the cell leaving the formats.
7. What is
relative and absolute cell address in the spreadsheet?
Ans: Relative Referencing 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. Almost all spreadsheet applications use
relative referencing by default.
Absolute
referencing: 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. This type of
referencing is used in higher classes.
8. Explain
any two operations performed on data in a spreadsheet.
Ans: A spreadsheet is a software application used to store, organize and
analyze data values in tabular form. The spreadsheet
operates on data present in the table cells.
Formulas and functions are two main operations performed on data in a
spreadsheet .
A spreadsheet is a software application used to stay organised and
analyse data values in tabular form is called formula .
functions like sum count average Max and mine are predefined formula
used in the spreadsheet .
9. How do formulae work in a spreadsheet?
Ans: When creating formulas in Open Office Calc, you always start by typing the equals sign. Type it in the
cell where you want the answer to appear. ... Press Enter to complete the formula. You should see in the Formula bar above the worksheet the newly created formula, but in cell C3 will be the result of this formula.
10. Can you
include more than one mathematical operators in a formula?
Ans: A complex formula has more than one mathematical operator, such as 5+2*8. When there is more than one operation in a formula, the order of operations tells your spreadsheet
which operation to calculate first.
11. How to
make visible the desired toolbar a spreadsheet?
Ans: Use the "Ctrl+F1" key to make visible and hide the desired toolbar commands in a spreadsheet. Click Show Tabs is used to display the "Ribbon"
tabs without using the commands. To invoke the commands in the "Show
Tabs" option, then click the required tab.
12. Give the syntax and example of any three
mathematical functions in spreadsheet.
Ans: The syntax and example of any three mathematical functions in
spreadsheet are as follows:
SUM(): This is a function which is used to add all the values within a range of cells. ...
COUNT(): It is used to count the number of data. ...
AVERAGE(): This function is used to find the average of a given number of cells.
13. Give the
syntax and example of any three statistical functions in spreadsheet.
Ans: SQRT(4)
This function can be entered in any cell and will return 2.
SQRT(B1)
This returns the square root of the value in cell B1.
SQRT(4+B1)
This returns the square root of 4 plus the value in cell B1. The parameter to
this function is called an Expression.
SUM(F4:F24)
Thus returns the sum of cells F4 through F24.
14. Give the
syntax and example of any three decision making functions in spreadsheet.
Ans: IF,
IFERROR, AND are the three decision-making functions.
Explanation:The three decision-making functions
are as follows :
1)
IF: verifies whether a condition is met or not. If the condition is met returns
true. If the condition is not met returns false. The syntax :
=IF(condition,[value if true],[value if false]). Example :
IF(ISNUMBER(100),"Yes","No"). If the number is 22 it will
return Yes.
2)
IFERROR: returns the expression value if no error occurs otherwise returns the
error value. Syntax : =IFERROR(expression,[error value]). Example :
=IFERROR(1/0,"Divide by zero error"). It will return the text
"Divide by zero error".
3)
AND : checks multiple condtions and returns true if all the conditions are
true. Syntax : =AND(condition1,condtion2). Example : =AND(1>0,2<5). As
both the conditions are true it will return True.
15. Give the syntax and example of any three
date and time functions in spreadsheet.
Ans: Date
& Time Functions
Explanation:
Year,
Month, Day. To get the year of a date, use the YEAR function. ...
Date
Function. To add a number of days to a date, use the following simple formula.
...
Current
Date & Time. To get the current date and time, use the NOW function. ...
Hour,
Minute, Second. To return the hour, use the HOUR function. ...
Time
Function.
16. Give the syntax and example of any three
logical functions in spreadsheet.
Ans: The
three types of logical functions in spreadsheet and their examples are as
follows:
·
AND: If all conditions are true, the logical AND
function returns TRUE and if any condition is false it returns FALSE.
Syntax: =AND (condition1, [condition2], ...)
Example: =AND(A3>=6, B5<=6)
Description: If the value of cell A3 is greater or equal
to 6, and the value of cell B5 is smaller or equal to 6, the formula returns
TRUE. FALSE otherwise.
·
OR: The logical OR function returns TRUE where
one of the terms is TRUE and returns FALSE if every condition is false.
Syntax: =OR (condition1, [condition2], ...)
Example: =OR(A1>=7, B3<=8)
Description: The formula returns TRUE if A1 surpass or equal
to 7 or B3 is smaller or equals eight, or both conditions have been
fulfilled. The formula is returned FALSE if none of the conditions are met.
·
NOT: The logical NOT function reverses the value
that is true to false and false to true.
Syntax: =NOT (condition)
Example: =NOT(A4>15)
Description: The formula returns FALSE if a cell A4 value
exceeds 15; otherwise, it returns TRUE.
17. Give the
syntax and example of any three string functions in spreadsheet.
Ans: string
function in Excel are as follows-
(1)
len- len function in Excel helps you to to know the length of a string that is
number of characters in a string.
(2)-
MID( )- mid functions in Excel are used to extract the character from the
middle of a string.
(3)-Left
( )- left function in Excel is used to extract the left character from a
string.
18. Explain
the advantages of drawing a chart in Calc.
Ans: It is very beneficial to draw a chart in Calc as calculations can be done easily. It is
numerical and If you have jotted down the right formula it will calculate the
solution for you. It shows the data in a very sophisticated manner.
19. Explain
in one line each the various types of charts.
Ans: various
types of chats in a speadsheet are
1.
The Pie Chart--- A
Pie Chart can only display one series of data. A data series is a row or column
of numbers used for charting. Excel uses the series identifier (column or row
heading) as the chart title
2.
The Column Chart
---- The Column Chart very effectively shows the comparison of one or more series
of data points. But the Clustered Column Chart is especially useful in
comparing multiple data series.
3.
The Line Chart
----- The Line Chart is especially effective in displaying trends. In a Line
Chart, the vertical axis (Y-axis) always displays numeric values and the
horizontal axis (X-axis) displays time or other category.
4.
The Bar Chart----
The Bar Chart is like a Column Chart lying on its side. The horizontal axis of
a Bar Chart contains the numeric values.
5.
The Area Chart
---- Area Charts are like Line Charts except that the area below the
plot line is solid. And like Line Charts, Area Charts are used primarily to
show trends over time or other category.
6.
The Scatter Chart
----the purpose of a Scatter Chart is to observe how the values of two
series compares over time or other category
20. Write the steps to insert a chart in Calc.
Ans: Follow
the steps given below to create charts.
• Select the range of data (A1:F7)
• Insert → Chart
• Select the type of chart
• Select the chart (Column Chart)
• Click finish. A chart will be displayed.
21. Name and
explain any five components of a chart in a spreadsheet package.
Ans:
chart components
·
Chart area.
·
Chart title.
·
Legend.
·
Axis title.
·
Axis lines/values.
·
Tick marks.
·
Plot area.
·
Chart series
