Class 9 IT 402 Unit 4 Electronic Spreadsheet Question – Answer / MCQ

Class 9 IT 402 Unit 4 Electronic Spreadsheet Question – Answer / MCQ

Multiple Choice Questions

1.Which of the following technique can be used to allow only date value in cell?
(a) Data formatting (b) Data sorting
(c) Data filtering (d) Data validation

Ans: (d) Data validation

2. Which of the following options when selected deletes all data validation?
(a) Delete formatting (b) Delete all
(c) Delete formula (d) Delete me

Ans: (b) Delete all

3. We can replace multiple occurrences of a word using which of the following facilities of Calc?
(a) Find and replace
(b) By replace only
(c) By copy command
(d) By preview command

Ans: (a) Find and replace

4. What is the name of mechanism to arrange the data in a particular order?
(a) Sorting (b) Searching
(c) Filtering (d) Validating

Ans: (a) Sorting

5. What is the name of mechanism to filter out unnecessary data?
(a) Sorting (b) Searching
(c) Filtering (d) Validating

Ans: (c) Filtering

6. Which of the following type of package does Calc refer to?
(a) Spreadsheet (b) Double sheet
(c) Multi-sheet (d) Cannot determine

Ans: (a) Spreadsheet

7. Which of the following is an extension of a worksheet created in Calc?
(a) .ods (b) .odd
(c) .xls (d) .obj

Ans: (a) .ods

8. How can one calculate the total of values entered in a worksheet column of?
(a) By manual entry (b) By auto-sum
(c) By formula (d) By sum function

Ans: (b) By auto-sum

9. If we move a cell containing a formula having reference to another cell in the worksheet what will happen to the cell
numbers used in the formula?
(a) The cell row and columns are changed at destination.
(b) The cell row change at destination.
(c) The cell columns are changed at destination.
(d) No change will scour.

Ans: (a) The cell row and columns are changed at destination.

10. What is the correct way to enter a function in Calc?
(a) Directly typing function name in a cell
(b) Using function wizard or selecting from toolbar
(c) Both (a) and (b)
(d) Depends on the function

Ans: (c) Both (a) and (b)

11. A function should start with__________________.
(a) ‘=’ sign (b) alphabets
(c) numbers (d) All of the these

Ans: (a) ‘=’ sign

12. Which of the following option is used to print a chart?
(a) Insert → Chart (b) File → View
(c) File → Print (d) View → Chart

Ans: (c) File → Print

13. How many axes does charts in Calc have?
(a) Two (b) Three
(c) Two or three (d) Four

Ans: (a) Two

14. The chart preview can be seen in________________.
(a) Page preview (b) Chart preview
(c) Export chart (d) All of these

Ans: (a) Page preview

Fill in the blanks

1. The column immediately next to column “Z” is _______.

Answer: AA

2. The default extension of a workbook created using a LibreOffice Calc spreadsheet is ____.

Answer: .ods

3. The spreadsheet feature used to continue the series is called as ______.

Answer: Fill Handle

4. The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to ____.

Answer: MIN(D1: D5)

5. The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to ____.

Answer: D2 + E3

6. The cell address of the cell formed by the intersection of the ninth column and the eighth row will be ____.

Answer: I8

7. $A1$B2 is an example of _ referencing in spreadsheet software.

Answer: Mixed

8. Numbers entered into a cell are automatically _ aligned.

Answer: Right

9. If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display______________.

Answer: 20

10. In _______________referencing, the reference changes rows and columns automatically when it is copied to a new cell.

Answer: Relative

State whether the following statements are True or False

1. A cell is a combination of row and column.

Answer: False

2. A spreadsheet is also called as worksheet.

Answer: True

3. There are ‘n’ number of sheets in a spreadsheet.

Answer: False

4. In a spreadsheet, we can change the column width and row height.

Answer: True

5. $A1$B2 is an example of mixed referencing.

Answer: True

Short answer questions (50 words)

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

Answer: The document created in a spreadsheet application is Workbook.

Question 2: What are the steps to create a new spreadsheet?

Answer: Ctrl +N

or

Click on New Icon in Standard Toolbar.

or

Click on File > New > Spreadsheet.

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

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

Worksheet: The collection of sheets is known as Worksheet. It is also known as Spreadsheet.

Sheet: Sheet is the actual page where you are suppose to work. A sheet can have many individual cells arranged in rows and columns.

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

Answer: The default name of the worksheet is Sheet1 , Sheet2…

To rename a sheet:

Select the Menu Sheet—> Rename Sheet—-> Type New Name and Press OK.

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

Answer:

Insert a worksheet

• Select the New Sheet plus icon  at the bottom of the workbook.
• Or, select Home > Insert > Insert Sheet.
• 

Delete a worksheet

• Right-click the Sheet tab and select Delete.
• Or, select the sheet, and then select Home > Delete > Delete Sheet.

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

Answer: The currently selected cell is called an active cell.

To delete the content of an active cell, press Delete button from keyboard.

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

Answer: A cell address which changes when a formula is copied to another cell is called Relative cell address. Exp: A2

.Absolute references, on the other hand, remain constant no matter where they are copied. Exp: $a$2

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

Operations performed on data in Spreadsheet are:

Addition , Subtraction, Multiplication , Division, Comparison, Concatenation etc.

Addition: It perform addition of two or more than two numbers. Exp: C1 + D1

Subtraction: It performs subtraction of two numbers. Exp: C1 – D1

Question 9: How do formulae work in a spreadsheet?

Answer: Any expressions that begins with an equals ‘=’ is treated as formula. In the expression, the ‘=’ followed by values, cell address and functions are called as formula.

Example : A1+ B1

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

Answer: Yes

Question 11: How to make visible the desired toolbar a spreadsheet?

Answer: Steps to make visible the desired toolbar is

Select View–> Toolbar–> Required Toolbar Name.

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

Answer: The syntax and example of any three mathematical functions in spreadsheet are as follows:

SUM: This is a function which is used to add all the values within a range of cells.

Syntax:-SUM(Number1, Number2)

Example: Sum(3,6) Result: 9

Sqrt(Number): This function is used to find the square of a given number.

Syntax: Sqrt(Number)

Example: Sqrt(2) Result: 4

Power: This function is used to find the Power of a given number.

Syntax: Power(Base, Exponent)

Example Power(3 :2) Result: 9.

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

Answer:

Average: Returns the average of its arguments.

Syntax: Average(Number1, Number2…).

Example: Average(2,4,9)

Result : 5

Count: Counts how many numbers are in the list of arguments.

Syntax: Count(Number1, Number2…).

Example: Count(2,4,7) Result: 3.

MAX(): Return the maximum number from the given numbers.

Syntax: MAX(Number1, Number2…)

Example: MAX(5; 2; 6)

Result: 6

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

Answer: IF:

Syntax: IF(test, Then Value, Otherwise Value )

Example: IF(4<7 “Hello” “Bye”)

Result: Hello

SUMIF(): Sum the value of sum_range if criteria meet the criteria range value.

Syntax:- SUMIF(range criteria; Sum range)

Example: SUMIF(A2: A6;”>10″;A2:A6) Result=15

COUNTIF(): Count the value if values meets the criteria.

Syntax:- COUNTIF(range; Criteria)

Example: COUNTIF(A2:A6;”>8″) Result=2

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

Answer: NOW: The NOW function returns the serial number of the current date and time.

Syntax: NOW()

Example: NOW() Result: (Current date and time)

TODAY: The TODAY function returns the current date of the computer.

Syntax: TODAY() 

Example: TODAY() Result: (Current Date)

TIME: The TIME function returns the decimal number for a particular time.

Syntax: TIME (hour, minute, second)

Example

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

Answer: AND: Returns TRUE if all its arguments are TRUE.

Syntax: AND(Logical Value1, Logical Value2..)

Example: AND(3<4, 6>4)

Result: True

NOT: Reverses the logic of its argument.

Syntax: NOT(Logical Value)

Example: NOT(4>6)

Result: True

OR: Returns TRUE if any argument is TRUE.

Syntax: OR(Logical Value1 , Logical Value 2..)

Example: OR(4>3, 3>7)

Result: TRUE

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

Answer:

LEN: Returns the length of the text/String.

Syntax: LEN(Text)

Example: LEN(Excel)

Result: 5

LOWER: Convert the text into Lower Case.

Syntax: LOWER(Text)

Example: LOWER(EXCEL)

Result: excel

LEFT: Return the specified number of characters from left side.

Syntax: LEFT(Text)

Example: LEFT(“EXCEL”, 2)

Result: EX

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

Answer:

There are certain advantages of using graphs or charts:

1) It makes the data more presentable and easy to understand.

2) It helps in summarizing a very large data in a very crisp and easy manner.

3) It helps in better comparison of data

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

Answer: Column Chart: A column chart in Excel is a chart that is used to represent data in vertical columns. The height of the column represents the value for the specific data series in a chart.

Line Chart: A line Chart shows values as points on the Y axis. The X axis shows categories.

Pie Chart: A pie chart is a circle-shaped chart capable of representing only one series of data. The length of the arc, or the area of each sector is proportional to its value.

Bar Chart: Data that is arranged in columns or rows on a worksheet can be plotted in a bar chart. Bar charts illustrate comparisons among individual items.

Scatter Chart: Data that is arranged in columns and rows on a worksheet can be plotted in an XY (scatter) chart. Scatter charts show the relationships among the numeric values in several data series or plots two groups of numbers as one series of XY coordinates.

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

Answer: Steps to insert a chart in Calc:

1. Select the range of data.
2. Click on Insert Menu–> Chart
3. Select the type of Chart and Finish.

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

Answer:

1.Chart Area: Chart area includes all the area and objects in the chart.

2. Plot Area: Plot area is a window within the Chart area. It contains the actual chart itself, and includes plotted data, data series, category, and value axis.

3.Legend: It depicts the colours, patterns or symbols assigned to the data series. It helps to differentiate the data.

4.Chart Title: It describes the aim and contents of the chart.

5. Category Axis — Category axis or X-axis is the horizontal axis of a chart.