Electronic Spreadsheet Class 9 IT 402
Electronic Spreadsheet questions and answers for class 9 IT 402. In class 9 IT 402 there are two parts one is Employability Skills and the other is Subject Specific skills. In the second part of IT 402, The chapter is an Electronic Spreadsheet for class 9. Here you will get complete questions whit their answers. Go through this information for free, all the questions and answers are according to the new CBSE term wise examination pattern class 9.
MCQs for Electronic Spreadsheet class 9
Q1. It shows the cell reference.
(a) Name box
(b) Function wizard
(c) Formula
(d) Input line
Ans. (a) Name box
Q2. Which of the following is/are mathematical operators?
(a) Addition
(b) Subtraction
(c) Multiplication
(d) All of these
Ans. (d) All of these
Q3. Format Cells can also be opened by the _____ shortcut key.
(a) Ctrl + 1
(b) Ctrl + 2
(c) Ctrl + 3
(d) Ctrl + 4
Ans. (a) Ctrl + 1
Q4. $A$6 is an example of
(a) Relative referencing
(b) Absolute referencing
(c) Mixed referencing
(d) None of these
Ans. (b) Absolute referencing
Q5. Which of the following technique can be used to allow only date value in a cell?
(a) Data formatting
(b) Data sorting
(c) Data filtering
(d) Data validation
Ans. (a) Data formatting
Q6. 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
Q7. We can replace multiple occurrences of a word using which of the following facilities of Calc?
(a) Find & Replace
(b) By replacing only
(c) By copy command
(d) By preview command
Ans. (a) Find & Replace
Q8. What is the name of the mechanism to arrange the data in a particular order?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating
Ans. (a) Sorting
Q9. What is the name of the mechanism to filter out unnecessary data?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating
Ans. (c) Filtering
Q10. Which of the following type of packages does Calc refer to?
(a) Spreadsheet
(b) Double sheet
(c) Multi-sheet
(d) Cannot determine
Ans. (a) Spreadsheet
Q11. Which of the following is an extension of a worksheet created in Calc?
(a) .ods
(b) .odd
(c) .xls
(d) .obj
Ans. (a) .ods
Q12. How can one calculate the total of values entered in a worksheet column?
(a) By manual entry
(b) By auto-sum
(c) By formula
(d) By sum function
Ans. (d) By sum function
Q13. 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 the destination.
(b) The cell row change at the destination.
(c) The cell columns are changed at the destination.
(d) No change will scour.
Ans. (a) The cell row and columns are changed at the destination.
Q14. 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 the toolbar
(c) Both (a) and (b)
(d) Depends on the function
Ans. (d) Depends on the function
Q15. A function should start with
(a) '=' sign
(b) alphabets
(c) numbers
(d) All of these
Ans. (a) '=' sign
Q16. 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
Q17. How many axes do charts in Calc have?
(a) Two
(b) Three
(c) Two or three
(d) Four
Ans. (a) Two
Q18. 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
Q19. A worksheet is a
(a) collection of workbooks
(b) processing software
(c) combination of rows and columns
(d) None of the above
Ans. (c) combination of rows and columns
Q20. The simplest way to move data from one location to another in Calc is
(a) by Quick Access toolbar
(b) using Cut and Paste
(c) by the drag and drop method
(d) Both (b) and (c)
Ans. (d) Both (b) and (c)
Q3. The AutoFill can apply from
(a) left to right
(b) right to left
(c) up to down
(d) All of these
Ans. (d) All of these
Q4. The default page orientation in Calc is
(a) Landscape
(b) Horizontal
(c) Portrait
(d) None of these
Ans. (c) Portrait
Q5. Cell address $B$5 in a formula means
(a) it is a mixed reference
(b) it an absolute reference
(c) it is a relative reference
(d) None of the above
Ans. (b) it is an absolute reference
Q6. While entering a formula, cell address B$5 represents
(a) Absolute Referencing
(b) Mixed Referencing
(c) Relative Referencing
(d) All of these
Ans. (b) Mixed Referencing
Q7. A cell range starting from the first row, the first column to the fourth row and fifth column can be represented as
(a) [Al : E4]
(b) [A0: E3]
(c) [E4: Al]
(d) [E3: A0]
Ans. (a) [Al : E4]
Q8. A cell range always has the _______ symbol between the cell references.
(a) ; (semicolon)
(b) . (full stop)
(c) , (comma)
(d) : (colon)
Ans. (d) : (colon)
Short Answer Type Questions for Electronic Spreadsheet class 9
Q1. What is a cell address?
Ans. A cell address is denoted by its column (letter) and row number. e.g. A4, B5, G5, H3, S70, Z20 etc.
Q2. What is the use of the Page Up key?
Ans. Page Up Key is used to move the worksheet one screen up.
Q3. What is the formula?
Ans. If you click on the formula icon then it inserts an equal '=' sign into the selected cell and the input line allows the formula to be entered.
Q4. How many cells are there in range A2:B4?
Ans. 6 cells are there in range A2:B4, that is A2, A3, A4, B2, B3, and B4.
Q5. What is the use of the Average () function?
Ans. The Average () function is used to find out the average of the values contained in a range of cells.
Syntax =AVERAGE(Number1, Number2, Number3, ....)
Q6. Give one difference between MAX () and MIN ().
Ans. MAX () function is used to find out the largest value contained in a range of cells. MIN () function is used to find out the smallest value contained in a range of cells.
Q7. Define line chart.
Ans. Line chart tends to emphasize the rate of change rather than the volume of change over time.
Q8. Which shortcut key is used to start LibreOffice Help?
Ans. The F1 key is used to start LibreOffice Help.
Q9. What do you call the document created in a spreadsheet application?
Ans. Worksheet
Q10. What are the steps to create a new spreadsheet?
Ans.
Q11. What is the difference between spreadsheet and worksheet?
Ans. Differences between Spreadsheet and worksheets are as follows:
Spreadsheet: A spreadsheet is a Calc file with one or more worksheets. A spreadsheet would be the entire binder, with everything in it.
Worksheet: A worksheet is a single spreadsheet of data. A worksheet would be like one section in that binder.
Q12. What is the default name of the worksheet? How can it be renamed?
Ans. The default name of the worksheet is Untitled X, where X is a number. It can be renamed by saving this worksheet with another name.
Q13. Write the steps to insert and delete the worksheet in Calc.
Ans. Step to insert worksheet in Calc:
- Click right mouse button on the Sheet tab and choose Insert sheet.
Step to delete worksheet in Calc:
- In the Sheet tab, clicks the right mouse button and choose Delete from the pop-up menu.
Q14. What is an active cell? How to delete the contents of an active cell?
Ans. In a spreadsheet, the 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 an active cell.
To delete the contents of an active cell, right-click on the active cell and choose the Clear Contents option from the context menu.
Q7. What is the relative and absolute cell address in the spreadsheet?
Ans.
Q8. Explain any two operations performed on data in a spreadsheet.
Ans. Formulas and functions are two main operations performed on data in a Spreadsheet.
Formulas: These are equations that perform calculations on values in the worksheet. It is an order of values, names, cell references, functions and operations in a cell that together give a new value.
Functions: These are predefined formulas that perform calculations using specific values in a particular order.
Q9. How do formulae work in a spreadsheet?
Ans.
Q10. Can you include more than one mathematical operator in a formula?
Ans. Yes, more than one mathematical operator in a formula can be included.
e.g. Suppose cells Al, B1 and C1 contain the values 10, 5 and 6 respectively. Cell DI has formula = Al * B1 + C1, which include two mathematical operators * and +. The result of cell D1 will be 56.
Q11. How to make visible the desired toolbar in a spreadsheet?
Ans. To make visible the desired toolbar in a spreadsheet, use the keyboard shortcut Ctrl + F1.
Q12. Give the syntax and example of any three mathematical functions in the spreadsheet.
Ans. (i) SUM () It adds the values contained in a range of cells.
Syntax = Sum (Number 1, Number 2 , ...)
e.g. If cells Al = 5, Bl = 5 and Cl = 5 then function = SUM (Al, B1, Cl) will give the result 15.
(ii) Average () It finds out the average of the values contained in a range of cells.
Syntax = AVERAGE (Number 1, Number 2, ...)
e.g. If cells Al = 6, B1 = 4 and Cl = 2 then function = AVERAGE (Al, Bl, Cl) will give result 4.
(iii) COUNT () It counts the number of cells within a range of cells.
Syntax = COUNT (Number 1, Number 2, ...)
e.g. If cells Al = 2, B 1 = 4 and Cl = 1 then function = COUNT (Al, Bl, Cl) will give result 3.
Q18. Explain the advantages of drawing a chart in Calc.
Ans. The advantage of drawing a chart in Calc are as follows:
- It is easy to use
- It shows the data in a very sophisticated manner.
- Charts help to forecast the trends on the basis of comparisons done.
- It is easy for the users to compare the information.
Q19. Explain in one line each the various types of charts.
Ans. Refer to text on Page 169.
Q20. Write the steps to creating a chart in Calc.
Ans. Refer to text on Page 170. 21.
Q. Name and explain any five components of a chart in a spreadsheet package.
Ans. Refer to text on Pages 169 and 170.
Very Short Answer
Q1. Reena is new to Calc. Her instructor has asked her to open Calc on her PC and questioned about the active cell. Help Reena in identifying the active cell on her screen.
Ans. An active cell is a cell with a heavy black color boundary.
Q2. What is the default alignment of numbers, text and formulas in a spreadsheet?
Ans. The default alignment of text or label entry is left alignment and for numbers and formula, it is right aligned.
Q3. Soham has clicked on the cell residing at the intersection of the first row and ninth column. What will be the address of the selected cell?
Ans. The first row and ninth column address will be I1.
Q4. How many ways are there for adding a new worksheet in a Calc workbook?
Ans. There are two methods of adding a new worksheet in a Calc workbook; Insert worksheet tab at the bottom and Insert Sheet option under Sheet tab.
Q5. In Calc, how many ways are there to express/format a number?
Ans. Numbers in Calc can be expressed in many different formats like date, time, percentage or decimals.
Q6. What do you mean by relative referencing?
Ans. Cell referencing in which the cells are referred by their relative position in the worksheet relative to a particular cell is called relative referencing.
Q7. How many cells would be there in the cell range [Al: B2]?
Ans. There would be 4 cells in the given cell range.
Q8. The cell Al has value Monday. If you are asked to click and drag the fill handle of Al downside then what will be the contents of cells A2, A3, A4 and A5?
Ans. Cells Al, A3, A4 and AS will contain Tuesday, Wednesday, Thursday and Friday respectively.
Q9. If = 6 -5 *2 is entered in a cell, then what will be the cell content?
Ans. -4 will be contained in the cell as a result.
Q10. In a spreadsheet software, the formula -Al + $A$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3?
Ans. =B1+$A$2 will be copied into B3.
Q11. Write down the formula for adding values of cells Al to A5.
Ans. The formula for adding values of cells Al to AS would be =SUM(A1: A5).
Q12. What will be the column names of the below statement?
(i) 26th column (ii) 28th column
Ans. (i) Z (ii) ) AB
Short Answer