Scribd
Upload
577 views2 pages

MDC-CS - Data Analysis & Visualisation Through Spreadsheets 2024

This document is an examination paper for the First Semester Degree Examination in Computer Science, focusing on Data Analysis and Visualization through Spreadsheets. It includes three sections with questions on Excel functions, data management, and visualization techniques, with varying mark allocations. Students are required to demonstrate their understanding of Excel features and functionalities through practical examples and explanations.

Uploaded by

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

MDC-CS - Data Analysis & Visualisation Through Spreadsheets 2024

This document is an examination paper for the First Semester Degree Examination in Computer Science, focusing on Data Analysis and Visualization through Spreadsheets. It includes three sections with questions on Excel functions, data management, and visualization techniques, with varying mark allocations. Students are required to demonstrate their understanding of Excel features and functionalities through practical examples and explanations.

Uploaded by

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

5

563952

7
D 113387 (Pages : 2) Name.....................................

1
Reg. No.................................

FIRST SEMESTER (CUFYUGP) DEGREE EXAMINATION


NOVEMBER 2024

1
Computer Science

CSC1FM105—DATA ANALYSIS AND VISUALIZATION THROUGH SPREADSHEETS

(2024 Admission onwards)

Time : One Hour and a Half Maximum : 70 Marks

5
Section A

All question can be answered.

7
Each question carries 2 marks.
Ceiling 16 marks.

1. How do you insert and delete cells, rows, and columns in an Excel worksheet ?

1
2. Describe the use of the IF function in Excel and provide a simple example.

1
3. What is the difference between the FLOOR and CEIL functions in Excel ?

4. Explain the steps involved in importing data from an external source into Excel.

5. How do you perform sorting by multiple columns in Excel ?

6. Outline the steps for creating a Pivot Table in Excel.

7. How does “Goal Seek” differ from standard “What-If Analysis” in Excel ?

5
8. What are the steps involved in creating a chart in Excel ?

9. How can you generate a Pivot Chart from a Pivot Table in Excel ?

7
10. What is the difference between the “Split” and “Freeze” options in Excel, and when would you use
them ?

1 1
563952
Turn over
5
563952

7
2 D 113387

Section B

1
All questions can be answered.
Each question carries 6 marks.

1
Ceiling : 24 marks.

11. Compare relative, absolute, and mixed cell referencing in Excel with examples.

12. Explain how data validation functions in Excel and describe how to remove duplicate values from
a dataset.

13. How does.the Watch Window feature help in tracking changes in Excel data ?

5
14. Discuss how dashboards and form controls can be utilized in Excel to create interactive data reports.

15. What are Excel Add-ins, and how do they improve the functionality of the program ?

7
Section C

Answer any one question. The question carries 10 marks.

1
16. Explain the process of linking data between multiple worksheets, its uses, and common issues that
may arise.

1
17. Discuss the key features of Pivot Tables in Excel and their importance, using an example to illustrate
their functionality.

(1 × 10 = 10 marks)

1 75
1
563952

You might also like