PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)
Chapter-2 Apply formula and functions in spreadsheet
1.In LibreOffice Calc, text entered into a cell is called a ________.
Answer: Label
2.The result of a mathematical calculation in a cell is displayed as a ________.
Answer: Value
3.A formula in LibreOffice Calc always starts with the ________ symbol.
Answer: =
4.The ________ function is used to find the highest value in a range of cells.
Answer: MAX
5.To count the number of cells in a range that contain numbers, you use the ________ function.
Answer: COUNT
2. True or False:
1.A formula can only perform addition in LibreOffice Calc.
Answer: False
2.Formulas include references and mathematical operators.
Answer: True
3.Labels are always aligned to the left side of the cell by default.
Answer: True
4.The AVERAGE function calculates the total of values in a range divided by the number of cells.
Answer: True
5.The MIN function calculates the total of a range of cells.
Answer: False
3. Multiple Choice Questions:
1.A formula in LibreOffice Calc must begin with which symbol?
Answer: =
2.What is the purpose of the MIN function?
Answer: To find the smallest value
3.Which of the following is an example of a label?
Answer: Name
4.If a cell contains =A1+B1, this is an example of:
Answer: A formula
5.Which function is used to calculate the total of a range of cells?
Answer: SUM
4. Short Answer Questions.
1.Name the different types of data
Answer: There are mainly three types of data in a spreadsheet: Labels, Values, and Formulas. Labels are text entries that cannot be used for calculations, Values are numeric data that can be used in calculations, and Formulas are expressions that perform operations on values or other cells.
2.Define the term formula
Answer: A formula is an expression entered into a cell to perform calculations automatically. It always starts with the equal (=) symbol and may include cell references, numbers, and mathematical operators such as +, –, *, /. For example, =A1+B1 adds the values of cells A1 and B1.
3.Define a range of cells
Answer: A range of cells is a group of two or more adjacent cells selected together. It can be used for applying functions or formulas. For example, B1:C5 is a range that includes all cells from B1 to C5.
4.Write the syntax to total values in a range
Answer: To calculate the total of a group of cells, we use the SUM function. The syntax is =SUM(start cell:end cell). For example, =SUM(B1:B5) will add all the values in cells B1, B2, B3, B4, and B5.
5.How will you insert a column before any column
Answer: To insert a column before a specific column in a spreadsheet, select the column where you want to insert, right-click on it, and choose Insert Columns Before from the context menu. This will shift the existing column to the right and insert a new blank column.
5. Long Answer Questions.
1.Differentiate between labels and values
Answer: Labels are text entries in a spreadsheet, such as names or descriptions. They are used for identification or information purposes and cannot be used in calculations. Values, on the other hand, are numeric entries that represent quantities or amounts. Values can be used in mathematical operations and formulas. For example, "Price" is a label, whereas "100" is a value. Labels help organize data, while values are essential for computations.
2.Explain how mathematical operators are used in formulas
Answer: Mathematical operators are symbols used to perform calculations within formulas. Common operators include + (addition), – (subtraction), * (multiplication), / (division), and ^ (exponentiation). They are used along with cell references or numbers to calculate results automatically. For example, =A1*B1 multiplies the value in cell A1 by the value in B1. Using these operators correctly allows spreadsheets to perform complex calculations efficiently.
3.Explain the meaning of the formula =SUM(B1:C2)
Answer: The formula =SUM(B1:C2) calculates the total of all numeric values within the range from cell B1 to C2. It includes all cells in the rectangle formed by B1, B2, C1, and C2. For example, if B1=10, B2=5, C1=15, and C2=20, then =SUM(B1:C2) will give 10+5+15+20=50. This formula is useful to quickly find the sum of multiple rows and columns of data without adding each cell manually.
4.Explain the use of the COUNT function
Answer: The COUNT function in spreadsheets is used to count only the cells that contain numeric values within a specified range. It ignores empty cells, text, or logical values like TRUE/FALSE. For example, COUNT(B1:B5) will count how many cells contain numbers in the range B1 to B5. This function is helpful for determining the number of entries that can be included in calculations such as averages or totals.
SOME OTHER LINKS YOU MAY LIKE:
No comments:
Post a Comment