Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 10 Date : 01 June, 2023 Duration : 90 Minutes
1) Explain Conditional formatting? The following are the salaries of five employees, using
conditional formatting in the MS-Excel list out employees who got
a) Less than Rs.15000 as salary
b) More than Rs. 700 as part time
c) Between Rs. 1600 and Rs. 1800 as Arrears
2) Explain the use of MS-Excel in business context and execute,
a) Type in all text and numbers shown in the spreadsheet below.
b) Format all numbers with appropriate formats.
c) Center the spreadsheet heading “Mike’s Lunch Bar” across the spreadsheet.
d) Create formulas to display a total for each item in the Lunch Bar
e) Create a formula to calculate the total sales for the Lunch Bar.
f) Apply all boarders and shading (colour) shown in the sample below.
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) Explain how do you create a new workbook in Excel? Using a spreadsheet package you have
studied, construct “T Morongo’s pay slip” for December 2010 following the instructions
below. Save it as “Salary advice”.
Salary Adive For December 2010
Employee: T MARONGO
Staff No: 1004
Date 31-Dec-23
Next Pay Date 31-Jan-24
Basic Salary p.a Rs. 31200.00
Income Amount Deductions Amount
Basic Salary Pension @ 8%
Housing subsidy U.I.F
vehicle allowance Medical Aid
Bond repayment
Gross Income Total Deduction
Net salary
Instructions:
i) Housing Subsidy 6000/- per year v) U.I.F 1% on (Basic Salary+Housing
ii) Car Allowance 100/- per month Subsidy)
iii)Pension 8% on Basic Salary vi) Bond repayment 630/-
iv) Medical Aid 70/- vii) Calculate Net salary.
2) Explain Macros? Repeat the following table in MS-Excel using Macros by giving short-cut
key as Crtl+Shift+K
BAMR
Student Name: Date:
Roll No: Cource Code:
IA Presentation
Assignment Practical
Total(Internal)
External Exam
Grad Total
Grade
Bapuji Academy of Managemen and Research (Affiliated to Davangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) How do you create a basic column chart in Excel?
a. Create a spreadsheet with the following entries & save it as ENG1
ENGINEERS' SALARIES
Engineer's Name Hours Worked Rate per hour($) Salary
Eng. Mudehwe 180 1000
Eng.Bejera 300 2000
Eng.Mudzuri 500 2500
Eng.Muzawazi 200 1500
Eng.Zhawari 300 2500
Eng.Mutekede 120 2000
b. Perform the following:
• bold & underline the title
• make all heading bold
• put borders on all entries of the sheet
• Given that salary = hours worked multiplied by rate per hour, calculate the salary.
• Calculate the total number of hours worked & the total amount paid to all the
Engineers.
c. Add the following Engineers to the worksheet:
2) What is the purpose of the Home tab in the Tabs Ribbon toolbar? Design a certificate as shown
below
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) Write a note on Google form? Create a Google Form with questions related to the “The Role of
Mobile Apps in Enhancing Students' Learning Experience”.
The survey question should include two section
Section A: Personal Details(Name, Reg Number,School Name,Course)
Section B : Questions related to “The Role of Mobile Apps in Enhancing Students' Learning
Experience”
2) What is the purpose of the Clipboard in MS Office? Create an offer letter template in Word format
that includes a letterhead to a Candidate for the position of “Senior software Engineer”, save the
document as Offer Letter-Mahesh and Perform a spell check on the entire document.
Note : Candidate Name: Mahesh B
Place: Kopal district
Mob No:9584114785
Qualification: Bachelor of Engineering(CS)
Email-id:[email protected]
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) What are the benefits of using SmartArt graphics, and how can they be inserted and modified in
a presentation?
Create a presentation on the topic of "The Benefits of Regular Exercise."
a. Design the first slide as a title slide. Include a captivating title, such as "The
Benefits of Regular Exercise," and add a relevant image or graphic.
b. Create a slide introducing the topic and providing an overview of the presentation.
c. Include at least three slides that highlight different benefits of regular exercise.
For each benefit, provide a clear and concise title and use bullet points or visuals
to explain the specific advantages.
d. Create a slide that includes a chart or graph showcasing statistics related to the
positive impact of exercise on physical health or mental well-being.
e. Insert a small video on the topic in the slide
2) What is a Blog? Design a ID-Card as shown in the sample using MS-PPT
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) What options are available for protecting a document in MS Word, and how can you apply
password encryption or restrict editing permissions? Create Curriculum Vitae (CV) using
Microsoft Word and use tables to add the Education section of the CV.
2) How can you utilize the "Quick Access Toolbar" in MS Office applications to customize and
access frequently used commands? Design a Business-Card as shown in the sample using MS-
PPT
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) What is the purpose of the Home tab in the Tabs Ribbon toolbar? Design a certificate as
shown below
2) How can you use the "Formulas" feature in MS Excel to perform complex calculations and
manipulate data?
a) Reproduce the following worksheet & save it as monthly sales, insert a title Half Yearly
Sales.
b) Calculate the missing figures using formulae.
c) Produce a column graph on a new sheet showing the heading Monthly sales for 6 months.
Bapuji Academy of Management and Research (Affiliated toDavangere
University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha
HS
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) Explain the use of MS-Excel in business context and execute,
a) Type in all text and numbers shown in the spreadsheet below.
b) Format all numbers with appropriate formats.
c) Center the spreadsheet heading “Mike’s Lunch Bar” across the spreadsheet.
d) Create formulas to display a total for each item in the Lunch Bar
e) Create a formula to calculate the total sales for the Lunch Bar.
f) Apply all boarders and shading (colour) shown in the sample below.
2) Write a note on Google form? Create a Google Form with questions related to the “The
Role of Mobile Apps in Enhancing Students' Learning Experience”.
The survey question should include two section
Section A: Personal Details(Name, Reg Number,School Name,Course)
Section B : Questions related to “The Role of Mobile Apps in Enhancing Students'
Learning Experience”
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) Explain how do you create a new workbook in Excel? Using a spreadsheet package you have
studied, construct “T Morongo’s pay slip” for December 2010 following the instructions
below. Save it as “Salary advice”.
Salary Adive For December 2010
Employee: T MARONGO
Staff No: 1004
Date 31-Dec-23
Next Pay Date 31-Jan-24
Basic Salary p.a Rs. 31200.00
Income Amount Deductions Amount
Basic Salary Pension @ 8%
Housing subsidy U.I.F
vehicle allowance Medical Aid
Bond repayment
Gross Income Total Deduction
Net salary
Instructions: Calculate the net salary
Housing Subsidy 5000/- per Medical Aid 500/-
year
Car Allowance 822/- per month U.I.F 5.5% on (Basic Salary+Housing
Subsidy)
Pension 10% on Basic Salary Bond repayment 500/-
16) What is a Blog? Design a ID-Card as shown in the sample using MS-PPT
Bapuji Academy of Management and Research (Affiliated toDavangere
University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha
H S Year : I MBA - I Sem Marks : 10 Date : 01 June, 2023 Duration : 90
Minutes
1) Explain Macros? Repeat the following table in MS-Excel using Macros by giving short-cut
key as Crtl+Shift+K
BAMR
Student Name: Date:
Roll No: Cource Code:
IA Presentation
Assignment Practical
Total(Internal)
External Exam
Grad Total
Grade
2) What is the purpose of the "Bcc" and “Cc” field in Microsoft Outlook?
The school is going to present a certificate to the students who have scored high marks in
English, Chinese or Mathematics.
a) Create the following data source file using a spreadsheet program
b) The certificate for the first student looks like, Hand in the softcopy of the document
after applying mail merge.
Bapuji Academy of Management and Research (Affiliated toDavangere
University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha
HS
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) Explain Mail Merge? By using Mail Merge in MS-Word
a) Create the Main Document
Data:
<Title><FirstName><last Name>
<Job Title>
<Company>
<Address1>
<City>,<State>-<PostalCode>
Dear <FirstName>,
Thank you for enrolling in our class.All classes begin at 9 a.m and end at 4 p.m.
We look forward to seeing you in our <Class> on < ClassDate>
Sincerely
b) Use the following information to determine the fields needed for your data source and
center the records. Save the data source CLASS INFO.
First Last Addres postal
Title Job Title Company City State Class Class_date
Name Name s1 Code
124
New
Ms Mary John President Main MUTARE MANICALAND 220 Word 10/28/20xx
Company
Street
890
ABC MUNICA
Mr Farai Park Comptroller Fifth MANICALAND 225 wWord 10/25/20xx
Company LAND
Avenu
412
XYZ MARON
Mr Jim Thomas Manager Central MASH EAST 200 Excel 10/30/20xx
Compuny DERA
Avenue
2) What options are available for protecting a document in MS Word, and how can you apply
password encryption or restrict editing permissions? Create Curriculum Vitae (CV) using
Microsoft Word and use tables to add the Education section of the CV.
Bapuji Academy of Management and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) Explain the primary uses of Function Bar in MS-Excel? A furniture shop sells furniture to
customers on credit. The credit terms request the customer to make a deposit of 25%. The
balance after the total deposit is paid in monthly installments over 24 months without
interest.
The shop customers & furniture credit values are:
Monthly
Name Furniture($) Deposite Balance Installment
Farai 85000.00
Itai 55000.00
Sibongile 90000.00
Isac 63700.00
Fundai 95700.00
Shimgai 65800.00
Mary 95900.00
a) Design a spreadsheet of the data above & save it as Furniture.
b) Make all titles bold and shade the cell background for titles in light grey color.
c) Format the furniture value to zero decimal point.
d) Use formulae to calculate values for deposit, balance & monthly installments.
e) Sort the sheet in alphabetical order of names.
f) Insert borders on all entries & save the sheet
g) ON A NEW SHEET, Create a fully labeled,
i. Column graph : Using the name and value of furniture columns & SAVE IT AS
GRAPHS.
2) What are the benefits of using SmartArt graphics, and how can they be inserted and modified
in a presentation?
Create a presentation on the topic of "The Benefits of Regular Exercise."
a) Design the first slide as a title slide. Include a captivating title, such as "The Benefits
of Regular Exercise," and add a relevant image or graphic.
b) Create a slide introducing the topic and providing an overview of the presentation.
c) Include at least three slides that highlight different benefits of regular exercise. For
each benefit, provide a clear and concise title and use bullet points or visuals to explain
the specific advantages.
d) Create a slide that includes a chart or graph showcasing statistics related to the positive
impact of exercise on physical health or mental well-being.
e) Insert a small video on the topic in the slide
Bapuji Academy of Managemen and Research (Affiliated toDavangere University)
M.B.A
Practical Exam
Subject : 1.7: Information Technology for Managers - Theory Faculty : Prof. Usha H S
Year : I MBA - I Sem Marks : 50 Date : 01 June, 2023 Duration : 90 Minutes
1) How do you create a basic column chart in Excel?
a) Create a spreadsheet with the following entries & save it as ENG1
ENGINEERS' SALARIES
Engineer's Name Hours Worked Rate per hour($) Salary
Eng. Mudehwe 180 1000
Eng.Bejera 300 2000
Eng.Mudzuri 500 2500
Eng.Muzawazi 200 1500
Eng.Zhawari 300 2500
Eng.Mutekede 120 2000
b) Perform the following:
• bold & underline the title
• make all heading bold
• put borders on all entries of the sheet
• Given that salary = hours worked multiplied by rate per hour, calculate the salary.
• Calculate the total number of hours worked & the total amount paid to all the
Engineers.
c) Add the following Engineers to the worksheet:
2) How can you utilize the "Quick Access Toolbar" in MS Office applications to customize
and access frequently used commands? Design a Business-Card as shown in the sample
using MS-PPT
