Class 10 IT402 Question Answer Electronic Spreadsheet for PDF Click here

INFORMATION TECHNOLOGY (402)

CLASS 9

UNIT-4

 

ELECTRONIC SPREADSHEET

QUESTIONS /ANSWERS

 UNIT 4: ELECTRONIC SPREADSHEET


E. Short answer questions (50 words)

1. What do you call the document created in a spreadsheet application?

Answer:- Worksheet

 

2. What are the steps to create a new spreadsheet?

Answer:- Steps to create a new spreadsheet:-

Open LibreOffice Calc. à The click on Calc Spreadsheet à OK

 

3. What is the difference between spreadsheet, worksheet and sheet?

Answer:-  

Spreadsheet:- Spreadsheet is a long sheet of rows and columns on the computer screen to do data analysis and calculation. In other words, a spreadsheet is a grid which interactively manages and organises data in rows and columns.

Worksheet:- The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data.

Sheet:- Combination of the rows and columns make cell and collection of cell is called sheet.

 

4. What is the default name of the worksheet? How can it be renamed?

Answer:- The default name of the worksheet in Libra Office is Untitled 1 and using save or save as option we can rename it.

 

5. Write the steps to insert and delete the worksheet in Calc.

Answer:- To insert a worksheet click the + icon in bottom left corner.

To delete the worksheetà Right click on worksheet name à then click delete sheet.

 

6. What is an active cell? How to delete the contents of an active cell?

Answer:- In a spreadsheet, cell is the place where we enter the data. The selected or activated cell is called as active cell.

To press Delete key we can delete the contents of an active cell.

 

7. What is relative and absolute cell address in the spreadsheet?

Answer:- Relative referencing: When we drag the formula downwards in columns, the row number of the cell address gets one added. In the same way, when you drag the formula horizontally from the left to the right column, the column name of the cell address is added on to the next column letter.

Absolute referencing: 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.

 

 

 

8. Explain any two operations performed on data in a spreadsheet.

Answer:-

 Operator                          Formula                     Result

Addition (+)                        = 23+ 6                       29

Subtraction (-)                    = 0 – 6                        - 6

Multiplication (*)                 = 9*6                          54

Division (/)                         = 88/8                        11

Exponentiation (^)              = 2 ^ 5                        32

 

 

9. How do formulae work in a spreadsheet?

Answer:- Using the = (equal) symbol we can use formulae in a spreadsheet.

10.     Can you include more than one mathematical operators in a formula?

Answer:- Yes we can include more than one mathematical operators in a formula.

 

11.     How to make visible the desired toolbar a spreadsheet?

Answer:- To visible the desired toolbar a spreadsheet follow this steps:-

Goto View menu à Tool bar à select desire toolbar

 

12.     Give the syntax and example of any three mathematical functions in spreadsheet.

Answer:-

S.No.

Function

Syntax

Example

1

SUM

=SUM(Number1,Number2,.....)

=SUM(B5:F5)

2

MAX

=MAX(Number1,Number2,......)

=MAX(D1:D7)

3

COUNT

=COUNT(Number1,Number2,.....)

=COUNT(D1:D7)

      

13.     Give the syntax and example of any three statistical functions in spreadsheet.

Answer:-

S.No.

Function

Syntax

Example

1

SQRT

=SQRT(NUMBER)

=SQRT(5)

2

AVERAGE

=AVERAGE(Number1,Number2,......)

=AVERAGE(D1:D7)

3

COUNT

=COUNT(Number1,Number2,.....)

=COUNT(D1:D7)

 

14.     Give the syntax and example of any three decision making functions in spreadsheet.

Answer:-

S.No.

Function

Syntax

Example

1

IF

=IF(TEST,TRUE,FALSE)

=IF(B5>4,Y,N)

2

AND

=AND(Logical1,Logical 2……….)

=AND(D1>D7,B1>B5)

3

OR

=OR(Logical1,Logical 2……….)

=OR(D1>D7,B1>B5)

 

15.     Give the syntax and example of any three date and time functions in spreadsheet.

Answer:-

S.No.

Function

Syntax

Example

1

DATE

=DATE(YYYY,MM,DD)

=DATE(1985,05,02)

2

DAYS

=DAY(END DAY,START DAY)

=DAY(5,2)

3

NOW

=NOW( )

=NOW( )

 

16.     Give the syntax and example of any three logical functions in spreadsheet.

Answer:-

S.No.

Function

Syntax

Example

1

IF

=IF(TEST,TRUE,FALSE)

=IF(B5>4,Y,N)

2

AND

=AND(Logical1,Logical 2……….)

=AND(D1>D7,B1>B5)

3

OR

=OR(Logical1,Logical 2……….)

=OR(D1>D7,B1>B5)

 

17.     Give the syntax and example of any three string functions in spreadsheet.

S.No.

Function

Syntax

Example

1

LEN

=LEN(SELECT TEXT)

=LEN(O6)

2

BASE

=BASE(Number, Radix, Length)

=BASE(B4,1,N5)

3

ASC

=ASC(Text)

=ASC(O7)

 

18.     Explain the advantages of drawing a chart in Calc.

Answer:- The advantages of drawing a chart in Calc. are:-

·       It is very beneficial to draw a chart in Calc as calculations can be done easily.

·       It is numerical and If you have jotted down the right formula it will calculate the solution for you.

·       It shows the data in a very sophisticated manner.

·       It is a very powerful tool and is helpful for all the accountants or mathematicians out there.

·       It is easy and comfortable to use.

 

19.     Explain in one line each the various types of charts.

Answer :- The various types of charts are:-

1.  Column Chart:- Comparing classes of data items in group.

2.  Bar Chart:- Comparing classes of data items in group.

3.  Line Chart:- Comparing classes of data items in group.

4.  Pie Chart:- Comparing classes of data items as

5.  XY Scatter Chart:- Comparing data in pairs.

 

20.     Write the steps to insert a chart in Calc.

Answer:- Follow the steps given below to create charts.

·       Select the range of data (A1:F7)

·       Insert → Chart

·       Select the type of chart

·       Select the chart (Column Chart)

·       Click finish.

 

 

21.     Name and explain any five components of a chart in a spreadsheet package.

Answer:- components of a chart in a spreadsheet package are:-

1.  Chart area

2.  Chart title

3.  Axis title

4.  Plot area

5.  Axis values

Explanation:

1.  The chat area contains all diagram components.No part exists outside this area.

2.  The chart title is defined as a descriptive text displayed by a chart.

3.  The Axis title names are given to x-axis(horizontal) and y-axis(vertical).

4.  The plot area is  defined as chart location which shows real data presented by lines, bars, columns, dots etc.

5.  The Axis values are assigned to both of the X and Y axis.

22.  What is electronic spreadsheet? Write the different activities (function) of electronic spreadsheet. 

Answer:- Spreadsheet is a long sheet of rows and columns on the computer screen to do data analysis and calculation. In other words, a spreadsheet is a grid which interactively manages and organises data in rows and columns. It is also called as Electronic Spreadsheet. It is used for managing financial and accounting documents, creating data reports, generating invoices, data analysis from scientific and statistical researches, and for doing a variety of calculations on data.

 

LibreOffice Calc is used to perform the following activities accurately and efficiently.

1.  Tabulation of data

2.  Simple mathematical calculations

3.  Complex calculations using formula and functions

4.  Arranging data in ascending and descending order (sorting)

5.  Filtering the required data

6.  Check the validity of data

7.  Protection of data using passwords

8.  Saving for future use

 

23.  Name any two spreadsheet softwares.

Answer:- The two spreadsheet software’s are:

• Microsoft Excel

• LibreOffice Calc

• OpenOfficeCalc

• Apple Inc. Numbers

 

24.  What is the extension of libre office Calc file and ms Excel file?

Answer Ms Excel - .xlsx or .xls

Libre office Calc - .ods

25.  What is a worksheet?

Answer. The worksheet in Calc is also referred to as spreadsheet. The spreadsheet can have many sheets. Each sheet can have many individual cells arranged in rows and columns. The sheet tab shows its default name as Sheet1, Sheet2, Sheet3, ….

 

26. What is the difference between Rows and Columns?

Answer. The sheet is divided into vertical columns and horizontal rows. The rows are numbered as 1,2,3,4,… and columns are numbered as A, B, C, D, …., Z,

 

27. What is the difference between cell and cell address?

Answer. The intersection of a row and column is called a cell. It is the basic element of a spreadsheet. It holds data, such as text, numbers, formulas and so on. A cell address is denoted by its column (letter) and row number. For example, D4, E9, Z89 are the valid example of cell address.

 

28. What is an Active cell?

Answer In a spreadsheet, cell is the place where we enter the data. The selected or activated cell is called as active cell.

 

 

29. Based on the given table answer the following questions:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

i) Write the formula to calculate the sum of cell B1 to B5 and display the result in cell B7.

ii) Write the formula to calculate the average of cell B1 to B5 and display the result in cell B8.

iii) Write the formula to find the largest no. from cell B1 to B5 and display the result in cell B9.

iv) Write the formula to find the smallest no. from cell B1 to B5 and display the result in cell B10.

v) Write the formula to count the no. of elements in cell B1 to B5 and display the result in cell B11.

Answer.

i) Click on cell B7 and type =SUM(B1:B5)

ii) Click on cell B8 and type =AVERAGE(B1:B5)

iii) Click on cell B9 and type =MAX(B1:B5)

iv) Click on cell B10 and type =MIN(B1:B5)

v) Click on cell B11 and type =COUNT(B1:B5)

 

31. How many types of data can enter in electronic spreadsheet?

Answer:- The data to be entered in electronic spreadsheet :-

1.  Label

2.  Values or

3.  Formula.  

 

32 What is use of chart in electronic spreadsheet? Write the different chart that used in Libra office.

Answer:- It is not easy to comprehend, compare, analyze or present data when they are represented as numbers. But when data are presented in the form of charts they become an effective tool to communicate.

Column Chart

Bar Chart

Line Chart

Pie Chart

XY Scatter Chart