CBSE-IX-Foundation of Information Technology .
11: MS-Excel 2007
Note: Please signup/signin free to get personalized experience.
Note: Please signup/signin free to get personalized experience.
10 minutes can boost your percentage by 10%
Note: Please signup/signin free to get personalized experience.
- #Foundation of Information Technology - MS-Excel 2007
- #Section : AVery Short Answer Type Questions
- Qstn #1Define the term workbook.Ans : A workbook is a collection of worksheets. By default, there are three worksheets in every workbook.
- Qstn #2Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. Help Reena in identifying the active cell on her screen.Ans : An active cell is a cell with heavy black color boundary.
- Qstn #3What is the default alignment of number, text and formula in a spreadsheet?Ans : Default alignment of text or label entry is left alignment and for numbers and formula it is right alignment.
- Qstn #4Elaborate the formatting necessary.Ans : With formatting, we can make some data to be bolder, rotated or in different color. So, basically formatting provides worksheet a neater and more legible outlook.
- Qstn #5Soham has clicked on the cell residing at the intersection of first row and ninth column. What will be the address of the selected cell?Ans : First row and ninth column address will be II.
- Qstn #6How many ways are there for adding a new worksheet in an Excel workbook?Ans : There are two methods of adding a new worksheet iasm Excel workbook; Insert worksheet tab at the bor >m and Insert button on cells group under Home tab.
- Qstn #7In Excel, how many ways are there to express/format a number?Ans : Numbers in Excel can be expressed in many different formats like date, time, percentage or decimals.
- Qstn #8Name the toolbar of spreadsheet which has all the options of changing the font properties.Ans : Formatting Toolbar
- Qstn #9What 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.
- Qstn #10How many cells would be there in the cell range [A1 ; B2]?Ans : There would be 4 cells in the given cell range.
- Qstn #11The cell A1 has value Monday. If you are asked to click and drag the Fill handle of A1 downside then what will be the contents of cell A2, A3, A4 and A5?Ans : Cells A2, A3, A4 and A5 will contain Tuesday, Wednesday, Thursday and Friday respectively.
- Qstn #12If = 6 -5 *2 is entered in a cell, then what will be the cell content?Ans : -4 will be contained in cell as a result.
- Qstn #13In a spreadsheet software, the formula =A1 +$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.