WorksheetsCell References in Calc
Total questions: 12
Worksheet time: 6mins
WHICH OF THE FOLLOWING IS AN EXTENSION OF A WORKSHEET CREATED IN CALC?
.ODS
.ODD
.XLS
.OBJ
A FUNCTION SHOULD START WITH
'=' SIGN
ALPHABETS
NUMBERS
ALL OF THESE
HOW CAN ONE CALCULATE THE TOTAL OF VALUES ENTERED IN A WORKSHEET COLUMN OF?
BY MANUAL ENTRY
BY AUTO-SUM
BY FORMULA
BY SUM FUNCTION
CELL ADDRESS $B$5 IN A FORMULA MEANS ?
it is a mixed reference
it is an absolute reference
it is a relative reference
none of the above
A CELL RANGE ALWAYS HAS THE ............ SYMBOL BETWEEN THE CELL REFERENCES.
; (SEMICOLON)
.(FULL STOP)
,(COMMA)
:(COLON)
A function contains function name and the _______ in the parenthesis.
Formula
group
arguments
series
A worksheet range is a
a. A command used for data modeling
b. A range of values such as from 23 to 234
c. A group of cells
d. A group of worksheets
