NIOS Class 12 Employability Skills Chapter 10 Spreadsheets

NIOS Class 12 Employability Skills Chapter 10 Spreadsheets Solutions English Medium As Per New Syllabus to each chapter is provided in the list so that you can easily browse throughout different chapters NIOS Class 12 Employability Skills Chapter 10 Spreadsheets Notes and select need one. NIOS Class 12 Employability Skills Chapter 10 Spreadsheets Question Answers Download PDF. NIOS Study Material of Class 12 Employability Skills Notes Paper Code: 350.

NIOS Class 12 Employability Skills Chapter 10 Spreadsheets

Also, you can read the NIOS book online in these sections Solutions by Expert Teachers as per National Institute of Open Schooling (NIOS) Book guidelines. These solutions are part of NIOS All Subject Solutions. Here we have given NIOS Class 12 Employability Skills Solutions in English, NIOS Senior Secondary Course Employability Skills Notes in English Medium for All Chapter, You can practice these here.

Spreadsheets

Chapter: 10

Module – III: Going Digital

INTEX QUESTION 10.1

Find out what went wrong in the steps. Write the correct steps: 

1. Iqbal wanted to start a new spreadsheet. He clicked Start → Microsoft Office → All Programs → Microsoft Office Excel 2007 → File. 

Ans: Iqbal should have clicked Start ’! All Programs ’! Microsoft Office ’! Microsoft Office Excel 2007.

2. Mixed Referencing: While referencing Satbir did not want the contents of row 10 to change while copying the contents from B column, so he used the formula ($B10) 

Ans: Satbir should have used referencing B$10 instead of $B10

3. Formula: Juhi wants to add all the data from C2 to C10 cell in C11 cell, she has calculated the sum by mentioning C2 + C3 + C4 + C5 + C6 + C7 + C8 + C9 + C10 

Ans: Juhi should have used formula =SUM(C2:C10) in the C11 cell.

INTEX QUESTION 10.2

Find out what went wrong in the following steps. Write the correct way of doing these steps. 

1. Ishan wanted to view his grades in a specific subject consisting of all subjects grades in a spreadsheet. He has used sorting technique for it. 

Ans: Ishan should have applied filtering on the subject cell column and then selected the specific subject from it.

2. Saahil wanted to change colour of the cell in which he has scored less than 30 marks for different subjects. He has used colour scales technique for it. 

Ans: Saahil should have used Highlight Cell Rules technique for it.

3. Aafreen wants to display her expenditure of different items in percentage form. She has used the bar graph for it. 

Ans: Aafreen should have used pie chart for displaying the percentage of different items.

TERMINAL QUESTIONS

1. What are the different data formats available in Spreadsheet? 

Ans: (i) General: Default format; shows the data as you type it.

(ii) Number:Used for numbers; you can add decimal places and commas.

(iii) Currency: Shows numbers with a money sign like ₹, $, or €.

(iv) Accounting: Like currency, but neatly aligns symbols and decimals.

(v) Date: Changes numbers into calendar dates (like 01/01/2025).

(vi) Time: Shows time (like 10:30 AM or 17:45).

(vii) Percentage: Converts numbers into percent (0.5 becomes 50%).

(viii) Fraction: Shows numbers as fractions (0.25 becomes 1/4).

(ix) Scientific: Shows big or small numbers using “E” (1230000 becomes 1.23E+06).

(x) Text: Treats everything as text; even numbers won’t be used in calculations.

(xi) Custom: You can create your own special format (like 01-Jan-2025).

2. Mention some frequently used functions in Spreadsheet. 

Ans: (i)  SUM() – Adds numbers. = SUM(A1:A5)

(ii) AVERAGE() – Finds the average. = AVERAGE(B1:B5)

(iii) MAX() – Gives the biggest number. = MAX(C1:C5)

(iv) MIN() – Gives the smallest number. = MIN(D1:D5)

(v) IF() – Checks a condition and gives answer. = IF(E1>40, “Pass”, “Fail”)

(vi) COUNT() – Counts how many numbers are there. = COUNT(F1:F5)

(vii) COUNTA() – Counts all filled cells (numbers + text). = COUNTA(G1:G5)

(viii) TODAY() – Shows today’s date. =TODAY()

(ix) NOW() – Shows current date and time. =NOW()

(x) CONCAT() – Joins two words or names. =CONCAT(A1, B1)

3. What is the benefit of using formula in Spreadsheet? 

Ans: Benefits of Using Formula in Spreadsheet:

(i) Saves time: Calculates quickly.

(ii) Gives correct results: Less chance of mistakes.

(iii) Auto-updates: Changes result when data changes.

(iv) Handles big data easily.

(v) Helps in analysis and reports.

4. What are the different cell referencing techniques used in calculation? 

Ans: The different cell referencing techniques used in calculation in a spreadsheet are:

(a) Relative Reference (e.g., A1):

(i) Changes when the formula is copied to another cell.

(ii) Example: =A3*B3 becomes =A5*B5 when copied to row 5.

(iii) Used for repeating calculations across rows or columns.

(b) Absolute Reference (e.g., $A$1):

(i) Does not change when copied or filled.

(ii) The column and row remain fixed.

(iii) Used when a constant value is needed in calculation

(c) Mixed Reference:

(i) A combination of absolute and relative reference.

(ii) Two types:

(a) A$1 – Row stays constant, column can change.

(b) $A1 – Column stays constant, row can change.

5. What is benefit of using Freeze Panes in Spreadsheet?

Ans: The benefit of using Freeze Panes in a spreadsheet is that it keeps the columns above and rows to the left of the cell cursor fixed. This means when you scroll down or to the right, those parts stay visible, making it easier to view and compare data.