NEW
Font size
WorksheetsFormatting Cells in Spreadsheet - Objective Type Questions
Total questions: 13
Worksheet time: 7mins
If the data is of text type, it will be aligned towards .................... If the data is of numeric type, it will be aligned towards.............
left, right
right, left
Both are aligned left
None of these
Which of the following options helps to rotate the direction of the contents in a Cell.
Wrap Text
Shrink to fit Cell size
Text Orientation
None of these
.................... is an additional feature in spreadsheet in which a certain kind of predefined series of data are automatically generated once the user feeds the initial data.
Automatic Fill
Auto Fill
Wrap Text
Custom List
Which of the following menu has 'Cells' option to apply formatting on cells?
Home
Format
Edit
None of these
Which of the following helps to forecast the trends on the basis of comparisons?
Chart
Legends
Plots
None of these
What helps to identify the plotted data series? Unique colour or pattern is helpful to identify such series.
Data Label
Gridlines
Legend
Data series
'Calc' provides a feature to create a .................... where some series of names or text can be pre-defined and then displayed when the initial data is entered and AutoFill is applied.
Style
Wrap Text
Custom List
None of these
The chart preview can be seen in ....................
Page preview
Chart preview
Export chart
All of these
Which of the following is a shortcut key to open a new workbook:
Ctrl + W
Ctrl + S
Ctrl + Q
Ctrl + N
We can replace multiple occurrences of a word using which of the following facilities of Calc?
By find and replace
By copy command
By replace only
By preview command
The Chart Wizard dialog box appear with four steps on the left side. Which of the following is not a step among these steps?
Chart Type
Data Series
Chart Element
Legend
What is the name of the mechanism to arrange the data in a particular order?
Sorting
Searching
Filtering
Validating
How many axes does charts in Calc have?
Two
Three
Five
Four
