Class 9 IT-ITeS Chapter 4 | Electronic Spreadsheet Question Answer: Welcome to our website! We are happy to provide you with Class 9th IT-IteS(NSQF) Notes for your academic journey. Class IX is an essential year for learners as they prepare themselves for the upcoming board exams, which will determine their academic success.
Today, I will discuss your Class 9th “Electronic Spreadsheet” Long and Short Questions| We provide solutions for almost all long and short questions.
Our goal is to meet your needs. We provide the Notes here for free. We wish you all the best for your upcoming exams. If you have any doubts, don’t hesitate to get in touch with us.
Electronic Spreadsheet Textbook Question Answer
A. 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 (c) 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 (c) By copy command
(b) By replace only (d) By preview command
Ans: (c) By copy command
4. What is the name of the mechanism to arrange the data in a particular order?
(a) Sorting (c) Filtering
(b) Searching (d) Validating
Ans: (a) Sorting
5. What is the name of mechanism to filter out unnecessary data?
(a) Spreadsheet (c) Multi-sheet
(b) Searching (d) Validating
Ans: (d) Validating
6. Which of the following type of package does Calc refer to?
(a) Spreadsheet (c) MultiSheet
(c) Double Sheet (d) Cannot determine
Ans: (d) Cannot determine
7. Which of the following is an extension of a worksheet created in Calc?
(a) .ods (c) .xls
(b) .odd (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 the destination.
(b) The cell row change at the 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
B. Fill in the blanks
1. The column immediately next to column “Z” is_________.
Ans: AA
2. The default extension of a workbook created using a LibreOffice Calc spreadsheet is_______.
Ans: .Ods
3. The spreadsheet feature used to continue the series is called as_____.
Ans: Fill Handle.
4. The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to______.
Ans: =MIN(D1: D5)
5. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to______.
Ans: =D2 + E3
6. The cell address of the cell formed by the intersection of the ninth column and the eighth row will be_______.
Ans: I8
7. $A1$B2 is an example of_____referencing in spreadsheet software.
Ans: mixed
8. Numbers entered into a cell are automatically______aligned.
Ans: Right.
9. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average (A1:A5;60) will display_____.
Ans: 20
10. In_______referencing, the reference changes rows and columns automatically when it is copied to a new cell.
Ans: Relative.
C. State whether the following statements are True or False
1. A cell is a combination of row and a column.
Ans: True.
2. A spreadsheet is also called as worksheet.
Ans: True.
3. There are ‘n’ number of sheets in a spreadsheet.
Ans: True.
4. In a spreadsheet, we can change the column width and row height.
Ans: True
5. $A1$B2 is an example of mixed referencing.
Ans: False.
D. Solve the following in a spreadsheet
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:
- Open Microsoft Excel and create a new workbook.
- Enter the value 10 in cell A1 and 5 in cell B1.
- Click on cell C1 to select it.
- In the formula bar (located above the worksheet), enter the formula “=A1+B1*2^3”.
- Press Enter or Return to execute the formula.
After entering the formula, Excel will automatically calculate the result and display it in cell C1. In this case, the contents of cell C1 will be 50(=>10+5*8=>10+40=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:
To solve this Excel problem, we have the following data:
Cell A1: 5 Cell B1: -25 Cell C1: 30 Cell D1: -35
In cell E1, we need to calculate the minimum value among the values in cells A1 to D1 using the MIN function.
- Select cell E1.
- In the formula bar, enter the formula “=MIN(A1:D1)”.
- Press Enter or Return to execute the formula.
The MIN function in Excel returns the smallest value in a given range.
In this case, the formula “=MIN(A1:D1)” will calculate the minimum value among the values in cells A1 to D1.
Calculating the minimum:
MIN(5, -25, 30, -35) = -35
Therefore, the value displayed in cell E1 will be -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: When the formula =$B$5+C5 in cell D5 is copied to cell E5, the formula will adjust relative references and keep absolute references.
In this case, the formula =$B$5+C5 contains an absolute reference to cell B5 ($B$5) and a relative reference to cell C5 (C5).
When the formula is copied from cell D5 to cell E5, the relative reference C5 will adjust based on the relative position of the cells.
So, the copied formula in cell E5 will be =$B$5+D5. The absolute reference to cell B5 ($B$5) remains the same, and the relative reference to cell C5 (C5) changes to D5 based on the new cell position.
B5 | B5 | D5(cell) =$B$5+C5 | E5(cell) =$B$5+D5(Ans)
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:
When the formula =$B5+C5 in cell D5 is copied to cell E5, the formula will adjust both relative references.
In this case, the formula =$B5+C5 contains a mixed reference to column B ($B) and relative references to row 5 (5) for both B5 and C5.
When the formula is copied from cell D5 to cell E5, both the column and row references will adjust based on the relative position of the cells.
So, the copied formula in cell E5 will be =$C5+D5. The column reference B adjusts to C, and the row references 5 remain the same.
Note: If the formula in cell D5 is copied to a different row, the row reference 5 will adjust accordingly. For example, if copied to cell E6, the formula would become =$B6+C6.
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: When the formula =$B5+C$5 in cell D5 is copied to cell E6, the formula will adjust both relative and absolute references.
In this case, the formula =$B5+C$5 contains a mixed reference to column B ($B) and a mixed reference to row 5 (C$5). Column reference B is absolute, while row reference 5 is relative.
When the formula is copied from cell D5 to cell E6, both the column and row references will adjust based on the relative position of the cells.
So, the copied formula in cell E6 will be =$C6+C$5. The column reference B adjusts to C, and the row reference 5 remains the same as an absolute reference with the dollar sign.
This means that the column reference will adjust while moving horizontally (from D to E), and the row reference will remain the same while moving vertically (from row 5 to row 6).