Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01

Computer Science Objective Questions and Answers: LibreOffice Calc Spreadsheet

Review structured MCQ sets for Computer Science LibreOffice Calc Spreadsheet. Built according to official NCERT guidelines, these downloadable questions support daily revision and core concept reinforcement.

Download LibreOffice Calc Spreadsheet MCQs with Answers

Access the complete set of multiple-choice questions for LibreOffice Calc Spreadsheet below. This focused format allows students to isolate specific topics for thorough review and uninterrupted practice alongside official NCERT textbooks.

Practice 41 multiple choice questions with answers on spreadsheet basics in this computer course chapter on LibreOffice Calc. They cover cells, ranges, workbooks and worksheets, cell references, functions, sorting and filtering, charts and shortcut keys.

Question 1: Calc is a
(a) graphic program
(b) word processor
(c) spreadsheet
(d) None of the above
Show Answer & Explanation

Answer: (c) spreadsheet

Explanation:
1. LibreOffice Calc is the spreadsheet program of the LibreOffice suite.
2. It stores data in rows and columns and calculates with formulas, unlike a drawing or text program.

Teacher's Note:
1. Calc is the spreadsheet, Writer the word processor and Impress the presentation program.

Question 2: Which one of the following is a spreadsheet software?
(a) Visi Calc
(b) Lotus 1-2-3
(c) Multiplan
(d) All of these
Show Answer & Explanation

Answer: (d) All of these

Explanation:
1. VisiCalc, Lotus 1-2-3 and Multiplan are all early spreadsheet programs.
2. Since each option is a spreadsheet package, All of these is correct.

Teacher's Note:
1. VisiCalc (1979) is regarded as the first spreadsheet program.

Question 3: The intersection of row and column forms a
(a) square
(b) cell
(c) oval
(d) worksheet
Show Answer & Explanation

Answer: (b) cell

Explanation:
1. A cell is the box where a row and a column meet.
2. A worksheet is the whole grid, not one intersection.

Teacher's Note:
1. Cell address = column letter + row number, for example B3.

Question 4: The default file extension of Calc Work book is
(a) .xlr
(b) .exe
(c) .exl
(d) .ods
Show Answer & Explanation

Answer: (d) .ods

Explanation:
1. Calc saves workbooks in the OpenDocument Spreadsheet format, with extension .ods.
2. The .exe extension belongs to programs, and .xlr and .exl are not Calc formats.

Teacher's Note:
1. ODS = OpenDocument Spreadsheet; Writer uses .odt and Impress uses .odp.

Question 5: New, Open, Save etc are the commands of ............ in LibreOffice Calc.
(a) File
(b) Review
(c) Insert
(d) View
Show Answer & Explanation

Answer: (a) File

Explanation:
1. The File menu holds the commands for creating, opening, saving and printing documents.
2. Insert and View deal with adding content and changing the display.

Teacher's Note:
1. File menu = New, Open, Save, Save As, Print, Exit.

Question 6: In Calc, the contents of the active cell are displayed in the
(a) footer bar
(b) tool bar
(c) task bar
(d) formula bar
Show Answer & Explanation

Answer: (d) formula bar

Explanation:
1. The formula bar (input line) shows the data or formula of the selected cell.
2. The tool bar holds buttons and the task bar belongs to the operating system.

Teacher's Note:
1. Look at the formula bar to see the real formula behind a calculated value.

Question 7: Calc documents are stored as files called
(a) workforce
(b) worksheets
(c) worktables
(d) workgroups
Show Answer & Explanation

Answer: (b) worksheets

Explanation:
1. A Calc document is a workbook, and what it holds is a set of worksheets.
2. Workforce, worktables and workgroups are not spreadsheet terms, so worksheets is the only sensible choice.

Teacher's Note:
1. File = workbook, pages inside it = worksheets.

Question 8: Workbook is a collection of
(a) page setup
(b) buttons
(c) diagrams
(d) worksheets
Show Answer & Explanation

Answer: (d) worksheets

Explanation:
1. A workbook is a Calc file that contains one or more worksheets.
2. Buttons, diagrams and page setup are items used within a sheet, not what a workbook is made of.

Teacher's Note:
1. Workbook contains worksheets, just as a book contains pages.

Question 9: In order to move from one worksheet to another in LibreOffice Calc workbook, one should click
(a) Active Cell
(b) Scroll bar
(c) Sheet tab
(d) Tab button
Show Answer & Explanation

Answer: (c) Sheet tab

Explanation:
1. Sheet tabs at the bottom of the window name every worksheet; clicking one opens that sheet.
2. The scroll bar only moves the view inside the current sheet.

Teacher's Note:
1. Sheet1, Sheet2, Sheet3 tabs sit at the bottom-left.

Question 10: ............ appears at the bottom of the Calc window.
(a) Status bar
(b) Name box
(c) Formula bar
(d) Title bar
Show Answer & Explanation

Answer: (a) Status bar

Explanation:
1. The status bar runs along the bottom and shows sheet number, zoom and similar information.
2. The name box and formula bar are above the grid and the title bar is at the top.

Teacher's Note:
1. Top: title bar.
2. Bottom: status bar.

Question 11: ............tab is used to insert Media picture, etc.
(a) File
(b) Edit
(c) Insert
(d) View
Show Answer & Explanation

Answer: (c) Insert

Explanation:
1. Pictures, media, charts and other objects are added from the Insert menu.
2. File, Edit and View do not add new objects.

Teacher's Note:
1. Whatever you add to a sheet comes from Insert.

Question 12: A worksheet range refers to
(a) a command used for date modeling
(b) a range of values such as from 23 to 234
(c) a group of cells
(d) a group of worksheets
Show Answer & Explanation

Answer: (c) a group of cells

Explanation:
1. A range is a block of one or more adjacent cells, such as A1:C5.
2. It is a selection of cells, not a command, a set of numbers or several sheets.

Teacher's Note:
1. Range = first cell : last cell.

Question 13: A cell range always has the ......... symbol between the cell references.
(a) ; (semicolon)
(b) .(Full stop)
(c) , (comma)
(d) : (colon)
Show Answer & Explanation

Answer: (d) : (colon)

Explanation:
1. A range is written with a colon between its first and last cell, as in A1:B5.
2. The semicolon is used to separate function arguments, and comma and full stop do not form ranges.

Teacher's Note:
1. Colon means 'from ... to ...'.

Question 14: A cell range starting from first row, first column to fourth row and fifth column can be represented as
(a) [A1 : E4]
(b) [A0 : E3]
(c) [E4 : A1]
(d) [E3 : A0]
Show Answer & Explanation

Answer: (a) [A1 : E4]

Explanation:
1. First row and first column is A1; fourth row and fifth column (E) is E4, so the range is A1:E4.
2. There is no row 0, which rules out A0, and the other options reverse or shift the cells.

Teacher's Note:
1. Column letter first, then row number: column 5 = E.

Question 15: Cell address A4 in a formula means it is a
(a) mixed cell reference
(b) absolute cell reference
(c) relative cell reference
(d) All of the above
Show Answer & Explanation

Answer: (c) relative cell reference

Explanation:
1. A reference with no dollar sign changes when the formula is copied, so it is relative.
2. Absolute needs dollar signs on both parts and mixed needs one of them.

Teacher's Note:
1. No dollar = relative.

Question 16: Cell address $A4 in a formula means it is a
(a) mixed cell reference
(b) absolute cell reference
(c) relative cell reference
(d) All of the above
Show Answer & Explanation

Answer: (a) mixed cell reference

Explanation:
1. The dollar sign fixes the column A but the row 4 can still change, so the reference is mixed.
2. It is not relative because of the dollar sign, and it is not absolute because that would need $A$4.

Teacher's Note:
1. One dollar = mixed, two dollars = absolute.

Question 17: Absolute cell referencing occurs when
(a) formula is dragged but the cell references do not adjust
(b) spreadsheet is saved with "absolute" as file name
(c) formula is dragged and the cell reference adjusts automatically
(d) $ symbol is automatically added with each cell reference
Show Answer & Explanation

Answer: (a) formula is dragged but the cell references do not adjust

Explanation:
1. An absolute reference stays fixed when the formula is copied or dragged.
2. Automatic adjustment describes a relative reference, and the dollar signs are typed by the user, not added automatically.

Teacher's Note:
1. Press F4 while editing to add the dollar signs.

Question 18: Under which tab, the Print Preview option is available for printing?
(a) Formulae
(b) Data
(c) File
(d) View
Show Answer & Explanation

Answer: (c) File

Explanation:
1. Page or print preview is offered in the File menu together with the Print command.
2. Formulae and Data do not hold printing options.

Teacher's Note:
1. Printing tasks all live in the File menu.

Question 19: Which of the following will you use as an option for saving a file?
(a) Save button on standard toolbar
(b) Save option from File menu
(c) Pressing Ctrl + S
(d) All of the above
Show Answer & Explanation

Answer: (d) All of the above

Explanation:
1. A file can be saved with the toolbar button, with File > Save, or with the Ctrl + S shortcut.
2. All three methods do the same job, so All of the above is right.

Teacher's Note:
1. Most commands have a menu, toolbar and shortcut route.

Question 20: Which of the following is not a valid data type in Calc?
(a) Number
(b) Text
(c) Character
(d) Date/ Time
Show Answer & Explanation

Answer: (c) Character

Explanation:
1. Calc cells hold numbers, text, and dates or times.
2. Character is a programming data type and is not a separate cell type in Calc.

Teacher's Note:
1. Cell data types: number, text, date/time.

Question 21: LibreOffice Calc stores dates internally as ....... .
(a) Date
(b) Text
(c) Number
(d) Date and time
Show Answer & Explanation

Answer: (c) Number

Explanation:
1. Calc keeps each date as a serial number counting days from a start date and only formats it as a date.
2. This is why dates can be added or subtracted like numbers.

Teacher's Note:
1. Change the cell format to Number to see the serial value.

Question 22: To select a single entire column, the easiest method is to
(a) double click any cell in the column
(b) drag from the top cell in the column to the last cell in the column
(c) click the column heading
(d) click the row heading
Show Answer & Explanation

Answer: (c) click the column heading

Explanation:
1. Clicking the column heading letter selects the whole column at once.
2. Dragging is slow and the row heading selects a row instead.

Teacher's Note:
1. Column heading = letter, row heading = number.

Question 23: The AutoFill feature
(a) Extends a sequential series of data
(b) automatically adds range of cell values
(c) applies a border around selected cells
(d) None of the above
Show Answer & Explanation

Answer: (a) Extends a sequential series of data

Explanation:
1. AutoFill continues a pattern such as 1, 2, 3 or Monday, Tuesday when the fill handle is dragged.
2. It does not add borders or total a range.

Teacher's Note:
1. Drag the small square at the cell corner.

Question 24: Sorting and filtering provides you to.........the worksheet data.
(a) Formatting
(b) Manipulate
(c) Increase
(d) Decrease
Show Answer & Explanation

Answer: (b) Manipulate

Explanation:
1. Sorting orders the data and filtering hides unwanted rows, so both help you manipulate the data.
2. They do not format it or change its amount.

Teacher's Note:
1. Sort = arrange, Filter = show only what matches.

Question 25: Which allows you display the specific data?
(a) Sorting
(b) Filtering
(c) Scenario
(d) Custom sorting
Show Answer & Explanation

Answer: (b) Filtering

Explanation:
1. A filter displays only the rows that meet a condition and hides the rest.
2. Sorting only changes the order of rows.

Teacher's Note:
1. Filter = display specific data.

Question 26: To combine the range of cells for various calculations ................ operators are used.
(a) Arithmetic
(b) Reference
(c) Comparison
(d) Text concatenation
Show Answer & Explanation

Answer: (b) Reference

Explanation:
1. Reference operators such as the colon join cells into ranges for a calculation.
2. Arithmetic, comparison and concatenation operators work on values, not on ranges.

Teacher's Note:
1. Reference operators: colon (range) and !
2. (sheet separator).

Question 27: In Calc this is a predefine formula that performs calculations using specific value in a particular order.
(a) Value
(b) Data series
(c) Function
(d) Field
Show Answer & Explanation

Answer: (c) Function

Explanation:
1. A function such as SUM or AVERAGE is a built-in formula that takes values and returns a result.
2. Values and fields are data, and a data series is a set of values for a chart.

Teacher's Note:
1. Function = ready-made formula.

Question 28: If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE (A1 : A5, 50) will display.
(a) 22. 167
(b) 27. 167
(c) 10
(d) 40
Show Answer & Explanation

Answer: (a) 22. 167

Explanation:
1. The numbers 20, 16, 5, 35, 7 and 50 total 133, and there are six values, so 133 / 6 = 22.167.
2. The extra number 50 is counted as a sixth value, so divide by 6 and not by 5.

Teacher's Note:
1. Average = sum divided by how many values, including the extra argument.

Question 29: If you type = 2 * (6 – 4) in cell A1, what value will be displayed?
(a) 2
(b) 4
(c) 6
(d) 8
Show Answer & Explanation

Answer: (b) 4

Explanation:
1. Brackets are evaluated first: 6 - 4 = 2, then 2 * 2 = 4.
2. The multiplication is applied after the bracket, not before.

Teacher's Note:
1. BODMAS: brackets first.

Question 30: =COUNT (4, 78, False, 18) will return ....
(a) 2
(b) 3
(c) 4
(d) 5
Show Answer & Explanation

Answer: (c) 4

Explanation:
1. COUNT counts numeric entries, and in Calc the logical value FALSE is stored as the number 0, so all four arguments are counted.
2. So the result is 4 and not 3.

Teacher's Note:
1. COUNT counts numbers, dates and logical values; COUNTA counts every non-empty cell.

Question 31: In Calc charts are created using which tab?
(a) Insert
(b) Format
(c) File
(d) Sheet
Show Answer & Explanation

Answer: (a) Insert

Explanation:
1. Charts are added from the Insert menu, which has a Chart option.
2. Format and Sheet do not create charts.

Teacher's Note:
1. Insert > Chart.

Question 32: A chart is created on the basis of values in
(a) Mail merge
(b) database
(c) spreadsheet
(d) document
Show Answer & Explanation

Answer: (c) spreadsheet

Explanation:
1. A chart plots the numbers held in the cells of a spreadsheet.
2. Mail merge and documents are not data sources for a Calc chart.

Teacher's Note:
1. Chart = picture of sheet data.

Question 33: Which of the following charts is used for comparing the changes in data over a period of time?
(a) Bar chart
(b) Area chart
(c) Scatter chart
(d) Line chart
Show Answer & Explanation

Answer: (d) Line chart

Explanation:
1. A line chart joins points in time order, so a rise or fall over time is easy to see.
2. Bar charts compare categories and scatter charts show the relation between two variables.

Teacher's Note:
1. Trend over time = line chart.

Question 34: Which of the following charts selects only one range of the data series?
(a) Line chart
(b) Pie chart
(c) Scatter chart
(d) Bar chart
Show Answer & Explanation

Answer: (b) Pie chart

Explanation:
1. A pie chart shows a single data series divided into slices.
2. Line, scatter and bar charts can plot several series together.

Teacher's Note:
1. Pie = one series, parts of a whole.

Question 35: The another name for the XY chart is
(a) Column chart
(b) Net chart
(c) Bar chart
(d) Scatter chart
Show Answer & Explanation

Answer: (d) Scatter chart

Explanation:
1. An XY chart plots points by x and y values and is also called a scatter chart.
2. Column and bar charts compare categories.

Teacher's Note:
1. XY = scatter.

Question 36: A chart placed in a worksheet is called
(a) formatting chart
(b) embedded chart
(c) aligning chart
(d) hanging chart
Show Answer & Explanation

Answer: (b) embedded chart

Explanation:
1. A chart that sits on the worksheet along with the data is an embedded chart.
2. The other names are not chart terms.

Teacher's Note:
1. Embedded = placed inside the sheet.

Question 37: Which of the following software used to create Pie chart?
(a) Browser software
(b) Database software
(c) Desktop publishing software
(d) Spreadsheet software
Show Answer & Explanation

Answer: (d) Spreadsheet software

Explanation:
1. Spreadsheet programs such as Calc have the chart tools to make pie charts.
2. Browsers, databases and DTP software are not meant for charting sheet data.

Teacher's Note:
1. Charts come with spreadsheets.

Question 38: You can place the chart legend in the chart at
(a) bottom
(b) corner
(c) top, right and left
(d) All of these
Show Answer & Explanation

Answer: (d) All of these

Explanation:
1. The legend can be positioned at the left, right, top or bottom of a chart.
2. Since the bottom, the top and both sides are possible, All of these is correct.

Teacher's Note:
1. Legend position is set in the chart Legend options.

Question 39: ............ is the set of values that you want to plot in the chart.
(a) Data series
(b) Data label
(c) Chart area
(d) Gridlines
Show Answer & Explanation

Answer: (a) Data series

Explanation:
1. A data series is the group of related values drawn as bars, lines or slices.
2. A data label is text on a data point and gridlines are guide lines.

Teacher's Note:
1. One column of numbers = one series.

Question 40: Which of the following shortcut key brings the cursor to the last cell on the sheet that contains data?
(a) Ctrl+Home
(b) Ctrl+End
(c) Ctrl+Page down
(d) Ctrl+down arrow
Show Answer & Explanation

Answer: (b) Ctrl+End

Explanation:
1. Ctrl + End jumps to the last cell that holds data.
2. Ctrl + Home goes to A1 instead.

Teacher's Note:
1. Home = start, End = end.

Question 41: You can select all cells in a worksheet by pressing ...... shortcut key.
(a) Ctrl+Z
(b) Ctrl+A
(c) Ctrl+D
(d) Ctrl+F
Show Answer & Explanation

Answer: (b) Ctrl+A

Explanation:
1. Ctrl + A selects every cell of the sheet.
2. Ctrl + Z is Undo and Ctrl + F opens Find.

Teacher's Note:
1. A = All.

Multiple Choice Questions (MCQs) for Computer Science LibreOffice Calc Spreadsheet

About LibreOffice Calc Spreadsheet MCQs for Computer Science

Test your conceptual understanding of LibreOffice Calc Spreadsheet with these targeted multiple-choice questions. Designed in alignment with the latest NCERT curriculum for Computer Science, these problem sets build accuracy and prepare students for objective exams.

How to Verify Your MCQ Answers

Cross-reference your completed choices with comprehensive NCERT solutions for Computer Science to ensure absolute clarity across all sub-topics in this chapter.

Enhance Speed with Online MCQ Tests

Follow up your worksheet practice by attempting the interactive online Computer Science MCQ test for this chapter to evaluate your execution speed. All platform resources are free to access.

FAQs

Where can I access latest Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01?

You can get most exhaustive Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01 for free on StudiesToday.com. These MCQs for Computer Science are updated for the 2026-27 academic session as per examination standards.

Are Assertion-Reasoning and Case-Study MCQs included in the Computer Science [current-page:node:field_class] material?

Yes, our Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01 include the latest type of questions, such as Assertion-Reasoning and Case-based MCQs. 50% of the paper is now competency-based.

How do practicing Computer Science MCQs help in scoring full marks in [current-page:node:field_class] exams?

By solving our Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01, students can improve their accuracy and speed which is important as objective questions provide a chance to secure 100% marks in the Computer Science.

Do you provide answers and explanations for Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01?

Yes, Computer Science MCQs for have answer key and brief explanations to help students understand logic behind the correct option as its important for 2026 competency-focused exams.

Can I practice these Computer Science [current-page:node:field_class] MCQs online?

Yes, you can also access online interactive tests for Computer Course CCC Chapter 04 Spreadsheet LibreOffice Calc MCQs Set 01 on StudiesToday.com as they provide instant answers and score to help you track your progress in Computer Science.