New Spreadsheet can be created in following ways : What are the steps to create a new spreadsheet?Īns. The document created in a spreadsheet application is called Workbook. What do you call the document created in a spreadsheet application?Īns. =$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?Įlectronic Spreadsheet Class 9 Solutions Electronic Spreadsheet Class 9 Solutions E. =$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?Īns. 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?Īns. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1).Īns. 50 2) The contents of Cell A1, B1, C1 and D1 are 5, –25, 30 and –35, respectively. What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?Īns. Solve the following in a spreadsheet 1) Cell A1 contains the number 10 and B1 contains 5. (True) Electronic Spreadsheet Class 9 Solutions D. (True) 5) $A1$B2 is an example of mixed referencing. (False) 4) In a spreadsheet, we can change the column width and row height. (True) 3) There are ‘n’ number of sheets in a spreadsheet.
(False) 2) A spreadsheet is also called as worksheet. State whether the following statements are True or False 1) A cell is a combination of row and column. Electronic Spreadsheet Class 9 Solutions C. 10) In relative referencing, the reference changes rows and columns automatically when it is copied to a new cell. 9) If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then = Average(A1:A5 60) will display 20. 8) Numbers entered into a cell are automatically rightaligned. 7) $A1$B2 is an example of mixed referencing in spreadsheet software. 6) The cell address of the cell formed by the intersection of the ninth column and the eighth row will be I8. On copying this formula to cell C2, C2 will change to =D2 + E3. 4) The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to =MIN(D1:D5).
#Delete and rename tabs in freeoffice series
3) The spreadsheet feature used to continue the series is called as Fill Handle. 2) The default extension of a workbook created using a LibreOffice Calc spreadsheet is. Fill in the blanks 1) The column immediately next to column “Z” is AA. (d) All of these Electronic Spreadsheet Class 9 Solutions B. (d) Four 14) The chart preview can be seen in_. (d) All of the these 12) Which of the following option is used to print a chart?ġ3) How many axes does charts in Calc have? (d) Depends on the function Electronic Spreadsheet Class 9 Solutions 11) A function should start with _. (b) Using function wizard or selecting from toolbar (a) Directly typing function name in a cell 10) What is the correct way to enter a function in Calc?
(c) The cell columns are changed at destination. (a) The cell row and columns are changed at destination. We can calculate the total of values by all the methods given above (a, b, c, d) 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?
obj 8) How can one calculate the total of values entered in a worksheet column of?Īns. (d) Cannot determine 7) Which of the following is an extension of a worksheet created in Calc? (d) Validating Electronic Spreadsheet Class 9 Solutions 6) Which of the following type of package does Calc refer to? (d) Validating 5) What is the name of mechanism to filter out unnecessary data? (d) By preview command 4) What is the name of mechanism to arrange the data in a particular order? (d) Delete me 3) We can replace multiple occurrences of a word using which of the following facilities of Calc? (d) Data validation 2) Which of the following options when selected deletes all data validation? Multiple Choice Questions 1) Which of the following technique can be used to allow only date value in cell? OptionButton3.Electronic Spreadsheet Class 9 Solutions Electronic Spreadsheet Class 9 Solutions A. 'the page body begins where the tabs normally appear. 'Note that the page borders are invisible and 'Note that the page borders are invisible The user chooses a style by selecting an OptionButton. This example also demonstrates using a Label. The example below uses the Style property to specify the appearance of the tabs in MultiPage and TabStrip.
0 kommentar(er)
