LibreOffice Calc Spreadsheet MCQ Questions with Answers

Select the appropriate answer from the choices given below.

Question. Which of the following is not a valid data type in Calc?
(a) Number
(b) Text
(c) Character
(d) Date/ Time

Answer : C

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

Answer : A

Question. Under which tab, the Print Preview option is available for printing?
(a) Formulae
(b) Data
(c) File
(d) View

Answer : C

Question. 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

Answer : C

Question. LibreOffice Calc stores dates internally as ....... .
(a) Date
(b) Text
(c) Number
(d) Date and time

Answer : C

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

Answer : A

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

Answer : A

Question. Calc documents are stored as files called
(a) workforce
(b) worksheets
(c) worktables
(d) workgroups

Answer : B

Question. ..........tab is used to insert Media picture, etc.
(a) File
(b) Edit
(c) Insert
(d) View

Answer : C

Question. Calc is a
(a) graphic program
(b) word processor
(c) spreadsheet
(d) None of the above

Answer : C

Question. Workbook is a collection of
(a) page setup
(b) buttons
(c) diagrams
(d) worksheets

Answer : D

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

Answer : D

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

Answer : D

Question. 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 a automatically added with each cell value

Answer : A

Question. In Calc, the contents of the active cell are displayed in the
(a) footer bar
(b) tool bar
(c) task bar
(d) formula bar

Answer : D

Question. Sorting and filtering provides you to.........the worksheet data.
(a) Formatting
(b) Manipulate
(c) Increase
(d) Decrease

Answer : B

Question. ............ appears at the bottom of the Calc window.
(a) Status bar
(b) Name box
(c) Formula bar
(d) Title bar

Answer : A

Question. 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

Answer : D

Question. 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

Answer : C

Question. 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

Answer : C

Question. 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

Answer : A

Question. 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

Answer : B

Question. 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

Answer : C

Question. Which allows you display the specific data?
(a) Sorting
(b) Filtering
(c) Scenario
(d) Custom sorting

Answer : B

Question. The intersection of row and column forms a
(a) square
(b) cell
(c) oval
(d) worksheet

Answer : B

Question. The default file extension of Calc Work book is
(a) .xlr
(b) .exe
(c) .exl
(d) .ods

Answer : D

Question. 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

Answer : C

Question. The another name for the XY chart is
(a) Column chart
(b) Net chart
(c) Bar chart
(d) Scatter chart

Answer : D

Question. If you type = 2 * (6 − 4) in cell A1, what value will be displayed?
(a) 2
(b) 4
(c) 6
(d) 8

Answer : B

Question. Which of the following software used to create Pie chart?
(a) Browser software
(b) Database software
(c) Desktop publishing software
(d) Spreadsheet software

Answer : D

Question. You can select all cells in a worksheet by pressing …… shortcut key.
(a) Ctrl+Z
(b) Ctrl+A
(c) Ctrl+D
(d) Ctrl+F

Answer : B

Question. You can place the chart legend in the chart at
(a) bottom
(b) corner
(c) top, right and left
(d) All of these

Answer : D

Question. =COUNT (4, 78, False, 18) will return ....
(a) 2
(b) 3
(c) 4
(d) 5

Answer : B

Question. 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

Answer : C

Question. 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

Answer : D

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

Answer : B

Question. Which of the following chart selects only one range of the data series?
(a) Line chart
(b) Pie chart
(c) Scatter chart
(d) Bar chart

Answer : B

Question. In Calc charts are created using which tab?
(a) Insert
(b) Format
(c) File
(d) Sheet

Answer : A

Question. 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]

Answer : A

Question. A chart placed in a worksheet is called
(a) formatting chart
(b) embedded chart
(c) aligning chart
(d) hanging chart

Answer : B

Question. A chart is created on the basis of values in
(a) Mail merge
(b) database
(c) spreadsheet
(d) document

Answer : C

Identify True/False from the following statements.

Question. To create a new worksheet, select worksheet from the Home tab.

Answer : False

Question. Text can be formatted in a cell.

Answer : True

Question. Calc worksheet is always in grid format

Answer : True

Question. Logical functions are performed boolean operations on given data.

Answer : True

Question. Legends provide additional information about a data marker.

Answer : False

Question. The default column width is 15 character.

Answer : False

Question. A51 is an example of a cell address.

Answer : True

Question. Page down key move one screen down in a worksheet.

Answer : True

Question. Tab moves one screen up in a worksheet.

Answer : False

Question. We cannot setup the page according to user’s need.

Answer : False

Question. There are six different types of formula operators.

Answer : False

Question. AutoSum in LibreOffice Calc represents by Greek letter sigma (Σ).

Answer : True

Question. Row run horizontally in a worksheet.

Answer : True

Question. Ctrl + U keys using applies or remove underline.

Answer : True

Question. There is only oneworksheet in a spreadsheet.

Answer : False 

Question. Sheet tab is displayedwhen you split a sheet.

Answer : False

Question. Using the Undo command, you can correct multiple actions.

Answer : True

Question. Delete key remove the cell contents.

Answer : True

Question. Chart titles are titles given to three axis are X,Y,Z.

Answer : False

Question. The cell with the black outline is called active cell.

Answer : True