What is the minimum number of rows and columns that need to be selected to apply auto-formatting to a cell range?
It is not necessary to enable ‘Auto Calculate’ to apply conditional formatting.
The spreadsheet to which we need to move or copy a sheet should be simultaneously open.
What is the necessary condition to make hidden rows or columns visible again?
Which of the following is not a day and time function?
What is the difference between ‘TODAY’ and ‘NOW’ date and time functions?
The arguments for ‘SUMIF’ function can only be entered manually.
The arguments ‘COUNTIF’ function takes are:
It is not possible to change the chart type of the chart which has been created for a defined data series.
Which of the following is not a necessary condition for using pivot table\data pilot?
If the data labels are modified, is it possible to reflect the changes in pivot table?
While using the Scenario tool in Calc, it is advisable to:
What is the function of’ ‘TRANSPOSE’ paste special option?
What is the functionality of the ‘DOCUMENT’ option while creation of a hyperlink?
It is not possible to create a link between two different spreadsheets in Calc.
In order to record a macro in Calc, which is the very first step which needs to be taken?
In LibreOffice Calc, we can choose between displaying the result of a formula or the formula itself in a cell.
In LibreOffice Calc, while working with charts, we can use custom images by importing them into the charts from our local machine.
In LibreOffice Calc, for function ‘LEFT’ under the ‘Text’ category, if the text chosen is ‘Umbrella’ and the number chosen is ‘3’, then what will be the result?
In LibreOffice Calc, ‘Trace Precedent’ gives us the cells on which the value of the current selected cell depends.