GALGOTIAS EDUCATIONAL INSTITUTIONS
1, Knowledge Park-II, Greater Noida, Uttar Pradesh, 201310
Program List
Course: MBA Semester: I
Subject: IT SKILLS LAB-I Sub. Code: KMBN 151
1. Create Marksheet in Ms-Excel having columns-
[Link]. , Name, Roll No., Marks 1, Marks 2, Marks 3, Marks 4, Marks 5, Total Marks, Percentage, Grade.
Use Formula and functions for calculations.
2. Create Resume in Ms-Word of your own. Use of Tables, Proper Formatting etc.
3. Create your class time table in Ms-word and in Ms-Excel with proper formatting.
4. Create Marksheet in Ms-Excel having columns-
5. Create Sales Report in Excel-
6. Create Invoice Template in Ms-Word and Excel
7. Create Employee Training Plan Template in Ms-Word and Excel
8. Create Employee attendance Record sheet in Excel
9. Create this sheet in Ms-Excel and Perform following questions-
a) Enter the labels and values in the exact cells locations as desired.
b) Use AutoFill to put the Employee Numbers into cells A6:A8.
c) Set the columns width and rows height appropriately.
d) Set labels alignment appropriately.
e) Use warp text and merge cells as desired.
f) Apply borders, gridlines and shading to the table as desired.
g) Format cell B2 to Short Date format.
h) Format cells E4:G8 to include Rs sign with two decimal places.
i) Calculate the Gross Pay for employee; enter a formula in cell E4 to multiply Hourly Rate by Hours
Worked. 11. Calculate the Social Security Tax (S.S Tax), which is 6% of the Gross Pay; enter a
formula in cell F4 to multiply Gross Pay by 6%.
j) Calculate the Net Pay; enter a formula in cell G4 to subtract Social Security Tax from Gross Pay.
k) Set the work sheet vertically and horizontally on the page.
10. Objectives:
Using Formulas.
Header and Footers.
a) Create a new workbook as shown below and save the file with the name “Call Statistics”.
b) Rename Sheet 1 to (Call Statistics).
c) Enter the labels and values in the exact cells locations as desired.
d) Set the row height of rows 1 & 3 to size 30; and rows 4 until 10 to size 20.
e) Set labels alignment appropriately.
f) Use Warp Text, Orientation and merge cells as desired.
g) Apply border, gridlines and shading to the table as desired.
h) Format column E to include Rs sign with two decimal places.
i) Format cell B12 to include % sign with 0 Decimal places.
j) Calculate the Calls per Hour, enter a formula in cell D4 to divide numbers of calls by Hours
worked. Using AutoFill, copy the formula to the remaining cells.
k) Calculate the Bonus. Enter a formula in cell E4 to multiply ‘Calls per Hours’ by the fixed Bonus
Rate in cell B12. Using AutoFill, copy the formula to the remaining cells.
l) Calculate the ‘TOTAL’. 13. Set the worksheet vertically and horizontally on the page.
m) Create a header that includes your name in the left section, and your ID number in the right
section. Create the footer that includes the current Date in the center.
11. Objectives:
Working with the IF Statement.
a) For the given table find the following:
b) TAX (If ITEM PRICE is less than 100, TAX is 50, otherwise it should be 100).
c) TOTAL PRICE BEFORE TAX =NO. OF ITEMS * ITEM PRICE.
d) TOTAL PRICE AFTER TAX = TOTAL PRICE BEFORE TAX + TAX.
e) RATE (If TOTAL PRICE AFTER TAX > 3500 then the rate is “HIGH”, otherwise it is
REASONABLE. f) Find Count of Items, Average of Taxes, Min Item PRICE and Max Item
PRICE.
g) Save file as
TAXIF.
12. Create PowerPoint presentation for any of the topic like-
Artifical Intelligence
Cloud Computing
Digital Marketing
Business Analytics, etc.
Use proper formatting, animations, etc in your presentations.
13. Implement Count function in Excel
a. COUNT function
b. COUNTA function
c. COUNTBLANK function
d. COUNTIFS function
14. Implement intermediate statistical functions in Excel
a. AVERAGE value1, [value2], …)
b. AVERAGEIF function
c. MEDIAN function
d. MODE function
15. Implement STANDARD DEVIATION function in Excel.
16. Implement VARIANCE function in Excel.
17. Implement QUARTILES function in Excel.
18. Implement CORRELATION function in Excel.
19. Implement LARGE function and SMALL function in Excel.
20. Implement Calculating Time Difference in Excel.
