Exam Details
| Subject | excel | |
| Paper | ||
| Exam / Course | mba | |
| Department | ||
| Organization | solapur university | |
| Position | ||
| Exam Date | 07, December, 2018 | |
| City, State | maharashtra, solapur |
Question Paper
M.B.A. (Semester IV) (CBCS) Examination, 2018
system management programing concepts and advanced
excel
Paper Group D Paper V
Day and Date Friday, 7-12-2018 Max. Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions Question No. 1 is compulsory.
Solve any two questions from 4 and any two from
6 and 7.
All questions carry equal marks indicated in the right
side of each question.
1. Draw flow chart for preparation of a salary sheet with following features 14
Computation of Basic Salary on the basis of Attendance Days.
Additions HRA at 25% of Basic Salary, TA and DA at 20% each of the
Salary.
Computation of Gross Salary with all the above additions.
Deductions PF at 12% of Gross Salary, TDS at 20% of Gross Salary and
Insurance at of Basic Salary.
Deduct Profession Tax in Slabs for Basic Salary less than Rs.
Rs. for Basic Salary between Rs. to Rs. Rs.
for Basic Salary between Rs. to and Rs. for Basic
Salary above Rs. 30,000/-.
Compute Net Payment by deducting deductions from Gross Salary.
2. Answer any two of the following 14
Discuss different types of looping constructs in programming.
What are Recursive Functions Explain its advantages in programming.
Differentiate between BREAK and CONTINUE statements during loop
execution.
Seat
No. Set P
P.T.O.
Set P
SLR-CL 82 *SLRCL82*
3. Answer any two of the following 14
Define function; discuss the purpose of function and use of RETURN
statement in a function.
Discuss the GOAL SEEK feature in Microsoft Excel.
What is a flowchart Discuss the symbols and their meaning in flowchart.
4. Answer any two of the following 14
Discuss logical operators in programming.
Write a note on Multi dimensional Arrays.
Discuss in detail PIVOT TABLES in Excel.
5. Describe various types of functions viz. Inbuilt, user defined, recursive, with
parameters, without parameters. Explain the difference between with parameter
and without parameter functions. 14
6. Write an algorithm to display result of student as 'Distinction' 'Frist
Class' (65 'Second Class' (50 'Pass Class' (40 and
for percentage score given as input. 14
7. What is Object Oriented programming Discuss the basic features of Object
Oriented programming. 14
system management programing concepts and advanced
excel
Paper Group D Paper V
Day and Date Friday, 7-12-2018 Max. Marks 70
Time 10.30 a.m. to 1.00 p.m.
Instructions Question No. 1 is compulsory.
Solve any two questions from 4 and any two from
6 and 7.
All questions carry equal marks indicated in the right
side of each question.
1. Draw flow chart for preparation of a salary sheet with following features 14
Computation of Basic Salary on the basis of Attendance Days.
Additions HRA at 25% of Basic Salary, TA and DA at 20% each of the
Salary.
Computation of Gross Salary with all the above additions.
Deductions PF at 12% of Gross Salary, TDS at 20% of Gross Salary and
Insurance at of Basic Salary.
Deduct Profession Tax in Slabs for Basic Salary less than Rs.
Rs. for Basic Salary between Rs. to Rs. Rs.
for Basic Salary between Rs. to and Rs. for Basic
Salary above Rs. 30,000/-.
Compute Net Payment by deducting deductions from Gross Salary.
2. Answer any two of the following 14
Discuss different types of looping constructs in programming.
What are Recursive Functions Explain its advantages in programming.
Differentiate between BREAK and CONTINUE statements during loop
execution.
Seat
No. Set P
P.T.O.
Set P
SLR-CL 82 *SLRCL82*
3. Answer any two of the following 14
Define function; discuss the purpose of function and use of RETURN
statement in a function.
Discuss the GOAL SEEK feature in Microsoft Excel.
What is a flowchart Discuss the symbols and their meaning in flowchart.
4. Answer any two of the following 14
Discuss logical operators in programming.
Write a note on Multi dimensional Arrays.
Discuss in detail PIVOT TABLES in Excel.
5. Describe various types of functions viz. Inbuilt, user defined, recursive, with
parameters, without parameters. Explain the difference between with parameter
and without parameter functions. 14
6. Write an algorithm to display result of student as 'Distinction' 'Frist
Class' (65 'Second Class' (50 'Pass Class' (40 and
for percentage score given as input. 14
7. What is Object Oriented programming Discuss the basic features of Object
Oriented programming. 14
Other Question Papers
Subjects
- (paper – x) financial management
- (paper – xi) human resource management
- accounting for management
- accounting for managers
- agricultural marketing
- agricultural production management
- agro-processing industries and rural industrialization
- banking and insurance (paper – xvi)
- brand management and social marketing
- busines ethics
- business ethics (new) (cbcs)
- business ethics (old)
- corporate planning and strategic management (old)
- corporate planning and strategic management(old cbcs)
- day and date : friday, 30-11-2018 total
- economic environment for business
- entrepreneurship development and project management
- excel
- excellence in management
- export policy, procedure and documents (paper – ii)
- financial decision analysis
- financial management
- fundamentals of agriculture and co-operative management
- fundamentals of agriculture and co-operative management (new cbcs)
- global human resource management
- group d – system management (paper – ii)
- human resource initiatives (paper – ii)
- human resource management
- indian financial system
- indian financial system (paper – xix)
- industrial engineering
- industrial relations and labour regulations
- integrated marketing communication and consumer behaviour
- international busines (paper – xiii)
- international business environment (old)
- international business environment (paper – i)
- international finance
- international financial system and markets
- international financial systems and markets
- international logistics
- international marketing
- international trade and agriculture
- international trade procedures and documentation
- international trade procedures and documentations
- investment management
- it for management
- legal aspects of busines
- legal aspects of business
- logistics and supply chain management
- logistics and supply chain management (paper – xx)
- management accounting
- management accounting (paper–xviii)
- management acounting
- management information system
- managerial communication – i
- managerial communication – ii
- managerial economics
- managerial excellence
- marketing management
- marketing management (cbcs)
- operations management
- organisational behaviour
- organizational behaviour
- paper – ix : marketing management
- paper – xii : production and materials management (old)
- paper – xiii : economic environment of busines
- paper – xiv : managerial comunication – ii
- paper – xv : research methodology
- paper – xvi : event management(new)
- paper – xvi : operations management
- paper – xvii : strategic management
- performance management and compensation
- perspectives of management
- principles of management
- product and brand management
- product and brand management (paper – i)
- production and materials management
- production management and operations research (paper – xii)
- programing concepts and advanced
- programming concepts and advanced excel
- project planning and working capital management
- purchasing and inventory management
- purchasing and inventory management (paper – xix)
- quality management
- relational database management system
- research methodology
- research methodology (paper – xv)
- retail and rural marketing
- sales and distribution management (new) paper – xx
- sales and strategic marketing
- sales and strategic marketing (new cbcs)
- sales and strategic marketing (old)
- security and control information system
- skill development (paper – xix)
- statistical methods
- statistics for management
- strategic financial management
- strategic financial management (paper – ii)
- strategic human resource management
- strategic human resource management (old)
- strategic human resource management (paper – xix)
- system management
- system management security and control information system
- systems management
- systems management (paper – i)
- systems management (paper – ii)
- taxation
- training and development
- training and development gr.c : human resource management
- world class manufacturing