Ms office to work for data entry, Cheat Sheet of MS Microsoft Office skills

Download Ms office to work for data entry and more Cheat Sheet MS Microsoft Office skills in PDF only on Docsity!

MICROSOFT OFFICE

FOR COMMERCE

SKILL ENHANCEMENT

SEMESTER

PRACTICALS

EXERCISE 1 - CREATION OF RESUME:

AIM: To create a resume using MS Word PROCEDURE:

1. Open MS Office - MS Word – File – New

2. Go to View - Header and Footer - Type name, mobile number inside the Header 3. Go to Insert - Page Number - select the position bottom of the page and Alignment to Centre – Click Ok.
3. Go to Table – I nsert – Table – chose Number of Columns 2 and Rows to 1. Enter the name, format it (bold and increase the font size via standard tool Bar). And in the second column type the whole address. 5. Whenever you want to increase the number of column in the existing row, select that row and go to Table – click Split Cells - enter number of columns-click Ok. 6. In order to decrease the existing column numbers, select that columns and Go to Tables – click Merge cells.
4. Finally type the declaration outside the table with your name aligning right side and date to the left side.

EXERCISE 3 - CREATION STUDENT RESULT SHEET

AIM: To create a student result sheet using MS Word PROCEDURE:

1. Open MS Office - MS Excel – File – New

2. Select few column and few rows at the centre of the beginning- Right Click- Format cells

• click select the alignment tab – tick Merge cells option- ok - Type the Heading.

3. Enter the column Headings. Enter the data of following columns manually Sl.No, Reg.No, Name, Science, Maths, English and BCS.
4. Enter the following formula to calculate the respective values. Total = SUM (D5:G5) Percentage =H5/4Result=IF(AND(D5>=35, E5>=35, F5>=35, G5>=35),"PASS","FAIL") Class =IF (J5="PASS", IF(I5>=75,"DISTINCTION", IF (I5>=60,"FIRST CLASS”, IF (I5>=50,"SECOND CLASS”, IF (I5>=35,"PASS")))),"FAIL")

After Writing each formula select the cell and drag to the entire column to apply.

EXERCISE 4 - CREATION OF SIMPLE BAR DIAGRAM

AIM: To create a bar diagram in MS Excel PROCEDURE:

1. Open MS Office -- MS Excel – File – New

2. Select few column and few rows at the centre of the beginning- right Click- Format cells - click select the alignment tab - tick Merge cells option- ok - Type the Heading.
3. Enter the column Heading and row heading. Enter the data in each Column.
4. Select the complete row and column data including the header.
5. Go to Insert – Chart – Bars - Select the Chart Type – Custom Type – Select the type- Next

• Select Column – next – under T itle give the Heading at Chart title – under Axes choose the Primary axis – under Legends chose the Placement – under Data labels choose value – next - select the place chart - Finish.

3. Click Customize Columns to modify the list of fields
4. Delete any unnecessary field names and/or add new ones
5. Click OK
6. Begin typing records, hitting TAB to advance to the next field and to continue adding new records
7. Click OK
8. Click Save The recipients list will be saved as a separate file as a Microsoft Access file type. It is saved in the My Data Sources folder. It is recommended to save the file in this folder.
9. Click Next: Write your letter Step 4 – Write Your Letter
10. If including an address, click the location in your document where the address data will be inserted 2) Click Address block
11. Select the address elements you want included
12. Click OK The field name will look like this: < address block > The address block will insert the following fields including any necessary punctuation: First Name, Last Name, Company, Address 1, Address 2, City, State, Postal Code. If your fields do not match the ones listed above or you are not using address fields, click More items…
13. Click on the field from the list
14. Click Insert
15. Click Close The field name will look like this - «First_Name»
16. Repeat this step until all fields have been inserted. Remember to put spaces and punctuation where needed.
17. Click Next: Preview your letters Step 5 – Preview Your Letters Here is where you can preview the first page with the fields filled in. Click Next: Complete the merge Step 6 – Complete the Merge
18. Click Print to send directly to the printer
19. Click Edit individual letters to create a new file Remember to save your document as you go. The next time you open your document and click on Step-by-Step Mail Merge, the data source file will be attached.

Mail Merge – Labels

1. Create a new blank document - Click the Mailings tab 2 ) Click Start Mail Merge 3 ) Click Step-by-Step Mail Merge Wizard Step 1 – Select Document Type
2. Click Labels for the document type
3. Click Next: Starting document Step 2 – Select Starting Document
4. Click Use the current document
5. Click Label options under Change document layout
6. Choose the label style you are using
7. Click OK
8. Click Next: Select recipients Step 3 – Select Recipients
9. Click Use an existing list under Select recipients (or you can create a new list)
10. Click Browse
11. Select the file
12. Click Open
13. Select the worksheet tab name that contains the data
14. Click OK
15. Click Next: Arrange your labels Step 4 – Arrange Your Labels
16. Click in the first label box and click on either Address block or More items to insert the data fields
17. Click Update all labels to include the fields on all labels
18. Click Next: Preview your labels Step 5 – Preview Your Labels Here is where you can preview the labels. Click Next: Complete the merge Step 6 – Complete the Merge Click Print to send directly to the printer OR Click Edit individual labels to create a new file. FINISH