Scribd
Upload
103 views2 pages

Model Question Paper

This document is a model question paper for the course 'Introduction to Data Analysis Using Spreadsheet' with a focus on MS Excel. It includes sections for short answer questions, paragraph/problem questions, and long answer questions, covering topics such as Excel interface, Pivot Tables, data validation, and functions. The paper aims to assess students' understanding and application of Excel tools and techniques.

Uploaded by

rahuljoyjose
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
103 views2 pages

Model Question Paper

This document is a model question paper for the course 'Introduction to Data Analysis Using Spreadsheet' with a focus on MS Excel. It includes sections for short answer questions, paragraph/problem questions, and long answer questions, covering topics such as Excel interface, Pivot Tables, data validation, and functions. The paper aims to assess students' understanding and application of Excel tools and techniques.

Uploaded by

rahuljoyjose
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Model Question Paper

BCS5B04: INTRODUCTION TO DATA ANALYSIS USING SPREADSHEET


(Open course)
Time: 2 Hrs Maximum Marks: 60
CO. Course Outcome
1 Familiarize MS Excel
2 Understand Objects in Worksheets
3 Apply Pivot tables in analytics
4 Use Formulae and Function.

SECTION A
Answer the following Short Answer Questions (2 marks each)
Ceiling 20 marks

1. Differentiate between a cell and a range in Excel.


2. Explain the purpose of the formula bar.
3. What is the significance of the "Fill Handle"?
4. How can you apply a simple border to a cell or a range of cells?
5. What is the primary function of a Pivot Table?
6. How can you change the aggregation function (e.g., from SUM to
AVERAGE) in a Pivot Table?
7. Define a Slicer.
8. How do you apply filtering to a regular data table?
9. Give an example of a simple IF function.
10. What is the difference between an absolute reference and a
relative reference?
11. Explain the use of the What-If Analysis tool, Goal Seek.
12. What are the common methods for protecting a worksheet?
SECTION B
Paragraph/Problem Questions (5 marks each)
Ceiling 30 marks
13. Describe the main components of the Excel interface,
including the ribbon, worksheet grid, and status bar.
14. Explain the process of creating a Pivot Chart from an existing
Pivot Table. What are the advantages of using a Pivot Chart?
15. Differentiate between a regular chart and a Pivot Chart.
Provide a scenario for when you would use each.
16. Explain the purpose of data validation in Excel. Provide an
example of how to restrict data entry to a specific list of values.
17. What are the benefits of using an Excel Table instead of a
regular range of cells?
18. You are given a dataset with sales figures. Write a step-by-step
procedure to use a VLOOKUP function to find the sales amount for
a specific product from a lookup table.
19. Explain how to create and use a named range in Excel. What
are the advantages of using named ranges in formulas?
SECTION C
Long Answer Questions (10 marks each)
Answer any one
20. Create pivot table to analyse sales data of a company.

21. Discuss the various functions categories in Excel. Pick any


three categories (e.g., Logical, Text, Date & Time) and provide a
detailed explanation of at least two functions from each category
with examples.

You might also like