WorksheetsCACL SPREADSHEET QUIZ
Total questions: 15
Worksheet time: 5mins
IT SHOWS THE CELL REFERENCE.
NAME BOX
FUNCTION WIZARD
FORMULA
INPUT LINE
FORMAT CELLS CAN ALSO BE OPEN BY --------- SHORTKEY.
CTRL+1
CTRL+2
CTRL+3
CTR+4
WHICH OF THE FOLLOWING IS AN EXTENSION OF A WORKSHEET CREATED IN CALC?
.ODS
.ODD
.XLS
.OBJ
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
A FUNCTION SHOULD START WITH
'=' SIGN
ALPHABETS
NUMBERS
ALL OF THESE
WHICH OF THE FOLLOWING OPTIONS IS USED TO PRINT A CHART?
INSERT . CHART
FILE . VIEW
FILE . PRINT
VIEW . CHART
A WORKSHEET IS A
COLLECTION OF WORKBOOKS
PROCESSING SOFTWARE
COMBINATION OF ROWS AND COLUMNS
NONE OF THE ABOVE
THE DEFAULT PAGE ORIENTATION IN CALC IS
LANDSCAPE
HORIZONTAL
PORTRAITQ
NONE OF THESE
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)
WHAT IS THE SHORTCUT KEY FOR SPECIAL PASTE OPTION IN LIBRE OFFICE CALC?
CTRL+SHIFT+V
CTRL+V
CTRL+N
CTRL+G
IF YOU WANT TO CREATE A TEXT AS A BOLD LETTER THEN WHICH SHORTCUT KEY IS USED?
CTRL+M
CTRL+G
CTRL+B
CTRL+A
THE KEY IS USED TO DISPLAY THE FORMAT CELL DIALOG BOX IN CALC IS?
CTRL+2
CTRL+1
CTRL+3
CTRL+4
THE KEY IS USED TO MOVE THE CURSOR AT A1 POSITION IN LIBRE OFFICE CALC?
HOME
CTRL+HOME
SHIFT+HOME
CTRL+ PAGE UP
WHICH OF THE FOLLOWING IS NOT A CELL REFERENCING TYPE IN CALC?
RELATIVE REFERENCING
ABSOLUTE REFERENCING
MIXED
REFERENCING
NONE
