NEW
Font size
WorksheetsLibre office
Total questions: 15
Worksheet time: 8mins
_________ software can store, manipulate
and create graphical representations of data.
Processor
spreadsheet
Database
Presentation
________________ are the predefined formula
Functions
Attributes
Formulae
Arguments
The ____________ in Calc is also referred to as spreadsheet.
Workbook
Sheet
worksheet
book1
By default numbers are ________ aligned
right
left
center
justify
20-10*2+6
6
46
14
8
Find the correct formula
b1=c1*8
=c1*8
=c*8
b1=c*8
$b$6 is an example of ______________ cell reference
absolute
relative
mixed
circular
$c6 is an example of _________ cell reference
absolute
relative
mixed
circular
Characters are by default __________ aligned
right
left
center
justify
File extension for calc doc is ____________
.odp
.xls
.ods
.odt
Commonly used functions in calc are
sum, difference, average, count
sum, min, max, difference
sum, min, max, count, difference
sum, count, difference, product
The small black square in the bottom-right corner of
the selected cell or range is called a ___________
fill mode
fill up
auto fill
fill handle
The default cell referencing is ____________
absolute
relative
mixed
circular
What is the name of mechanism to arrange the data in a
particular order?
Sorting
Searching
Filtering
Validating
The contents of Cell A1, B1, C1 and D1 are 5, –25, 30 and
–35, respectively. What will be the value displayed in cell
E1 which contains the formula =MIN(A1:D1).
5
30
-25
-35
