Page 328 - TP_IT_V1.0_C9_flipbpookl
P. 328
6. The column immediately next to column “Z” is .
7. The shortcut key to create a new spreadsheet is .
8. The spreadsheet's feature used to fill the series is called .
9. The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to .
10. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, the formula will change to .
11. The cell address of the cell formed by the intersection of the tenth column and the eighth row will be .
12. $A1$B2 is an example of referencing in spreadsheet software.
13. Numbers entered into a cell are automatically aligned.
14. If A1:A5 contains the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5,60) will display .
15. In referencing, the reference changes rows and columns automatically when it is copied to a new cell.
Ans. 1. cell range 2. Formatting Toolbar 3. Charts 4. mathematical 5. Column chart
6. AA 7. Ctrl + N 8. Autofill 9. =min(D1:D5) 10. =D2+E3
11. J8 12. mixed 13. right 14. 20 15. relative
C. Match the following
1. Ctrl + Shift + S a. Right aligned
2. Numbers b. File, Edit
3. A45 c. Sheet
4. Rows and Columns d. Save As
5. Menu Bar e. Cell address
Ans. 1. d 2. a 3. e 4. c 5. b
D. State whether the following statements are true or false:
1. The F3 key is used to edit the current cell's data.
2. =B4+B5 is an example of a function in a spreadsheet.
3. SUM() returns the count of the number of cells that contain number values.
4. New column can be inserted from the Insert menu.
5. Semicolon (;) is used to separate the arguments in a function.
6. A cell address is made up of a row and a column.
7. Align Right option aligns the selected text to the right within a cell.
8. There are a fixed number of sheets in a spreadsheet and you cannot add more.
9. In a spreadsheet, we can change the column width and row height.
10. To show the preceding ‘0’, the data type has to be specified as ‘Text’.
Ans. 1. False 2. False 3. False 4. True 5. True 6. True 7. True 8. False
9. True 10. True
E. Solve the following in a spreadsheet:
1. If 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?
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)?
3. If 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?
4. If cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?
326 Trackpad Information Technology (Ver. 1.0)-IX

