NEW
Font size
WorksheetsMultiple Choice Questions
Total questions: 35
Worksheet time: 18mins
The file extension of a LibreOffice Calc spreadsheet is:
.docx
.ods
.pptx
.xls
Which icon is used to create a formula in Calc?
Σ (Function Wizard)
B
I
U
The address of the cell located at column D and row 5 is:
5D
D5
5-D
D-5
Which function returns the largest value from selected cells?
SUM()
AVERAGE()
MAX()
MIN()
A range of cells from A1 to A10 is represented as:
A1:A10
A1#A10
A1→A10
A1|A10
The shortcut key to paste content is:
Ctrl + C
Ctrl + X
Ctrl + V
Ctrl + P
The bar that displays the active cell reference is called:
Title Bar
Status Bar
Name Box
Formula Bar
By default, numbers are aligned to the:
Left
Right
Center
Top
Which key permanently deletes selected data?
Backspace
Delete
Spacebar
Shift
A formula in Calc begins with which symbol?
@
=
$
#
The default number of sheets in a new spreadsheet is:
1
2
3
5
To move to the next cell to the right, press:
Tab
Enter
Shift + Tab
Ctrl + Tab
Which feature arranges data in ascending or descending order?
Sort
Filter
AutoFill
Format
Which function is used to add values in selected cells?
ADD()
SUM()
ADDING()
PLUS()
The intersection of a row and a column is called a:
Cell
Box
Block
Sheet
The shortcut key to cut selected cells is:
Ctrl + V
Ctrl + C
Ctrl + X
Ctrl + B
A group of cells selected together is called a:
Sheet
Row
Range
Box
Which function returns the smallest value?
MIN()
MAX()
LOW()
SMALL()
Short-cut key for saving a spreadsheet is:
Ctrl + S
Ctrl + X
Ctrl + P
Ctrl + F
To combine multiple cells into one, we use:
Split Cells
Merge Cells
Separate Cells
Divide Cells
A cell pointer highlights the:
First cell
Active cell
Last cell
Header cell
Text in Calc is aligned by default:
Left
Right
Center
Justify
A workbook contains:
One cell
Multiple worksheets
Only numbers
Headings only
The SUM() function adds:
Numbers only
Text only
Numbers & text
Nothing
The AutoFill feature helps in:
Joining text
Copying formulas
Increasing RAM
Formatting text
Spreadsheets cannot store:
Data
Formulas
Pictures
Nothing (all can be stored)
MIN() returns:
Smallest value
Largest value
Average value
Middle value
Formatting cells mainly changes:
Data meaning
Data accuracy
Data appearance
Data deletion
Which key combination is used to copy selected data?
Ctrl + P
Ctrl + V
Ctrl + C
Ctrl + D
The horizontal divisions in a spreadsheet are called:
Cells
Rows
Columns
Sheets
The vertical divisions in a spreadsheet are called:
Sheets
Columns
Ranges
Tables
The collection of multiple worksheets is known as a:
Workbook
Folder
Sheetbook
Database
Which function averages numeric values?
AVGG()
MEAN()
AVERAGE()
AVE()
The row heading of the first row is:
0
A
1
R1
A formula that adds A1 and B1 is:
=A1+B1
A1+B1=
+A1+B1
#A1+B1
