Exam Details
| Subject | spread sheet modeling | |
| Paper | ||
| Exam / Course | m.b.a. in business analytics | |
| Department | ||
| Organization | alagappa university | |
| Position | ||
| Exam Date | November, 2017 | |
| City, State | tamil nadu, karaikudi |
Question Paper
M.B.A. DEGREE EXAMINATION, NOVEMBER 2017
Business Analytics
SPREAD SHEET MODELING
(2016 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. Write any four basic components of excel.
2. How to add buttons to the quick access toolbar?
3. How to switch between worksheets in Excel?
4. Write the shortcut key to enter data on a new line within
a cell.
5. What are Excel arithmetic operators?
6. What is the use of Excel's Go To feature?
7. Define the term Data Series.
8. Write the difference between functions NET WORKDAYS
and WORKDAY.
9. What is Pivot Table?
10. Write the procedure to add a calculated field to Excel
pivot table.
Sub. Code
13
CP-8245
2
Ws5
Part B 5 25)
Answer all questions.
11. Write short notes on Ribbon.
Or
Write a short notes on
Selecting a worksheet
Renaming a worksheet
Inserting a worksheet
Moving a worksheet
Deleting a worksheet.
12. Write the procedure to copy or move worksheets
between workbooks.
Or
Write the procedure to do the following
To enter a number having fixed decimal point
To add text in the middle of selected cells with
formula.
13. Explain in detail about Formula Auditing Tool.
Or
Write the procedure to delete and change a Named
Range.
14. With examples, explain the Line and Pie Chart.
Or
Write short note on the following functions
AND
IF.
CP-8245
3
Ws5
15. How to change the layout and format of a Pivot
Table? Explain.
Or
Explain in detail about Pivot Chart.
Part C 10 30)
Answer all questions.
16. Explain in detail about the following
Inserting rows and columns within a
worksheet
Modifying column width using 'drag and drop'.
Or
Describe the following
Built-in and custom number format.
Changing text orientation.
17. With examples, describe the following
Absolute cell references.
Relative cell references.
Mixed cell references.
Or
Write procedure to do the following
Sort data based on key values in more than
one column in Excel
Report Layout in Excel.
CP-8245
4
Ws5
18. Describe the following text functions
MID
SEARCH
TRIM
UPPER
SUBSTITUTE.
Or
Describe the filter by using advanced criteria.
————————
Business Analytics
SPREAD SHEET MODELING
(2016 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. Write any four basic components of excel.
2. How to add buttons to the quick access toolbar?
3. How to switch between worksheets in Excel?
4. Write the shortcut key to enter data on a new line within
a cell.
5. What are Excel arithmetic operators?
6. What is the use of Excel's Go To feature?
7. Define the term Data Series.
8. Write the difference between functions NET WORKDAYS
and WORKDAY.
9. What is Pivot Table?
10. Write the procedure to add a calculated field to Excel
pivot table.
Sub. Code
13
CP-8245
2
Ws5
Part B 5 25)
Answer all questions.
11. Write short notes on Ribbon.
Or
Write a short notes on
Selecting a worksheet
Renaming a worksheet
Inserting a worksheet
Moving a worksheet
Deleting a worksheet.
12. Write the procedure to copy or move worksheets
between workbooks.
Or
Write the procedure to do the following
To enter a number having fixed decimal point
To add text in the middle of selected cells with
formula.
13. Explain in detail about Formula Auditing Tool.
Or
Write the procedure to delete and change a Named
Range.
14. With examples, explain the Line and Pie Chart.
Or
Write short note on the following functions
AND
IF.
CP-8245
3
Ws5
15. How to change the layout and format of a Pivot
Table? Explain.
Or
Explain in detail about Pivot Chart.
Part C 10 30)
Answer all questions.
16. Explain in detail about the following
Inserting rows and columns within a
worksheet
Modifying column width using 'drag and drop'.
Or
Describe the following
Built-in and custom number format.
Changing text orientation.
17. With examples, describe the following
Absolute cell references.
Relative cell references.
Mixed cell references.
Or
Write procedure to do the following
Sort data based on key values in more than
one column in Excel
Report Layout in Excel.
CP-8245
4
Ws5
18. Describe the following text functions
MID
SEARCH
TRIM
UPPER
SUBSTITUTE.
Or
Describe the filter by using advanced criteria.
————————
Other Question Papers
Subjects
- accounting for business analysts
- business law and ethics
- consumer behaviour
- data mining for business analytics
- dbms and data warehousing
- economic analysis for business decisions
- financial management
- fundamentals of business analytics
- fundamentals of digital marketing
- human resource management
- management concepts and practices
- marketing management
- multivariate data analysis-i
- project management and budgeting
- research methodology
- spread sheet modeling
- statistics for business
- time series econometrics
- written analysis and communication