50+ Important Electronic Spreadsheet Class 9 Questions and Answers

Share with others

Electronic Spreadsheet Class 9 Questions and Answers

Q1. What do you mean by Spreadsheet/Electronic Spreadsheet?

Ans. A spreadsheet is a grid which interactively manages and organises data in rows and columns. It is also called as Electronic Spreadsheet.

Q2. Write three uses of spreadsheet.

Ans. Spreadsheet is used for:

  1. Managing financial and accounting documents.
  2. Creating data reports, generating invoices.
  3. Data analysis from scientific and statistical researches.

Q3. List any four activities which can be done accurately or efficiently on Libre Office Calc.

Ans. Four activities are :

  1. Filtering the required data.
  2. Calculations using formula and functions.
  3. Check the validity of data.
  4. Arranging data in ascending and descending order.

Q4. Write any three Spreadsheet software.

Ans. Three Spreadsheet software are :

  1. Microsoft Excel
  2. LibreOffice Calc
  3. OpenOfficeCalc
  4. Apple Inc. Numbers

Q5. In which operating system Libre Office installed by default?

Ans. Linux(Ubuntu)

Q6. Name any three components of Libre Office.

Ans. Three components of Libre Office are:

  1. LibreOffice Calc
  2. LibreOffice Writer
  3. LibreOffice Impress

Q7. How to start the LibreOffice Calc in Windows?

Ans. Steps to start the LibreOffice Calc in Windows are:

Double click the shortcut of LibreOffice on the Desktop.

OR

Click the window menu, select LibreOffice application, then click LibreOffice Calc.

Q8. How to start the LibreOffice Calc in Linux?

Ans. In Ubuntu Linux, find the Calc icon on application launcher or search it by clicking on “Show Application” and then click on icon.

Q9. Name any seven parts of User interface of Libre Office Calc.

Ans. Seven parts of User interface of Libre Office Calc are:

  1. Quick Access Tool bar
  2. Title bar
  3. Ribbon
  4. Control Buttons
  5. Name Box
  6. Formula bar
  7. Formatting Tool bar
  8. Zoom Control
  9. Column Heading
  10. Row Heading.

Q10. Identify the following components of LibreOffice Calc Interface.

Electronic Spreadsheet Class 9 Questions and Answers
Electronic Spreadsheet Class 9 Questions and Answers

Ans. Name of Components are

  1. A – Name Box
  2. B – Vertical Scroll Bar
  3. C – Zoom Control
  4. D – Quick Access Tool Bar
  5. E – Status Bar
  6. F – Formula Bar

Electronic Spreadsheet Class 9 Questions and Answers

Q11. Name the bar which is located at the top of the Libre Office Calc window.

Ans. Title bar

Q12. ______________ bar shows the name of the current spreadsheet.

Ans. Title

Q13. What is the default name of the first file opened in Libre Office Calc?

Ans. Untitled 1

Q14. Name any four items/options available on Menu bar.

Ans. Four items/options available on Menu bar are : (write any four)

  1. File
  2. Edit
  3. Insert
  4. View
  5. Format
  6. Styles

Q15. Name and explain in brief any two toolbars which provide a wide range of common commands and functions in Libre Office Calc.

Ans. Two toolbars are :

1. Standard Toolbar : The standard tool bar shows the icons for most common operations, such as editing, arranging, filtering, etc.

2. Formatting Toolbar : It includes buttons for font selection, size of text, alignment, cell value formatting and indentation, etc.

Electronic Spreadsheet Class 9 Questions and Answers

Q16. What do you mean by Tooltip?

Ans. When we place the mouse cursor over any icon, it displays a small box called a tooltip. It gives a brief explanation of the icon function.

Q17. What do you mean by Worksheet in Calc?

Ans. The worksheet in Calc is also referred to as spreadsheet. Each sheet can have many individual cells arranged in rows and columns.

Q18. Differentiate between Row and Column.

Ans. Differences are:

RowColumn
The horizontal lines in worksheet are called rows The vertical lines in worksheet are called columns
Row headings are represented by numbers like 1, 2, 3 etc.Column headings are shown by Capital Alphabet like A, B, C etc.

Q19. Name the basic element or building block of spreadsheet.

Ans. Cell

Q20. What do you mean by Cell?

Ans. The intersection of a row and column is called a cell.

Electronic Spreadsheet Class 9 Questions and Answers

Q21. What do you mean by Active Cell?

Ans. The selected cell is called Active Cell. It is always highlighted, with a thick border. The address of the active cell is displayed in the name box.

Q22. Write the cell address of the following

  1. First row and first column ………..
  2. First column and last row …………
  3. First row and last column ………..
  4. Last column first row ……..
  5. Seventh column and tenth row …….
  6. Tenth column and nineteenth row ……..
  7. The cell address LK89 is situated in row number……… and column letter ……..

Ans.

  1. A1
  2. A1048576
  3. AMJ1
  4. AMJ1
  5. G10
  6. J19
  7. 89 and LK

Q23. Write the shortcut to move the cell to the end of the data range in a particular direction.

Ans. Ctrl + Arrow Keys

Q24. Write the shortcut to move the cell pointer to A1 position.

Ans. Ctrl + Home

Q25. Write the shortcut to move the cell pointer to bottom right cell of the data range.

Ans. Ctrl + End

Q26. What do you mean by Range of cells?

Ans. A block of adjacent cells in a worksheet which is highlighted or selected is called a range of cells. for example A1 : C3

Q27. Identify the following range of cells as Row range, Column range, Row and Column range.

  1. A1 : A7
  2. A1 : D1
  3. A3 : D7
  4. B4 : B12
  5. C9 : J9

Ans.

  1. A1 : A7 – – – – – Column Range
  2. A1 : D1 – – – – – Row Range
  3. A3 : D7 – – – – – Row and Column Range
  4. B4 : B12 – – – – – Column Range
  5. C9 : J9 – – – – – Row Range

Electronic Spreadsheet Class 9 Questions and Answers

Q28. Answer the questions based on the following worksheet.

  1. What is the address of the first cell represented by Range1?
  2. What is the address of the last cell represented by Range1?
  3. Write the cell range represented by Range1.
  4. Write the cell range represented by Range 2.
  5. What is the name of the cell range along a row?
  6. What is the name of the cell range along a column?
  7. Write the cell range represented by Range 3.
  8. Give the number of cells in the cell range represented by Range 3.
Ans. 

1. B5
2. D5
3. B5 : D5
4. F5 : F11
5. Range 1
6. Range 2
7. B7 : C12
8. 12

Q29. Name the three types of data that can be entered in a cell.

Ans. Three types of data that can be entered in a cell are :

  1. Label
  2. Values
  3. Formulae

Q30. What do you mean by Formula in Calc?

Ans. Any expressions that begins with an equals to sign (‘=’) is treated as formula. for example =A1 + B1

Q31. Evaluate the expression = (5*4)^2

Ans. 400

Q32. Evaluate the following equations using operator precedence and then test the result in the spreadsheet.

  1. 8-4/2
  2. 5*5+8
  3. 3+5*4
  4. 2^5+8
  5. 3+2^2
  6. 5+6*2^2
  7. 8/4*4
  8. -4/2+2
  9. 1+2^2-2
  10. 4*3/2
Ans. 

1. 6
2. 33
3. 23
4. 40
5. 7
6. 29
7. 8
8. 0
9. 3
10. 6

Electronic Spreadsheet Class 9 Questions and Answers

Q33. If you forgot to put the ‘=’ before the formula, it will be treated as a ________________

Ans. Label

Q34. Identify the correct formula from the following :

  1. =A1 + B1
  2. B2 = C1 * 2
  3. B1 + C1*4
  4. =A1 = D3

Ans. Correct formula is = A1 + B1

Q35. Write the steps to insert a column before any column.

Ans. To insert a column before any column, position the cursor on any cell of the column before which you want to insert the column and select
Sheet → Insert Columns → Columns → Columns left

Q36. What do you mean by Function in Calc?

Ans. A function is a predefined formula which help to do mathematical, statistical operations.

Q37. Explain the following functions with examples:

  1. sum
  2. average
  3. max
  4. min
  5. count

Ans.

1. Sum : This function adds the values contained in a range of cells. for example = sum(A1 : A5) will add all the values of cell A1, A2, A3, A4 and A5.

2. Average : This function finds out the average of the values contained in a range of cell. for example =average(A1 : A5) will return the average of values present in cell A1, A2, A3, A4 and A5.

3. Max : This function return the largest value contained in a range of cells. for example =max(A1 : A5) will return the largest value present in cell A1, A2, A3, A4 and A5.

4. Min : This function return the smallest value contained in a range of cells. for example =min(A1 : A5) will return the smallest value present in cell A1, A2, A3, A4 and A5.

5. Count : This function counts the number of non-empty cells within a range of cells. for example =count(A1 : A5) will return 5, if all cells contain some any value.

Electronic Spreadsheet Class 9 Questions and Answers

Q38. Write the output of the following on the basis of the given screenshot.

Eelectronic-spreadsheet-class-9-questions-and-answers screenshot
Electronic spreadsheet class 9 questions and answers screenshot
  1. =SUM (A1,B1,C1)
  2. =SUM(A1:C1)
  3. =SUM(A1:C1,B2)
  4. =SUM(B1:C2)
  5. =SUM(A1:A3,C1:C3)
  6. =AVERAGE (A1,B1,C1)
  7. =AVERAGE (A1:C1)
  8. =AVERAGE (A1:C1,B2)
  9. =AVERAGE (B1:C2)
  10. =AVERAGE (A1:A3,C1:C3)
  11. =MAX(A1,B2,C1)
  12. =MAX(A2:C2,B3)
  13. =MAX(A1:C1)
  14. =MAX(A1,B1:C2)
  15. =MIN(A1,B2,C1)
  16. =MIN(A2:C2,B3)
  17. =MIN(A1:C1)
  18. =MIN(A1,B1:C2)
  19. =COUNT(A1,B1)
  20. =COUNT(A1:C1)
  21. =COUNT(A1:A4)
  22. =COUNT(A1:C1,B2)
  23. =COUNT(B1:C3)
  24. =COUNT(A1:A3,C1:C3)
Ans.

1. 17
2. 17
3. 24
4. 23
5. 37
6. 5.66
7. 5.66
8. 6.33
9. 5.75
10. 6.16
11. 7
12. 8
13. 7
14. 7
15. 5
16. 4
17. 5
18. 4
19. 2
20. 3
21. 3
22. 4
23. 6
24. 6

Electronic Spreadsheet Class 9 Questions and Answers

Q39. Write the shortcut to open Format cell dialog box.

Ans. Ctrl + 1

Q40. Write the steps to format a cell to the required number of decimal places.

Ans. The steps to format a cell to the required number of decimal places are :

  1. Select the range of cells.
  2. Open the ‘format cells dialog’ box
  3. Click the ‘Number’ tab
  4. Select the ‘Number’
  5. Change the decimal places as required
  6. Click ‘OK’

Q41. Write the steps to format a range of cells as text.

Ans. Steps to format a range of cells as text:

  1. Select the range of cells
  2. Open the ‘format cells dialog’ box
  3. Click the Number tab
  4. Select Text
  5. Click ‘OK’
  6. Enter numbers

Q42. Aman is writing telephone number along with STD code (starting from zero ‘0’). He noticed that the first digit zero (‘0’), disappears from the telephone number. Write the reason for this. What can be done to store telephone number starting from zero in a cell?

Ans. This is because the telephone number is stored as a numeric value, and the numeric value does not have a preceding zero.

We can store telephone number starting from zero in a cell by formatting the cell consisting of telephone number as ‘text’.

Q43. Write answers for the following queries using functions.

electronic spreadsheet class 9 questions and answers q
electronic spreadsheet class 9 questions and answers

1. Write the formula in E2 to find the total marks scored by HARMAN.

Ans. =sum(B2 : D2)

2. Write the formula in F2 to find the average marks scored by HARMAN.

Ans. =average(B2 : D2)

3. Write the formula in cell B7 to find the highest score in Hindi.

Ans. =max(B2 : B6)

4. Write the formula in cell B8 to find the total number of students who appeared in Hindi?

Ans. =count(B2 : B6)

5. Write the formula in cell B9 to find the lowest score in Hindi.

Ans. =min(B2 : B6)

6. How will you find the lowest score in English and Maths?

Ans. We can find the lowest score in English and Maths by any of the following:

1. Drag the formula from B9 to D9

OR

2. Copy paste the formula from B9 to C9 and D9.

OR

3. Write formula =min(C2 : C6) in C9 and =min(D2 : D6) in D9

7. How will you find the highest score in Hindi, English and Maths?

Ans. We can find the highest score in Hindi, English and Maths by writing the following formula:

for Hindi : =max(B2 : B6)

for English: =max(C2 : C6)

for Maths : =max(D2 : D6)

Electronic Spreadsheet Class 9 Questions and Answers

Q44. Name and explain the three types of data that can be entered in a cell.

Ans. Three types of data that can be entered in a cell are :

1. Label : Label is any text entered by using a keyboard. It may be any letter, number, or special symbol. By default the labels are left aligned.

2. Values: The numerical data consisting of only numbers are called values. By default values are right aligned.

3. Formula: Any expressions that begins with an equals ‘=’ is treated as formula. When a formula is entered in a cell the formula bar gets activated.

Q45. What is fill handle in Calc?

Ans. The small black square in the bottom-right corner of the selected cell or range is called a fill handle.

Q46. Write the shortcut for the following:

  1. Copy the formula
  2. Paste the formula

Ans. Shortcuts are :

  1. Ctrl + C
  2. Ctrl + V

Q47. What do you mean by Referencing in Calc?

Ans. Referencing is the way to refer the cell or range of cell in a formula or function.

Q48. Name the three types of referencing in Calc.

Ans. Three types of referencing in Calc are:

  1. Relative referencing
  2. Mixed referencing
  3. Absolute referencing

Q49. Explain the Relative referencing in Calc with example.

Ans. When you drag any formula in any row or column in any direction, the formula gets copied in the new cell
with the relative reference. for example =C1 is an example of relative referencing, as this formula changes automatically when we drag it vertically or horizontally.

Q50. What do you mean by mixed referencing in Calc?

Ans. In Mixed Referencing, the $ sign is used before row number or column name to make it constant. for example = C$1 is an example of mixed referencing, as this formula changes only when you drag it horizontally.

Electronic Spreadsheet Class 9 Questions and Answers

Q51. What do you mean by absolute referencing in Calc?

Ans. In Absolute referencing, a $ symbol is used before the column name as well as row number to make it constant in any formula. For example, $C$12, $D$5, etc. In this case, even if you drag your formula in any
direction, the cell name remains constant.

Q52. Identify the types of referencing from the following

  1. =C1
  2. =D$2
  3. =$W2
  4. =$E$4

Ans.

  1. Relative Referencing
  2. Mixed Referencing
  3. Mixed Referencing
  4. Absolute Referencing

Q53. Name any four types of charts that can be created in Open Office Calc.

Ans. Four types of Charts are :

  1. Bar Chart
  2. Column Chart
  3. Pie Chart
  4. Line Chart

Q54. Write the steps to create column chart in Calc.

Ans. Steps to create column chart in Calc are:

  1. Select the range of data.
  2. Click on Insert → Chart
  3. Select the type of chart
  4. Select the chart (Column Chart)
  5. Click finish.

Electronic Spreadsheet Class 9 Questions and Answers

Q55. Create the following worksheet in calc and write the formula for the task given below.

  1. Enter the formula in G2 to calculate the total marks scored by Harman
  2. Enter the formula in H2 to calculate the average scored by Harman.
  3. Enter the formula in B9 to find out the highest score obtained for science.
  4. Enter the formula in B10 to find out the lowest score obtained by students in each subject.
  5. Enter the formula in B11 to find out the number of students present for each subject.
  6. Enter the formula in B12 to find out the average score of each subject.
 Ans. 

1. =sum(B2 : F2)
2. =average(B2 : F2)
3. =max(C2 : C8)
4. Write formula =min(B2 : B8) in B10 and then drag horizontally till F10.
5. Write formula =count(B2 : B8) in B11 and then drag horizontally till F11.
6. Write formula =average(B2 : B8) in B12 and then drag horizontally till F12.

Electronic Spreadsheet Class 9 Questions and Answers

Q56. Create the following worksheet in calc and write the formula for the task given below.

Eelectronic-spreadsheet-class-9-questions-and-answers
Electronic spreadsheet class 9 questions and answers
  1. Write formula in D5 to calculate TA of Firoz Khan.
  2. Write formula in E3 to calculate DA of Deepak Gautam.
  3. Write formula in F8 to calculate HRA of Nikki Khanna.
  4. Write formula in G7 to calculate CPF of Meena Kumari.
  5. Write formula in C12 to display the highest Basic salary.
  6. Write formula in I10 to calculate the gross salary of Vinay Kumar.
  7. Write formula in H12 to calculate the average of Gross Salary of all employees.
  8. Write formula in B12 to display the total number of employees.
  9. Write formula in I11 to calculate average of TA, DA and HRA of Yusuf.
  10. Write formula in C13 to calculate the sum of Basic Salary of all employees.
Ans.

1. = 6/100 * C5
2. = 14/100 * C3
3. = 10/100 * C8
4. = 3/100 * C7
5. = max (C2 : C11)
6. = sum (D10 : G10)
7. = average (H2 : H11)
8. = count (B2 : B11)
9. = average (D11 : F11)
10. = sum (C2 : C11)

Q57. Create the following worksheet in calc and write the formula for the task given below.

Eelectronic-spreadsheet-class-9-questions-and-answers q7
Electronic spreadsheet class 9 questions and answers
  1. Write formula in H2 to calculate total marks of Amit.
  2. Write formula in C12 to calculate minimum marks in Hindi.
  3. Write formula in H6 to display lowest marks of Gagan.
  4. Write the cell range which has marks of Nikki (of all subjects).
  5. Write formula in H7 to calculate percentage of Meena.(Assume all marks are out of 100)
  6. Write formula in B12 to calculate total number of students.
  7. Write formula in H9 to calculate the 10% of total marks of Tejpal.
  8. Write formula in I12 to calculate average marks of Science subject.
  9. Write formula in H2 to calculate total marks of subject English, Maths and Biology of Amit.
  10. Write formula in H4 to calculate the average of best three marks of Chetna.
Ans. 

1. = sum (C2 : G2)
2. = min (C2 : C11)
3. = min (C6 : G6)
4. Cell range is C8 : G8
5. = sum (C7 : G7)/500 * 100
6. = count (B2 : B11)
7. = (C9 + D9 + E9 + F9 + G9) * 10/100
8. = average (E2 : E11)
9. = D2 + F2 + G2
10. = average(C4 + D4 + G4)

Q58. Create the following worksheet in calc and write the formula for the task given below.

Electronic spreadsheet class 9 questions and answers
Electronic spreadsheet class 9 questions and answers
  1. Write formula in E2 to calculate the Total price (Quantity * Price) of Pencil.
  2. Write formula in C7 to calculate total of Price values
  3. Write formula in D7 to calculate maximum value of column ‘QTY’.
  4. Write formula in C8 to calculate average of Price values.
  5. Write formula in C9 to find lowest value of column ‘PRICE’.
  6. = C4 * D4 will return ____________
  7. Write the cell range of all the numerical values of column ‘QTY’
  8. Write the cell address which stores largest/maximum value of column ‘PRICE’.
  9. How many values are stored in range C2 : D6?
Ans. 

1. = C2 * D2
2. =sum (C2 : C6)
3. = max (D2 : D6)
4. = average (C2 : C6)
5. = min (C2 : C6)
6. 750
7. D2 : D6
8. C5
9. 10

Electronic Spreadsheet Class 9 Questions and Answers

Disclaimer : I tried to give you the correct “Electronic Spreadsheet Class 9 Questions and Answers, but if you feel that there is/are mistakes in “Electronic Spreadsheet Class 9 Questions and Answers” given above, you can directly contact me at csiplearninghub@gmail.com. Book and Study material available on CBSE official website are used as an idea to create above “Electronic Spreadsheet Class 9 Questions and Answers“. All the answers of Electronic Spreadsheet Class 9 Questions and Answers are in reference with LibreOffice.

Electronic Spreadsheet Class 9 Questions and Answers


Important Links of Class IX

Click here to download book pdf

Unit 1 : Introduction to IT–ITeS Industry

MCQ—————————–Notes———————Book Solution————— Practice Questions

Unit 2 : Data Entry and Keyboarding Skills

MCQ—————————–Notes———————Book Solution————— Practice Questions

Unit 3 : Digital Documentation

MCQ—————————–Notes———————Book Solution————— Practice Questions

Unit 4 : Electronic Spreadsheet

MCQ—————————–Notes———————Book Solution————— Practice Questions

Unit 5 : Digital Presentation

MCQ—————————–Notes———————Book Solution————— Practice Questions


Share with others

Leave a Reply

%d bloggers like this: