Data Entry

(229)

Q.1 What are the steps to install software in the computer.

Ans : 

1. Open the machine.
2. Open the drive that holds the installation files in the My Device browser. For example, if the files are on the CD-ROM drive, open the D: drive or letter of the CD-ROM drive.
3. Locate either the executable configuration (i.e., “setup.exe”) or the install file on the drive that holds the data. Double-click this file to launch the installation process. If there are several setup or installation files, locate the executable file or double-click each setup or install file before you reach the file that begins the installation.

Q.2 Write down various steps to rename a file or folder.

Ans :

1. Switch through your files before you find the file or folder you wish to rename.
2. To pick a file or folder, click on it.
3. Tap the text box of the object to pick it, then enter the new name.
4. To save a new name, press Enter (if using Windows) or Return (on a Mac).

Q.3 List out various steps to search for a file or folder

Ans :

1. Open the Start menu and enter the search word in the search field below. The search results list appears separated by the position of the results.
2. The Search Results dialog appears in the Indexed Locations browser.
3. Tap Display to loop through different icon size or text listing options.
4. Double-click the file you want to access when you find it.

If you don’t see what you’re looking for, select Folder and Search Options from the Arrange menu to change Search settings. You may change the places to check, show whether to find partial matches for search words and more.

Q.4 What is a mouse pointer?

Ans : A mouse cursor, also known as a mouse arrow, or mouse pointer, is a graphical image that is used in a graphical user interface to trigger or control those items. More specifically, it demonstrates where the next operation of your mouse should be carried out, such as opening a program or moving a file to another location.

Q.5 Explain the steps in renaming a document.

Ans :

1. Ensure that the document you wish to rename is not loaded into Term.

(If it is loaded, shut it.)

• Press the Open tool in the toolbar, or choose Open from the File menu, or click the Office button (in Word 2007) and select Open. You’ll see the dialog box for Accessible.
• Right-click the one you want to rename in the list of files found in the dialog box. This demonstrates the Document Background menu.
• On the Background menu, choose Rename. The name of the document is highlighted and you have the chance to change the name.
• Once the document name is changed, press Enter.
• Close the open dialog box by clicking on Cancel.

Q.6 Write any three options available in the Print dialog box.

Ans : The following are some of the choices available in the Print dialog box:

1) Lists the available printers

2) Sets of pages that are to be printed

3) Number of printable copies

Q.7 How do you modify a password given to protect a document?

Ans : Open the document for which you want to update your password. Click Preferences on the Word menu. Under Personal Settings, click Protection. In the Open Password or Alter Password box, select All Contents. Type a new password, and then click OK.

Q.8 Explain the steps in inserting a symbol.

Ans : Place your cursor at the place where a symbol is to be inserted.

1. On the MS Word task bar, press Insert.
2. On the taskbar of MS Title, click Insert.
3. Press the Symbol button. In the first of two menu tabs, the Symbols menu opens. The Special Characters tab is the second tab.
4. Pick a symbol from the Symbols List. If you want to insert a copyright mark, for example, Locate the copyright symbol on the symbol map first. If you don’t see the symbol you’re looking for in the list, consider selecting the font for Wing Dings in Windows. You’ll see a different set of characters from which to choose.
5. To highlight it, click the copyright button.
6. On the lower section of the Symbols table, press the Insert tab and you will see the copyright symbol where your cursor was within your text.

Q.9 What is the use of AutoCorrect feature in Word?

Ans : With the AutoCorrect function, Word automatically fixes several frequently misspelled words and punctuation marks. To show a list of automatically corrected words, select the Tools – Auto Correct command from the menu bar. This could be a secret feature, so if the Auto Correct option is not specified, click the double arrows at the bottom of the Tools menu list. This page will automatically correct several choices, including the accidental capitalization of the first two letters of a word and the capitalization of the first word of a sentence. In the Substitute and With fields, enter the  and right spellings if there are words you sometimes misspell.

Q.10 How do you set line spacing in a paragraph?

Ans : In a portion of the text, adjust the line spacing

1. To update, pick one or more paragraphs.
2. Go to Home > Spacing of Line and Paragraph.
3. Select Line Spacing Options, and in the Line Spacing box, select an option.
4. To alter the spacing between paragraphs, modify the before and after settings.
5. Click OK.

Q.11 Explain different preset styles available in Excel.

Ans : Format a cell easily by picking a cell style. Your own cell style can also be developed. Format a number of cells easily by selecting a table style.

1. For example, select cell B2 below.
2. On the Home tab, in the Styles group, choose a cell style.
3. To create your own cell style, execute the following steps.
4. On the Home tab, in the Styles group, click the bottom right down arrow.
5. Here you can find many more cell styles.
6. Click New Cell Style.
7. Enter a name and press the Format button to set your cell style to Number Format, Orientation, Font, Border, Fill, and Protect. If you don’t want to monitor this sort of formatting, simply uncheck a check box.
8. Click OK.
9. On the Home tab, in the Styles group, apply your own cell style.

Q.12 How do you resize your worksheet columns or rows?

Ans :

1. Open Excel and chose to load a folder. …
2. Inside a cell, position the mouse pointer and click to pick it.
3. In the ribbon (on the right-hand side), press the Format icon and pick Column Width (or Row height if you want to change the height of a Row instead).
4. Enter the width required, and click OK.

Q.13 How to copy styles from one open workbook file to another?

Ans :

1. Open a new workbook.
2. From the Format menu, select Style.
3. Click Merge.
4. In the Merge Styles dialog box, select the workbook where the Styles to merge were saved, and then click OK.
5. In the Style dialog box, click OK.

Q.14 What is the importance of charts and graphics in providing information?

Ans : Using a number of graph forms, charts allow you to display data entered into the worksheet in a visual format. You must enter data into a worksheet first before you can make a map. This chapter describes how basic charts can be generated from the details. For different targets, formatted maps come in various ways, ranging from columns to pies, from lines to textures, etc.

In the ever – flow of data, graphic visual representation of information is a key component in interpreting and recognizing patterns and trends. Graphical representation allows vast volumes of data to be easily evaluated at one time and can help in making forecasts and educated decisions.

Q.15 List any five categories of AutoShapes in Excel.

Ans : The list of five categories of AutoShapes in Excel is shown below

1. Lines
2. Connectors
3. Basic Shapes
4. Block Arrows
5. Flow Chart

Q.16 Explain the process of creating a chart using Chart Wizard dialog box.

Ans :  As described earlier in this chapter, pick the data set:

1. Press the tab Insert.
2. Pick a form of XY (Scatter) Diagram. There are five map sub-category options available for the XY Chart type. (It is important to remember here that instead of XY (Scatter), the line map is sometimes wrongly used).
3. From the four Chart sub-type choices, pick the ‘Smooth Line Related Data Points’ Chart option.
4. You will then use the Diagram Methods (Design, Arrangement, Format) to change the diagram.
5. You can use the Layout software, for example, to enter Map Names, Axis Titles, Gridlines