CH – 4 Electronic spreadsheet
Fill in the blanks
1.The column immediately next to column “Z” is __AA___.
2 .The default extension of a workbook created using a Libre Office 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 _i8_.
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.
B . State whether the following statements 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
C. 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? =A1 +B1*2^3 , =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). (-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? =$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? =$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? $B6 + D$5
QUES /ANS
1.What is the default name of the worksheet? How can it be renamed
Ans – the default name of the worksheet is Sheet 1 , Sheet2 , Sheet3 …..etc.
Steps to rename a sheet ( worksheet ):-
Step1 → select the menu ‘sheet’.
Step2 → now click on option rename sheet
Step3 → A dialog box will appear . Give a appropriate name to worksheet and click ‘ok’.
2.What is an active cell? How to delete the contents of an active cell?
Ans- 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 .
To delete the content of an active cell .
Step1→ right click on active cell.
Step2 →click on ‘ clear content ‘ option or press backspace.
Step3 → A dialog box will appear choose whether you want to delete all or particular text ,number etc.
Step4 → click on 'OK' the content will be deleted from an active cell.
3. What is relative and absolute cell address in the spreadsheet?
Ans – relative cell reference – a relative cell reference of a cell address in a formula means that when the formula is copied to any other worksheet cell , the cell addresses in the formula automatically changes according to their position relative to the cell containing the formula .
For eg - if a formula = B4*C1 in a cell address C4 is copied into the cells C5 ,then the cell of the formula will change to = B5 * C5 .
Absolute cell reference – An absolute cell reference of a cell address in formula means that when the formula is copied to any other worksheet cell , the cell address in the formula do not change according to their position relative to the cell containing the formula . To make a cell address absolute dollar sign ($) is used before the column name as well as row number to make it constant in any formula .
4.Write the steps to insert a chart in Calc
Ans – following are the steps to insert a chart in calc :-
Step1 → select the range of data .
Step 2 → click on insert tab .
Step3 → Now , click on ‘chart’ option
Step4 → select the type of chart you want to insert
Step 5 →
click on finish , chart will be inserted .
5 .Can you include more than one mathematical operators in a formula?
Ans- yes, we Can include more than one mathematical operators in a formula .
