Firstranker's choice
--- Content provided by FirstRanker.com ---
Code No. 10073
FACULTY OF COMMERCE
B.Com. V - Semester (CBCS) Examination, November / December 2019 (For Computer / Computer Application Courses) Subject: Business Simulation
Paper Code - BC - 508 Elective - Il
Time: 3 Hours Max.Marks: 80
--- Content provided by FirstRanker.com ---
PART - A (5x4 = 20 Marks)
[Short Answer Type]
Note: Answer any five of the following questions.
- Uses of Cell References in Formula
- VLOOK and HLOOK functions with examples
- Various Layouts of Excel Spreadsheet
- Formatting tools available on the Home tab
- Goal Seeking in Excel
- What is Forecasting?
- Applications of Risk Analysis
- How to remove Duplicates in a Table?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
PART - B (5x12 = 60 Marks)
[Essay Answer Type]
Note: Answer all the questions.
- a) What are functions in Excel? Explain various types of functions used.
--- Content provided by FirstRanker.com ---
OR
b) Explain about the different methods of referring Data from Different Worksheets, with neat diagrams. - a) Explain the different Conditional Formatting techniques applied to Excel Data Sheets.
OR
b) Explain Sorting and Filtering Options in Excel. How is Slicer different from them. - a) Briefly write about Advanced Data Validation Techniques.
OR
b) Write the steps to create Charts. Explain Spark lines with an example. - a) What is Monte Carlo Simulation?
OR--- Content provided by FirstRanker.com ---
b) What is Forecasting in Excel? Explain Exponential smoothing and Linear regression forecasting methods. - a) Briefly write about Advanced Simulation Techniques.
OR
b) How do you perform Simulation using @ Risk?
--- Content provided by FirstRanker.com ---
--- Content provided by FirstRanker.com ---
This download link is referred from the post: OU B.Com Last 10 Years 2010-2020 Question Papers || Osmania University
--- Content provided by FirstRanker.com ---