NEW
Font size
WorksheetsCCC14 Chapter 4 - Spreadsheet
Total questions: 25
Worksheet time: 13mins
For calculation in a Calc spreadsheet, you need to use a
Formula
Table
Field
Variable
When a formatted number does not fit in a cell, number strings like has(####) are display
True
False
In LibreOffice Calc spreadsheet, Ctrl + H is used to display find and replace dialog hex.
True
False
Format painter is used to copy the formatting of a cell.
True
False
LibreOffice Calc spreadhseet prints gridlines by default.
True
False
It is possible to undo the deletion of a sheet.
True
False
Number of Rows in rows in LibreOffice Calc spreadsheet?
1,048,576
21,000,571
1,000,571
10000
How many spreadsheets on LibreOffice Calc by default?
1
2
3
4
Moves the cursor to the first cell in the sheet (A1) in LibreOffice
Ctrl + F1
Ctrl + Home
Alt + F1
Ctrl + O
The keys to optimizes the column width of the current cell in spreadhseet calc is
Alt + End
Ctrl + F2
F2
Alt + Right Arrow Key
The formatting toolbar has a lot of buttons that you can quickly apply to numerical data on the Calc worksheet. These buttons are.
Currency Style
Percent Style
Comma style
All of these
The combination of the column letter and row number of a cell in Calc spreadhseet is called
Cell Across
Cell Identification Number
Cell Reference
Cell Identify
What is the shortcut key for print preview in LibreOffice Calc?
Ctrl + Shift + P
Ctrl + Shift + O
Ctrl + P
Ctrl + T
In which menu is the Merge Sales command found in LibreOffice Calc?
Format
Style
Sheet
Edit
What is formed by adding LibreOffice rows and columns?
Cell
Table
Position
Data
LibreOffice Calc can have only one sheet?
True
False
What is the shortcut key to insert function in LibreOffice Calc?
Shift + F3
Ctrl + F2
Ctrl + F3
All + F3
Which shortcut key is used to insert time in LibreOffice Calc?
Ctrl + ;
Ctrl + Shift + ;
Ctrl + T
Ctrl + D
How are the data organized in a Calc spreadsheet?
In Line & Space
In Hight & Width
In Layer & Plain
In Row & Column
What do you see at the bottom of Writer & Calc window?
Title bar
Taskbar
Status bar
Menu bar
The default page orientation in LibreOffice Calc is
Landscape
Horizontal
Portrait
None of these
The 'Absolute Referencing' is
$A$1
$A:B1
A1:B1
None of these
The shortcut key is used to an entry in the cell or formula bar
Tab
Esc
Home
Ctrl + W
Number enter into a cell are automatically
Left - Aligned
Right - Aligned
Center - aligned
Justified
Formatting a cell in currency, you can specify
Decimal places
Currency symbol
Both
None
