WorksheetsFunctions & Charts in Calc
Total questions: 10
Worksheet time: 4mins
The ____________error means that there is an error in the formula, range or name of the function.
#Name?
#REF!
#######
#VALUE! error
The ____________ is a location-based cell reference.
Absolute reference
Relative reference
Mixed Reference
The _______________ chart is used to illustrate the changes in a value over a period of time.
Column Chart
Line Chart
Pie Chart
Bar Chart
The ___________ feature of the Calc worksheet allows you to rearrange data in an efficient manner
Sorting
Filtering
Conditional formatting
The ______________ feature helps to quickly extract data from the spreadsheet that meets certain criteria
Sorting
Filtering
Conditional formatting
This feature of Calc is used to display cell values with a particular colour or background depending on the specified conditions.
auto fill
data validation
conditional formatting
auto complete
Which of the following will correctly convert the text “DUBBAI” to lowercase letters?
=lower(“DUBAI”)
=lower(DUBAI);
=low(“DUBAI)
lower(DUBAI)
Which chart can be used in OpenOffice Calc for comparing individual items in a set of data?
line chart
column chart
pie chart
bar chart
In OpenOffice Calc, a type of cell reference that is specified using a dollar sign ($) in front of a row and column.
range
relative cell reference
absolute cell reference
mixed cell reference
Which of the following syntax will correctly display the current date?
today(date)
=TODAY()
=TODAY(“ “);
=today
