Scribd
Upload
9 views3 pages

Dsc305 Question Solution Clean

Uploaded by

shivamkumarpandey835
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
9 views3 pages

Dsc305 Question Solution Clean

Uploaded by

shivamkumarpandey835
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/ 3

Section A: Short Answer (6 marks each)

1. Summarize the basic functionalities of spreadsheet application.

Spreadsheet applications like Excel help in:


- Organizing, storing, and managing data in tabular form.
- Performing mathematical operations using formulas and functions.
- Visualizing data through charts (bar chart, pie chart, line chart, etc.).
- Sorting and filtering data.
- Automating tasks using macros.
- Performing advanced calculations with built-in functions.

2. List ten math and trigonometry functions with brief descriptions.

- SUM: Adds values.


- AVERAGE: Calculates average.
- MAX: Returns maximum value.
- MIN: Returns minimum value.
- SQRT: Returns square root.
- ROUND: Rounds a number to specified decimals.
- POWER: Raises a number to a power.
- PI: Returns the value of pi.
- SIN: Returns sine of an angle.
- COS: Returns cosine of an angle.

3. Summarize the characteristics of a bar chart.

A bar chart:
- Displays data in rectangular bars.
- Bars can be horizontal or vertical.
- Used to compare discrete values.
- Length of bars represents the magnitude of values.
- Easy to interpret and analyze data.

4. Demonstrate how one can insert and rename an Excel sheet.

To insert a sheet: Right-click on the sheet tab > Select 'Insert'.


To rename a sheet: Double-click the sheet name > Type the new name > Press Enter.

Section B: Descriptive (10 marks each)

5. Demonstrate the working of lookup functions.

Lookup functions like VLOOKUP and HLOOKUP retrieve data from a table based on matching
values.
Example: Using VLOOKUP:
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
It finds a value in the first column of a table and returns the value in a specified column.

6. Summarize the features of a pie chart with examples.

A pie chart:
- Divides data into slices to show proportions.
- Each slice represents a category's percentage of the whole.
- Useful for showing parts of a whole.
Example: Visualizing sales contribution of products (Product A = 30%, Product B = 70%).

7. Demonstrate the basic functions of Excel menus with examples.

- Home Menu: Formatting cells (font, alignment, etc.).


- Insert Menu: Adding charts, tables, and images.
- Formulas Menu: Inserting functions like SUM, IF, VLOOKUP.
- Data Menu: Sorting, filtering, and data validation.
- Review Menu: Adding comments and protecting sheets.

8. Demonstrate the use of a pivot table with an example.

A pivot table summarizes large data sets.


Example: Summarize sales by region:
- Select data > Insert > Pivot Table > Drag 'Region' to Rows and 'Sales' to Values.

Section C: Compulsory (20 marks)

10. Given Dataset Analysis


a) Total Marks and Pass/Fail Status in Excel
Add two columns:
1. Total Marks: Use the formula: =Marks1 + Marks2
2. Pass/Fail: If passing marks are 50%, use:
=IF((Marks1 + Marks2)/2 >= 50, "Pass", "Fail")

| SL# | Name | Marks 1 | Marks 2 | Total Marks | Status |


|-----|-----------|---------|---------|-------------|--------|
| 1 | Student 1 | 32 | 26 | 58 | Pass |
| 2 | Student 2 | 35 | 41 | 76 | Pass |

b) Visualizing the data in Excel

Chart Choice: Use a Bar Chart to compare individual students' performance.


Reason: A bar chart clearly displays each student's total marks, making comparisons easy.

c) Justification for the Bar Chart

The bar chart:


- Provides a clear visual representation.
- Makes it easy to compare total marks among students.
- Suitable for discrete data such as student-wise marks.

You might also like