Ans:- It is the spreadsheet application of LibreOffice Suite.
Ans:- .ods (Open Document Spreadsheet)
Ans:- A file containing one or more worksheets.
Ans:- A single sheet within a workbook that contains cells for data.
Ans:- The intersection of a row and a column.
Ans:- The currently selected cell where data can be entered.
Ans:- Using letters (A, B, C, ...).
Ans:- Using numbers (1, 2, 3, ...).
Ans:- A1
Ans:- It displays the address of the active cell.
Ans:- It displays the contents or formula of the selected cell.
Ans:- B3
Ans:- 1
Ans:- 1024 columns
Ans:- 1,048,576 rows
Ans:- A group of adjacent cells.
Ans:- = (equals sign)
Ans:- An expression that performs calculations using cell values.
Ans:- A predefined formula that performs a specific calculation.
Ans:- Adds a range of numbers.
Ans:- =SUM(A1:A5)
Ans:- Calculates the average of a range of numbers
Ans:- =AVERAGE(B1:B10)
Ans:- Finds the largest number in a range.
Ans:- Finds the smallest number in a range.
Ans:- Counts the number of numeric cells in a range.
Ans:- Counts all non-empty cells in a range.
Ans:- To perform conditional calculations.
Ans:- =IF(A1>50,"Pass","Fail")
Ans:- Joins two or more text strings
Ans:- *
Ans:- /
Ans:- +
Ans:- -
Ans:- ^
Ans:- Ctrl + N
Ans:- Ctrl + O
Ans:- Ctrl + S
Ans:- Ctrl + P
Ans:- Ctrl + X
Ans:- Ctrl + C
Ans:- Ctrl + V
Ans:- Ctrl + Z
Ans:- Ctrl + Y
Ans:- Ctrl + A
Ans:- Ctrl + F
Ans:- Ctrl + H
Ans:- Ctrl + + (plus sign)
Ans:- Ctrl + - (minus sign)
Ans:- Shift + F11
Ans:- Right-click sheet tab → Delete Sheet
Ans:- Left-aligned
Ans:- Right-aligned
Ans:- Referring to a cell in a formula using its address
Ans:- Relative, Absolute, and Mixed.
Ans:- A reference that changes when copied (e.g., A1).
Ans:- A reference that doesn’t change (e.g., $A$1).
Ans:- A reference where either row or column is fixed (e.g., $A1 or A$1).
Ans:- F11 or Insert → Chart
Ans:- To visually represent data.
Ans:- Bar Chart, Pie Chart
Ans:- A tool that automatically sums selected cells.
Ans:- Alt + =
Ans:- To arrange data in ascending or descending order.
Ans:- To display only specific data based on criteria.
Ans:- Automatically changing cell appearance based on conditions.
Ans:- Format → Conditional Formatting
Ans:- To keep rows or columns visible while scrolling.
Ans:- View → Freeze Rows and Columns
Ans:- #NAME?, #REF!, #DIV/0!, etc.
Ans:- Division by zero error.
Ans:- A note added to a cell
Ans:- Restricting input to specific values in a cell.
Ans:- Format → Merge Cells
Ans:- To customize font, number format, borders, and alignment
Ans:- Ctrl + 1
Ans:- Automatically fills cells with a sequence of data
Ans:- To find input value for a desired formula result
Ans:- A tool for summarizing and analyzing data
Ans:- Ctrl + + (plus sign)
Ans:- Ctrl + - (minus sign)
Ans:- Prevents users from editing protected cells.
Ans:- Ctrl + F2
Ans:- Splits text from one column into multiple columns
Ans:- Ctrl + H
Ans:- Helps trace and debug formulas.
Ans:- Shift + Ctrl + F9
Ans:- Divides the window into multiple panes for viewing.
Ans:- Right-click on sheet tab → Rename Sheet
Ans:- Ctrl + Page Down
Ans:- What is the shortcut key to move to the previous sheet
Ans:- Ctrl + Mouse Scroll