Advanced Spreadsheets Quiz

This quiz is designed to test your knowledge of the contents of the Understanding Spreadsheets Course, part of the Office Software Suite series. These quizzes are designed to improve your Spreadsheet skills.

There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question.

Once you are satisfied with your answers, complete your name and email address and select “Submit Quiz“ to have your answers marked.

You will shortly receive an email advising you of your score, whether you have passed the quiz, and how your answers have been scored. It will also include your Free Online Training course quiz completion Certificate for the appropriate quiz.

1. 

What is the minimum number of rows and columns that need to be selected to apply auto-formatting to a cell range?

2. 

It is not necessary to enable ‘Auto Calculate’ to apply conditional formatting.

3. 

The spreadsheet to which we need to move or copy a sheet should be simultaneously open.

4. 

What is the necessary condition to make hidden rows or columns visible again?

5. 

Which of the following is not a day and time function?

6. 

What is the difference between ‘TODAY’ and ‘NOW’ date and time functions?

7. 

The arguments for ‘SUMIF’ function can only be entered manually.

8. 

The arguments ‘COUNTIF’ function takes are:

9. 

It is not possible to change the chart type of the chart which has been created for a defined data series.

10. 

Which of the following is not a necessary condition for using pivot table\data pilot?

11. 

If the data labels are modified, is it possible to reflect the changes in pivot table?

12. 

While using the Scenario tool in Calc, it is advisable to:

13. 

What is the function of’ ‘TRANSPOSE’ paste special option?

14. 

What is the functionality of the ‘DOCUMENT’ option while creation of a hyperlink?

15. 

It is not possible to create a link between two different spreadsheets in Calc.

16. 

In order to record a macro in Calc, which is the very first step which needs to be taken?

17. 

In LibreOffice Calc, we can choose between displaying the result of a formula or the formula itself in a cell.

18. 

In LibreOffice Calc, while working with charts, we can use custom images by importing them into the charts from our local machine.

19. 

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?

20. 

In LibreOffice Calc, ‘Trace Precedent’ gives us the cells on which the value of the current selected cell depends.

Be sure to click Submit Quiz to see your results!