Download PC package Assignment and more Study notes Computer Applications in PDF only on Docsity!
Ques.1 Explain various options available in edit menu of MS-Word.
Ans.1 The edit menu contains some important features that you need to know. Like its name suggests, the edit menu will be basically used to make some editing on your document. These are the features you are going to encounter when using the edit menu.
Undo – This tool is useful especially when you mess with your document and you want to go back to a previous state. For instance if you happen to delete a text and you want it back, just click on edit and then select undo.
You can also make use of the short cut Ctrl + Z key combination. Else use the short cut icon located on the standard toolbar.
Redo, Cut, and Copy Commands
Redo – This command is used to reverse the changes made by the undo command. For example, if you have deleted some information and you want it back, you will use the redo command.
Cut – used to extract contents (object or text) of your document and place it on the clipboard. These contents can then be pasted somewhere else or discarded.
Copy – this command can be used for duplicating your contents, unlike the cut command, once you copy, the original document is left in place. After copying, the contents are again taken to the clipboard. The copied contents can then be pasted on the desired place.
Paste, Office Clipboard, and Paste Special Commands
Paste – This command is used for placing the contents you have cut or copied to where you want. For example, I can cut my second paragraph and paste it to be the last. I will simply highlight, go to edit and click on copy. Then I will click on where I want to have the contents and then go to edit and click on paste. Short cut for pasting is Ctrl + V, or you right click on where you are pasting and select paste.
Office clipboard – it holds the contents that have either been cut or copied. It is capable of holding 24 multiple text and graphical items.
These contents can then be organized according to how you want them to be. To use any content on the clipboard, just click on where you want to have it then on the office clipboard, click on the contents you want to use. They will be pasted automatically on where the blinking cursor is located.
Paste special – This command is used for special or advanced pasting whereas the inserted contents will have a special formatting that you will select.
The Clear, Select All, and the Find Commands
Clear – There are two types of clear commands, one for clearing (removing) selected formats and the other for clearing (erasing) selected contents.
Select all – this is a very important command for selecting all contents. Its shortcut is the use of Ctrl + A keys on your keyboard.
Ques.2 Discuss auto formatting and various print options for
printing in MS-Word.
Ans.2 Auto Formatting- Word includes a feature that formats what you type, as you type it. You
probably take many of these automatic formatting (AutoFormat) adjustments for granted. Word does things like changing your quotes to Smart Quotes, automatically creating bulleted and numbered lists, and changing the indentation of paragraphs.
This is fine and good for many people, but what if you get a document from someone else and it needs a lot of the "little touches" applied to it? This is where the real industrial-strength AutoFormat feature of Word comes into play. You see, AutoFormat doesn't just work as you type—it also is available, on demand, to format an entire document. Here's how to AutoFormat your document:
- Load the document you want to format.
- Choose AutoFormat from the Format menu. Word displays the AutoFormat dialog box.
- Use the radio buttons to indicate if you want AutoFormat to work without stopping for your input, or not.
- Click on OK.
At this point, AutoFormat works its magic and your document is "reformatted" to appear as it would have if you had typed it yourself.
Printing- Word offers you several options for the printing.
*From the File menu, select the Print option.
You can first select the printer of your choice. This is practical if you have access to several printers from your job(workstation). It's however necessary to pay attention. The presentation of your document changes according to the printer that you chose. It's necessary to select the good printer and to make a preview before printing to make sure to have the good result in the printing.
You can also control the vast of your printing. You can print all the document, the page where is the cursor at this moment, the block of text that you selected or certain pages in your choice.
Sometime, you don't want to print a document completely but only a couple of pages. The last option of the section on the area offers you this possibility. It's necessary just to know that you must put a semicolon (;) between every page or block of page. It's necessary to put a hyphen (-) between the first and the back page of a series of pages to be printed. There is a small example at the foot of the window. In this example, you could print pages 1 , 3 , 5 - 12 up to and including as well as page 14 of your document (1; 3; 5-12; 14).
You have also the control on the number of copies that will be printed. This is practical if you have to print a document for several persons for a report, a committee or a meeting. leave the option with " assembled Copies ". Otherwise, you should replace in order all the pages of your copies.
Most of the time, you'll want to print the document. But he can have moments or you'll want to take advantage of the other possibilities such as the printing of the properties of the document or the comments.
The last option allows you to print all the pages or the pages odd peers or pages. One of the advantages of this option is to be able to print manually a document in first side reverse. Here are the stages.
Ques.3 Explain various cell formatting options available in MS-
Excel.
Ans.3 We use Format Cells to change the formatting of cell number without changing the number itself. We can use Format cells to change the number, alignment, font style, Border style, Fill options and Protection.
We can find this option with right click of the mouse. After right-clicking, pop-up will appear, and then we need to click on Format Cells or we can use shortcut key Ctrl+1 on our keyboard.
Format Cells: - Excel cell format option is used for changing the appearance of number without any
changes in number. We can change font, protect the file, etc.
To formatting the cells there are five tabs in Format Cells. By using this, we can change the date style, time style, Alignments, insert the border with different style, protect the cells, etc.
Number Tab:- Excel number format used for changing the formatting of number cells in decimals,
providing the desired format, in terms of number, dates, converting into percentage, fractions, etc.
Alignment Tab:- By using this tab, we can align the cell’s text, merge the two cell’s text with each other.
If the text is hidden, then by using the wrap text, we can show it properly, and also we can align the text as per the desired direction.
Border Tab: - By using this tab, we can create colorful border line to different type of styles; if we don’t
want to provide the border outline, we can leave it blank.
Fill Tab: - By using this tab, we can fill the cell or range with colors in different types of styles, we can
combine two colors, and also we can insert picture in a cell by using Fill option.
Ques.4 Describe the steps to create a pie chart in Excel by giving
suitable example.
Ans.4 Steps to Create a Pie Chart
To create a pie chart in Excel 2007, you will need to do the following steps:
- Highlight the data that you would like to use for the pie chart. In this example, we have selected the range A1:B5.
- Select the Insert tab in the toolbar at the top of the screen. Click on the Pie button in the Charts group and then select a chart from the drop down menu. In this example, we have selected the first pie chart (called Pie) in the 2-D Pie section.
