What can you do with data ranges?
Easily carry out sorting operations
Easily select data range
All
of these
Easily filter data using row and column
headers
How do dynamic charts behave in a spreadsheet?
Charts
update automatically when you update data
Charts update automatically when
clicked
Charts do not update when data are
changed
Charts update automatically after
saving the spreadsheet
What feature can combine data from one or more independent cell ranges and calculates a new range using a specified function?
Validity
Consolidation
Merge Document
Subtotals
What function can return how many cells have numeric values in a specified cell range?
COUNT
SUM
MIN
VAL
In Alignment properties of Format Cells window, what options automatically adjust cell size to its content?
Hyphenation active
Vertically stacked
Shrink to fit cell size
Wrap
text automatically
What character will you place between two cell references to make a cell range?
Dot
Dollar Sign
Colon
Asterisk
In Paste Special window, which is not an option to paste?
Object
Numbers
Text
Anchor
All formulas begin with what sign?
Dot
Asterisk
Equal
Plus
Where can you hide header and footer on printout?
Cell Style
Conditional Formatting
File Properties
Page
Style
What tool bar contains icon to align text to the right?
Formatting
toolbar
Picture toolbar
Drawing toolbar
None of these
What operator in Calc is used for exponentiation?
^
E
*
#
What action combines adjacent cells into a single cell?
Split
Ungroup
Group
Merge
In General option of OpenOffice.org, what is the year of the date "01/01/35" if "Interpret as years between" value is 1930?
2035
1935
2135
1835
In Find & Replace window, which is a valid Search in value?
Values
All
of these
Formulas
Notes
What function can be used to change the cell's appearance when used in a formula?
VDB
YIELD
RECEIVED
STYLE
In Format menu, what is the menu item that will allow you select cells to print?
Print
Ranges
Page
Sheet
Cells
Which of the fallowing is FALSE about sheet tab?
Sheet
tabs are always alphabetically arranged
Sheet tabs contains sheet name
Sheet tabs can be renamed by double
clicking on it
Sheet tabs can be arranged by drag and
drop
What is a scenario?
Set
of cell values for selected cells that you can choose from a combo box
Set of cell values for a cell that you
can choose from a combo box
Set of tables for filters
Set of filter values for tables
In Format Change Case, what item will change all the text in a cell to small letters?
lowercase
UPPERCASE
Sentence case
Capitalize Every Word
What can the Function Wizard do?
Guides you on entering functions and
its arguments
Displays the result of the formula in
focused cell
Displays the structure of the formula
in focused cell
All
of these
What feature can calculate a value that, as part of a formula, leads to the result you specify for the formula?
Consolidate
Validity
Goal
Seek
Detective
What function counts the number of empty cells?
COUNTIF
COUNT
COUNTBLANK
COUNTA
Where can you enter a formula?
Cell
All
of these
Named cell
Formula bar
In the Sort window, how many criteria can be defined?
4
1
2
3
If A1 contains the number 22 where 2 is just formatted as superscript, what will be the value of A2 if A2 contains the formula "=A1"?
22
4
0
None of the above
What does the small red square at the upper right corner of cell indicate?
Formula
Comments
Errors
Bookmark
What application in OpenOffice.org to calculate, analyze and manage your data in a spreadsheet?
Calc
Writer
Math
Impress
If you select multiple sheets then modify A1 of the first sheet, what will be the result?
A1
of all the selected sheets will have the same value
An error will be displayed
Only A1 of the focused sheet will be
modified
A1 will not be modified
What feature is used to debug sophisticated nested functions in Calc?
Formula bar
Function
Wizard
Consolidation
Conditional Formatting
What character will you place before each letter and number of a cell reference to make them absolute?
Dollar
sign
Dot
Asterisk
Sharp
What feature allows the user to range the rows to display in a table by selecting from drop down values at the table name?
Multiple Operations
Scenarios
Sort
AutoFilter
What does the error code #NUM mean?
No result
Invalid names
Invalid
floating point operation
Invalid references
What type of cell reference will adjust automatically when when you copy the formula?
Absolute
None of these
Relative
Cross
Which is not allowed to be inserted in a Calc spreadsheet?
OLE Object
Chart
None
of these
Picture
Which of following is true about using a function?
Can be used in logical operations
All
of these
Can be used as an argument of other
functions
Can be nested
Which option is available in Edit Changes?
Comments
Protect Records
All
of these
Record
Up to how many sections can the Split feature divide the sheet view?
3
1
2
4
In Page tab of Page Style window, what option or options will allow you to center the sheet in the printout page?
Horizontal
None of these
Vertical
Horizontal
and Vertical
What feature of Calc allows simultaneous write access for many users?
Group
Share
Document
Consolidation
Validity
Which is not a method of opening Rename Sheet window?
Right Click on sheet name tab then
click Rename Sheet
Double click on the sheet name tab
Click on Format, Sheet, Rename...
Click
on Data, Sheet, Rename
In Numbers tab of Format Cells, how will 0.250 be displayed if you enter 3 in the leading zeroes and decimal places options?
000.520
0.000250
000.250
000250.000
How does Calc store and handle date and time values?
As
numerical value
As numeric and string value
As a blog
As string value
What feature allows you to repeat rows and columns of large tables on printout?
Styles and Formatting
Edit
Print Ranges
Cell Style
Page Style
What filter type allows up to eight filter conditions?
AutoFilter
Advanced
Filter
All of these
Standard Filter
What is the minimum number of sections can Split divide the sheet view?
2
4
1
3
Which is not an option in Insert Cells window?
None
of these
Shift cells up
Shift cells back
Shift cells right
Which of the following statements is true about Database Range in Calc?
Accessible from Data Source view
Accessible from other spreadsheet
Each cell corresponds to a database
record
Not
accessible from Data Source view
By default, what will happen if you protect a sheet?
Nothing
All cells are still modifiable unless
the cell is protected
All cells in all the sheets will be
protected
All
cells of the sheet will be protected
In Print dialog box of Calc, what range option is not available for printing?
Selected sheets
Selected cells
None
of these
All sheets
What feature will automatically suggest matching number or word as you type in a cell?
AutoFill
AutoComplete
Look up
AutoInput
In Sheet tab of Page Style, which of the following can be excluded in printout?
Comments
None
of these
Zero values
Charts
Which of the following statement is FALSE about cells?
Non-adjacent
cells can be merged
Cells can have background image
Cells can be referenced in formula
Cells can be protected
Which is not a valid reference?
A1:A2
A.A2
A$1
A1?A2
What interactive table uses source data to create reports using drag and drop method?
Index Table
Chart
DataPilot
ASCII Table
