Q.10. Discuss the orientation in MS-Word.
Ans. Orientation determines that a document will be printed on a paper length-wise or widthwise. There are two orientations, i.e. Portrait (for length-wise printing) and landscape (for width-wise printing). The default orientation is portrait. You can choose one of them, from the ‘Page setup’ dialog box in ‘Orientation’ frame.
When you change the orientation for a page, then MS-Word changes the top and bottom margins with left and right margins and vice versa.
Q.11. What is desktop publishing?
Ans. Desktop Publishing (also known as DTP) is the creation of documents using page layout software on a personal computer.
The term has been used for publishing at all levels, from small-circulation documents such as local news letters to books, magazines and newspapers. However the term implies a more professionallooking end result, with a more complex layout, than word processing and so when introduced in the 1980s was often used in connection with homes and small organisations who could not previously produce publication quality documents themselves.
Q.12. Define the term spreadsheet.
Ans. A spreadsheet is a computer application that simulates a paper accounting worksheet.
It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns. Each cell contains alphanumeric text, numeric values or formulas. A formula defines how the content of that cell is to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated. Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made.
Q.13. What is database package?
Ans. The database package accommodates business requirements that need advanced web features such as databases and custom CGI scripts. This package includes all of the above packages as well as database support for advertising more than two hundred products or to offer other advanced services which require quick access to large amounts of data. Some DBMS softwares are ORACLE, MS-SOL FoxPro, dBase, FoxBASE, etc.
Q.14. Discuss about the spreadsheet packages.
Ans. Visicalc is the first electronic spreadsheet on a microcomputer and it helped turn the Apple II computer into a success and greatly assisted in their widespread applications. Visicalc was the first spreadsheet that combined all essential features of modern spreadsheet applications, such as WYSIWYG interactive user interface, automatic re-calculation, status and formula lines, range copying with relative and absolute references, formula building by selecting referenced cells. Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Excel now has the largest market share on the Windows and Macintosh platforms.
Q.15. Write a short note on the data format in MS-Excel.
Ans. A cell or range can optionally be defined to specify how the value is displayed. The default display format is usually set by its initial content it not specifically previously set, so that for example ’31/08/2011′ or ’31 August, 2011′ would default to the cell format of ‘date’. Similarly adding a% sign after a numeric value would tag the cell as a percentage cell format. The cell contents are not changed by this format but only the displayed value.
Some cell formats such as ‘Numeric’ or ‘Currency’ can also specify the number of demical places.
Q.16. Write a short note on the cell formatting in MS-Excel.
Ans. Depending on the capability of the spreadsheet application, each cell (like its counterpart the ‘Style’ in a word processor) can be separately formatted using the attributes of either the content (point size, colour, bold or italic) or the cell (border thickness, background shading, colour). To aid the readability of a spreadsheet, cell formatting may be conditionally applied to data, for example, a negative number may be displayed in red.
A cell’s formatting does not typically affect its content and depending on how cells are referenced or copied to other worksheets or applications, the formatting may not be carried with the content.
Q.17. Write the steps of working with a spreadsheet software package.
Ans. Working with a spreadsheet generally includes following steps:
1. Creating a new workbook and writing in it.
2. Opening an existing workbook.
3. Editing the workbook, if required.
4. Printing the worksheets, if required.
5. Saving the workbook on permanent storage device for later use.
6. Creating and printing chart.
7. Closing the workbook.
8. Exiting the spreadsheet package.
18. What is Microsoft Excel’?
Ans. Microsoft Excel is a spreadsheet program that Aeveloped by Microsoft corporation. It is a spreadsheet som readsheet software should have.
MS-Excel and some other software (such as MS-Word, MS Powe package known as Microsoft office.
To run the MS-Excel software, click on ‘Start’ button, then on and then on Microsoft Excel option.
Q.19. What is a formula in MS-Excel?
Ans. A formula is a special type of entry, which describes the relations Formula in MS-Excel is an equation that is inserted in worksheet to do some mu worksheet (or spreadsheet) data such as addition and multiplication, or they can be entered to compare values. For example, the formula D8D6D7 stores the sum of value of cells D6 and D7 in cell D8.