Font size
WorksheetsLibreoffice Calc
Total questions: 40
Worksheet time: 40mins
What is the last column in LibreOffice Calc?
AMJ
AMG
EMJ
ZZZ
What is the combination of row and column in LibreOffice Calc?
Table
Worksheet
Cell
Formula
What is the default file extension in LibreOffice Calc?
.odt
.ods
.xlsx
.odp
How many total rows are there in LibreOffice Calc?
1024
1048576
16384
148576
How many total columns are there in LibreOffice Calc?
1024
1048576
16384
10248576
What is the shortcut command to create a new file in LibreOffice Calc?
Ctrl+Shift+N
Ctrl+S
Ctrl+O
Ctrl+N
What is the shortcut command to save a file in LibreOffice Calc?
Alt+W
Ctrl+S
Alt+S
Ctrl+W
What is the shortcut command to open an existing file in LibreOffice Calc?
Ctrl+O
Alt+O
Ctrl+E
Ctrl+F
Calc is a component of
Spreadsheet
LibreOffice
Microsoft Office
Workbook Company
How many rows and columns are there in a spreadsheet?
1024 rows and 1048576 columns
148576 rows and 1024 columns
1048576 rows and 1024 columns
1048576 rows and 23895 columns
What is the default spreadsheet name?
Untitled 1
Unnamed 1
Spreadsheet 1
LibreOffice 1
Which is the topmost toolbar in LibreOffice Calc?
Status Bar
Formatting Toolbar
Title Bar
Menu Bar
Which is the bottom toolbar in LibreOffice Calc?
Status Bar
Formatting Toolbar
Title Bar
Menu Bar
What is the shortcut to go to the sheet on the right?
Ctrl + Up Arrow
Ctrl + Down Arrow
Ctrl + Pg Dn
Ctrl + Pg Up
What is the shortcut to go to the sheet on the left?
Ctrl + Up Arrow
Ctrl + Down Arrow
Ctrl + Pg Dn
Ctrl + Pg Up
On which toolbar can you find the font options?
Status Bar
Formatting Toolbar
Title Bar
Menu Bar
On which toolbar can you find the alignment options?
Status Bar
Formatting Toolbar
Title Bar
Menu Bar
On which toolbar can you find the button to save the file?
Status Bar
Formatting Toolbar
Title Bar
Standard Toolbar
What is the shortcut to select all the cells in the worksheet?
Ctrl + A
Ctrl + W
Ctrl + X
Ctrl + C
A (a) is a grid of cells made up of rows and columns.
The (a) box displays the reference of the selected cell
To select multiple ranges of cells, press the ______ key
Win
Alt
Shift
Ctrl
Which two buttons appear to the left of the input line as you start typing in a cell?
Cancel button and Accept button
Sum and = button
The smallest unit of a worksheet is called
Row
Column
Cell
Spreadsheet
A highlighted cell boundary that specifies the active cell
Cell pointer
Border
Range
Cell
Shortcut key to select an entire row
Ctrl + E
Shift + E
Shift + Spacebar
Ctrl + Spacebar
Which of the following is used to edit the content of the selected cell?
Name box
Formula bar
Active Cell
Both Formula bar and active cell.
Which of the following is used to select contiguous rows?
Shift
Alt
Ctrl
None of these
The type of data entered in a worksheet cell
Number
Text
Formulae
All of these
To select the entire row, click its _______ heading
column
row
cell
None of these
Contiguous means touching or connecting especially along a line
True
False
A rectangular block of contiguous cells is called
(a)
A collection of worksheets is called
(a)
The box that is located just above the main work area and displays the data or formula stored in the active cell is
(a)
The box that displays the reference of the data in the active cell is called
(a)
The formula bar displays the data of the selected cell
True
False
You can select only one range of cells at a time
True
False
The rows are numbered A, B, C and so on
True
False
The columns are labeled A, B, C and so on
True
False
Calc helps in calculation and in analysing data using formulae and tables.
True
False
