✨ A. 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
Answer: (d) Data validation
Because data validation is used to restrict input to specific data types (like date, number, text).
2. Which of the following options when selected deletes all data validation?
(a) Delete formatting
(b) Delete all
(c) Delete formula
(d) Delete me
Answer: (b) Delete all
This option removes all data validations applied to selected cells.
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
Answer: (a) Find and replace
Because this tool allows both locating and replacing text across the sheet.
4. What is the name of mechanism to arrange the data in a particular order?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating
Answer: (a) Sorting
Sorting arranges data either in ascending or descending order.
5. What is the name of mechanism to filter out unnecessary data?
(a) Sorting
(b) Searching
(c) Filtering
(d) Validating
Answer: (c) Filtering
Filtering hides unwanted rows and shows only relevant ones based on conditions.
6. Which of the following type of package does Calc refer to?
(a) Spreadsheet
(b) Double sheet
(c) Multi-sheet
(d) Cannot determine
Answer: (a) Spreadsheet
Calc is a spreadsheet software like Microsoft Excel.
7. Which of the following is an extension of a worksheet created in Calc?
(a) .ods
(b) .odd
(c) .xls
(d) .obj
Answer: (a) .ods
LibreOffice Calc files are saved with .ods extension.
8. How can one calculate the total of values entered in a worksheet column?
(a) By manual entry
(b) By auto-sum
(c) By formula
(d) By sum function
Answer: (d) By sum function
The SUM() function is specifically used for addition.
9. If we move a cell containing a formula having reference to another cell, 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 changes at destination.
(c) The cell columns are changed at destination.
(d) No change will occur.
Answer: (a) The cell row and columns are changed at destination
Relative references move according to new cell position.
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
Answer: (c) Both (a) and (b)
Functions can be written manually or inserted using the function wizard.
11. A function should start with __________________.
(a) ‘=’ sign
(b) alphabets
(c) numbers
(d) All of these
Answer: (a) ‘=’ sign
All formulas and functions in spreadsheets must begin with the equal 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
Answer: (c) File → Print
Charts are printed using the print option, not during insertion.
13. How many axes does charts in Calc have?
(a) Two
(b) Three
(c) Two or three
(d) Four
Answer: (c) Two or three
Charts usually have two axes (X and Y), but 3D charts can have three.
14. The chart preview can be seen in________________.
(a) Page preview
(b) Chart preview
(c) Export chart
(d) All of these
Answer: (a) Page preview
Page preview lets you view how the chart will appear when printed.
✨ B. 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 ____________.
Answer: Autofill
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, it will change to ____________.
Answer: =D2+E3
6. The cell address formed by the intersection of the ninth column and the eighth row is ____________.
Answer: I8
7. $A1$B2 is an example of ____________.
Answer: invalid referencing / incorrect reference
8. Numbers entered into a cell are automatically __________ aligned.
Answer: right
9. If A1:A5 contain 16,10,3,25,6 then =Average(A1:A5;60) will display ____________.
Answer: 20
10. In __________ referencing, the reference changes rows and columns automatically when it is copied.
Answer: relative
✨ C. True or False — Question + Answer
1. A cell is a combination of row and column.
True
2. A spreadsheet is also called as worksheet.
False
3. There are ‘n’ number of sheets in a spreadsheet.
True
4. In a spreadsheet, we can change the column width and row height.
True
5. $A1$B2 is an example of mixed referencing.
False
✨ D. Solve the following
1. A1=10, B1=5. Formula: =A1+B1*2^3
Compute: 2^3=8 → 5*8=40 → 40+10=50
Answer: 50
2. Values: A1=5, B1=-25, C1=30, D1=-35. Formula =MIN(A1:D1)
Minimum value = -35
Answer: –35
3. D5 contains =$B$5 + C5. Copied to E5.
= $B$5 + D5
Answer: =$B$5 + D5
4. D5 contains =$B5 + C5. Copied to E5.
= $B5 + D5
Answer: =$B5 + D5
5. D5 contains =$B5 + C$5. Copied to E6.
= $B6 + C$5
Answer: =$B6 + C$5
✨ E. Short Answer Questions (11–21)
11. How to make visible the desired toolbar in a spreadsheet?
From the menu go to View → Toolbars and then click on the toolbar you want to make visible. A checkmark appears next to visible toolbars.
Q12. Give the syntax and example of any three mathematical functions in spreadsheet.
Mathematical functions help perform arithmetic operations quickly in a spreadsheet.
1. SUM()
- Purpose: Adds multiple values together.
- Syntax: =SUM(range)
- Example: =SUM(A1:A5)
This adds all values from A1 to A5.
2. PRODUCT()
- Purpose: Multiplies values.
- Syntax: =PRODUCT(range)
- Example: =PRODUCT(B1:B3)
This multiplies values in B1, B2, and B3.
3. ROUND()
- Purpose: Rounds a number to a specific number of decimal places.
- Syntax: =ROUND(number, decimal_places)
- Example: =ROUND(C2,2)
This rounds the value in C2 to 2 decimal places.
Q13. Give the syntax and example of any three statistical functions in spreadsheet.
Statistical functions help analyze data sets.
1. AVERAGE()
- Purpose: Calculates the mean of values.
- Syntax: =AVERAGE(range)
- Example: =AVERAGE(A1:A10)
This finds the average of 10 numbers.
2. MIN()
- Purpose: Finds the smallest number.
- Syntax: =MIN(range)
- Example: =MIN(B1:B8)
This returns the smallest value from B1 to B8.
3. MAX()
- Purpose: Finds the largest number.
- Syntax: =MAX(range)
- Example: =MAX(C1:C8)
This returns the largest value from C1 to C8.
Q14. Give the syntax and example of any three decision-making functions in spreadsheet.
Decision-making functions return results based on logical tests.
1. IF()
- Purpose: Checks a condition, returns one value if true, another if false.
- Syntax: =IF(condition, value_if_true, value_if_false)
- Example: =IF(A1>50,”Pass”,”Fail”)
2. COUNTIF()
- Purpose: Counts how many cells match a condition.
- Syntax: =COUNTIF(range, condition)
- Example: =COUNTIF(B1:B10,”>100″)
3. SUMIF()
- Purpose: Adds only those values that meet a condition.
- Syntax: =SUMIF(range, condition)
- Example: =SUMIF(C1:C10,”<0″)
This adds all negative numbers in C1 to C10.
Q15. Give the syntax and example of any three date and time functions in spreadsheet.
These functions help in working with calendar dates and time.
1. TODAY()
- Purpose: Gives the current system date.
- Syntax: =TODAY()
2. NOW()
- Purpose: Returns current date and time.
- Syntax: =NOW()
3. DAY()
- Purpose: Extracts the day number from a date.
- Syntax: =DAY(cell)
- Example: If A1 = 21-03-2025,
=DAY(A1) returns 21.
Q16. Give the syntax and example of any three logical functions in spreadsheet.
Logical functions return TRUE or FALSE or evaluate conditions.
1. AND()
- Purpose: Returns TRUE only if all conditions are TRUE.
- Syntax: =AND(condition1, condition2)
- Example: =AND(A1>5, B1<10)
2. OR()
- Purpose: Returns TRUE if any condition is TRUE.
- Syntax: =OR(condition1, condition2)
- Example: =OR(C1=”Yes”, C1=”Y”)
3. NOT()
- Purpose: Reverses the logical value.
- Syntax: =NOT(condition)
- Example: =NOT(D1>0)
If D1 > 0 is TRUE, NOT makes it FALSE.
Q17. Give the syntax and example of any three string functions in spreadsheet.
String functions work with text data.
1. LEN()
- Purpose: Counts how many characters are in a string.
- Syntax: =LEN(text)
- Example: =LEN(“Hello”)
Returns 5.
2. LOWER()
- Purpose: Converts text to lowercase.
- Syntax: =LOWER(text)
- Example: =LOWER(“WELCOME”)
Returns “welcome”.
3. CONCATENATE()
- Purpose: Joins two or more strings.
- Syntax: =CONCATENATE(text1, text2,…)
- Example: =CONCATENATE(A1,” “,B1)
If A1=”Rita” and B1=”Sharma”
Output: “Rita Sharma”
18. Explain the advantages of drawing a chart in Calc.
- Makes data more understandable visually
- Helps in quick analysis and comparison
- Summarises large data in graphic form
- Helps in presentations and reports
19. Explain in one line each the various types of charts.
- Column Chart – Used for comparing data between different categories; values are shown as vertical bars.
Example: Comparing marks of students across subjects. - Bar Chart – Similar to column chart but shows values as horizontal bars; useful when category names are long.
Example: Comparing sales figures of different products. - Line Chart – Shows data trends over time using connected lines; best for observing changes.
Example: Temperature variation over a week. - Pie Chart – Displays data as proportional slices of a circle, showing how each part contributes to the whole.
Example: Percentage distribution of expenses in a family budget. - XY (Scatter) Chart – Plots pairs of numerical data to observe relationships and patterns between two variables.
Example: Relationship between speed and braking distance.
20. Write the steps to insert a chart in Calc.
- Select the data
- Go to Insert → Chart
- Choose chart type
- Click Finish
21. Name and explain any five components of a chart in a spreadsheet package.
- Title: Name of the chart
- X-Axis: Horizontal axis
- Y-Axis: Vertical axis
- Legend: Tells what each color or symbol means
- Data Series: The actual plotted data