LibreOffice Calc is a free spreadsheet program similar to Microsoft Excel. It helps you create, edit, and organize data in rows and columns. You can perform calculations, make charts, and manage budgets easily. It’s great for tasks like creating lists, financial planning, or analyzing data. LibreOffice Calc is user-friendly and suitable for various personal and professional tasks, making it a versatile tool for handling numbers and information.
Table of Contents
Solution for Multiple Choice Questions
- Which of the following technique can be used to allow only date value in cell? Answer: (d) Data validation
- Which of the following options when selected deletes all data validation? Answer: (a) Delete formatting
- We can replace multiple occurrences of a word using which of the following facilities of Calc? Answer: (a) Find and replace
- What is the name of mechanism to arrange the data in a particular order? Answer: (a) Sorting
- What is the name of mechanism to filter out unnecessary data? Answer: (c) Filtering
- Which of the following type of package does Calc refer to? Answer: (a) Spreadsheet
- Which of the following is an extension of a worksheet created in Calc? Answer: (a) .ods
- How can one calculate the total of values entered in a worksheet column of? Answer: (d) By sum function
- 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? Answer: (a) The cell row and columns are changed at destination.
- What is the correct way to enter a function in Calc? Answer: (c) Both (a) and (b)
- A function should start with__________________. Answer: (a) ‘=’ sign
- Which of the following option is used to print a chart? Answer: (c) File → Print
- How many axes does charts in Calc have? Answer: (c) Two or three
- The chart preview can be seen in________________. Answer: (a) Page preview
Solution for Fill in the blanks
- The column immediately next to column “Z” is _____________. Answer: AA
- The default extension of a workbook created using a LibreOffice Calc spreadsheet is _____________. Answer: .ods
- The spreadsheet feature used to continue the series is called as _________________. Answer: Fill Series or AutoFill
- The formula “=MIN(C1:C5)” stored in cell C6 when copied to cell D6 changes to ______________. Answer: =MIN(D1:D5)
- The formula in cell A2 is =B2+C3. On copying this formula to cell C2, C2 will change to _____________. Answer: =D2+E3
- The cell address of the cell formed by the intersection of the ninth column and the eighth row will be _____________. Answer: I8
- Numbers entered into a cell are automatically ___________ aligned. Answer: Right
- If A1:A5 contain the numbers 16, 10, 3, 25 and 6 then =Average(A1:A5;60) will display______________. Answer: 24 (The numbers average to 60/6 = 10, then (16+10+3+25+6+60)/6 = 120/5 = 24)
- 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
- A cell is a combination of row and column. Answer: True
- A spreadsheet is also called as worksheet. Answer: False (Note: While the terms can sometimes be used interchangeably, a spreadsheet refers to the entire document, which can contain multiple worksheets.)
- There are ‘n’ number of sheets in a spreadsheet. Answer: True (This statement is ambiguously true. While by default there might be a set number of sheets, the number of sheets ‘n’ in a spreadsheet can vary based on user requirements.)
- In a spreadsheet, we can change the column width and row height. Answer: True
Solve the following in a Spreadsheet
1. Cell A1 contains the number 10 and B1 contains 5. What will be the contents of cell C1, if the formula =A1+B1*2^3 is entered in cell C1?
Question: =A1+B1*2^3 Answer: Given that A1 = 10 and B1 = 5:
The formula evaluates to:
= 10 + 5 * (2^3)
= 10 + 5 * 8
= 10 + 40
= 50
2. The contents of Cell A1, B1, C1, and D1 are 5, –25, 30, and –35, respectively. What will be the value displayed in cell E1 which contains the formula =MIN(A1:D1).
Question: =MIN(A1:D1)
Answer: Given the contents of cells A1 through D1, the smallest value is -35.
So, E1 will display:
= -35
3. Cell D5 contains the formula =$B$5+C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?
Question: =$B$5+C5 copied to E5 Answer: Since $B$5 is an absolute reference, it doesn’t change when copied. The C5 is relative and will change its column reference when moved to column E.
The formula in E5 will be:
= $B$5+D5
4. Cell D5 contains the formula =$B5 + C5 and this formula is copied to cell E5, what will be the copied formula in cell E5?
Question: =$B5 + C5 copied to E5 Answer: Here $B5 has an absolute column reference and a relative row reference, so the column remains the same but the row can change when copied. The C5 is fully relative.
The formula in E5 will be:
= $B5+D5
5. Cell D5 contains the formula =$B5 + C$5 and this formula is copied to cell E6, what will be the copied formula in cell E6?
Question: =$B5 + C$5 copied to E6 Answer: $B5 has an absolute column and a relative row reference. C$5 has a relative column and an absolute row reference.
The formula in E6 will be:
= $B6+D$5
Short answer questions (50 words)
What do you call the document created in a spreadsheet application?
Answer: In a spreadsheet application like LibreOffice Calc, the document created is called a “spreadsheet.”
What are the steps to create a new spreadsheet?
Answer: To create a new spreadsheet in Libreoffice Calc:
- Open LibreOffice Calc.
- Click on “File” in the menu.
- Select “New.”
- Choose “Spreadsheet.”
What is the difference between spreadsheet, worksheet, and sheet?
Answer: A “spreadsheet” is the entire document, containing one or more “sheets” or “worksheets.” Each “worksheet” or “sheet” is an individual page within the spreadsheet.
What is the default name of the worksheet in Libreoffice Calc? How can it be renamed?
Answer: The default name of a worksheet in Calc is “Sheet1.” To rename it: Right-click the sheet tab, select “Rename,” enter the new name, and press “OK.”
Write the steps to insert and delete the worksheet in Libreoffice Calc.
Answer: To insert: Click on the ‘+’ icon near the sheet tabs. To delete: Right-click on the sheet tab, and select “Delete.”
What is an active cell? How to delete the contents of an active cell?
Answer: An “active cell” is the currently selected cell. To delete its contents, select the cell and press the “Delete” key.
What is relative and absolute cell address in the spreadsheet?
Answer: A “relative” address changes when copied (like A1). An “absolute” address stays fixed using dollar signs (like $A$1).
Explain any two operations performed on data in a spreadsheet.
Answer: Two operations are “sorting,” which arranges data in a specific order, and “filtering,” which displays only specific data based on criteria.
How do formulae work in a spreadsheet?
Answer: Formulae perform calculations using data in cells. They begin with an “=” sign and use cell references and functions for computation.
Can you include more than one mathematical operators in a formula?
Answer: Yes, multiple mathematical operators like +, -, *, / can be used in one formula. Proper order of operations will be followed.
How to make visible the desired toolbar in a spreadsheet?
Answer: Go to “View” in the menu, hover over “Toolbars,” and select the desired toolbar to make it visible or hidden.
Give the syntax and example of any three mathematical functions in a spreadsheet.
Answer:
- SUM: Adds numbers. Syntax:
=SUM(A1:A3) - AVERAGE: Finds the mean. Syntax:
=AVERAGE(A1:A3) - PRODUCT: Multiplies numbers. Syntax:
=PRODUCT(A1:A3)
Give the syntax and example of any three statistical functions in a spreadsheet.
Answer:
- MAX: Returns largest value. Syntax:
=MAX(A1:A3) - MIN: Returns smallest value. Syntax:
=MIN(A1:A3) - STDEV: Estimates standard deviation. Syntax:
=STDEV(A1:A3)
Give the syntax and example of any three decision-making functions in a spreadsheet.
Answer:
- IF: Checks a condition. Syntax:
=IF(A1>10, "Yes", "No") - VLOOKUP: Searches a value. Syntax:
=VLOOKUP(A1, B1:C3, 2, FALSE) - HLOOKUP: Searches horizontally. Syntax:
=HLOOKUP(A1, B1:C3, 2, FALSE)
Give the syntax and example of any three date and time functions in a spreadsheet.
Answer:
- TODAY: Returns today’s date. Syntax:
=TODAY() - NOW: Returns current date and time. Syntax:
=NOW() - DATE: Creates a date. Syntax:
=DATE(2023, 9, 13)
Give the syntax and example of any three logical functions in a spreadsheet.
Answer:
- AND: Checks if all conditions are TRUE. Syntax:
=AND(A1>5, B1<10) - OR: Checks if any condition is TRUE. Syntax:
=OR(A1>5, B1<10) - NOT: Reverses a logical value. Syntax:
=NOT(A1=5)
Give the syntax and example of any three string functions in a spreadsheet.
Answer:
- UPPER: Converts to uppercase. Syntax:
=UPPER("hello") - CONCAT: Combines strings. Syntax:
=CONCAT(A1, A2) - LEFT: Extracts characters from the left. Syntax:
=LEFT("hello", 3)
Explain the advantages of drawing a chart in Libreoffice Calc.
Answer: Drawing a chart in Calc visually represents data, making trends and patterns clearer, aids in decision-making, and presents information engagingly.
Explain in one line each the various types of charts.
Answer:
- Bar: Displays horizontal bars of varying lengths.
- Column: Uses vertical bars to compare items.
- Line: Shows trends over time.
- Pie: Represents data in a circular format.
Write the steps to insert a chart in Libreoffice Calc.
Answer: Select the data, click on the “Chart” icon, follow the Chart Wizard’s prompts, customize as needed, and click “Finish.”
Name and explain any five components of a chart in a spreadsheet package.
Answer:
- Title: Describes the chart’s main idea.
- Axis Labels: Names for X and Y axes.
- Data Series: Represents the values being charted.
- Legend: Identifies each data series using colors or patterns.
- Gridlines: Helps read values by connecting data points to the axis.
Introduction to IT – ITeS Industry, Class 9, Solved, Unit 1
Data Entry and Keyboarding Skills: A Comprehensive Solution for Class 9 IT, CBSE, Unit 2
LibreOffice Writer | Digital Documentation Class IX IT Solution Unit 3
LibreOffice Impress | Digital Presentations Class IX IT Exercise Solution Unit 5