Advanced Spreadsheets Quiz The Place For Free Online Training Courses 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. It is not necessary to enable ‘Auto Calculate’ to apply conditional formatting. True False2. What is the necessary condition to make hidden rows or columns visible again? Right-click on the row or column. Select the rows or columns on both sides of the hidden row or column. Double click on the row or column. None of the above.3. In LibreOffice Calc, ‘Trace Precedent’ gives us the cells on which the value of the current selected cell depends. True False4. Which of the following is not a day and time function? Today Tomorrow Month Year5. In LibreOffice Calc, we can choose between displaying the result of a formula or the formula itself in a cell. True False6. Which of the following is not a necessary condition for using pivot table\data pilot? Data should be in the form of database Only single cell should be selected from the list. List should not be empty. More than one cell should be selected from the list.7. While using the Scenario tool in Calc, it is advisable to: a) Use default names b) Change the default name c) Both a & b d) None of the above8. It is not possible to change the chart type of the chart which has been created for a defined data series. True False9. If the data labels are modified, is it possible to reflect the changes in pivot table? Yes No10. What is the difference between ‘TODAY’ and ‘NOW’ date and time functions? ‘TODAY’ displays only time and ‘NOW’ displays only date ‘NOW’ displays only time and ‘TODAY’ displays only time 'TODAY’ displays only date and ‘NOW’ displays both time and date. ‘TODAY’ displays both date and time and ‘NOW’ displays only time.11. What is the function of’ ‘TRANSPOSE’ paste special option? a) Data from selected cell is used for paste option b) Formatting of the selected cell is pasted. c) The rows of the selected range become columns and the columns become rows. d) a, b & c12. The arguments ‘COUNTIF’ function takes are: ‘criteria’ and ‘sum_range’ ‘range’ and ‘criteria’ ‘range’, ‘criteria’ and ‘sum_range’ ‘range’ and ‘sum_range’13. The spreadsheet to which we need to move or copy a sheet should be simultaneously open. True False14. In order to record a macro in Calc, which is the very first step which needs to be taken? First of all the sheet needs to be saved. First of all it needs to be made sure that macro recording has been enabled for the sheet. First of all the macro recording view needs to be opened. None of the above.15. What is the functionality of the ‘DOCUMENT’ option while creation of a hyperlink? We can create a hyperlink for jumping to an already existing document. We can create a hyperlink for creating and opening a new document. We can create a hyperlink for sending an email. None of the above.16. In LibreOffice Calc, while working with charts, we can use custom images by importing them into the charts from our local machine. True False17. What is the minimum number of rows and columns that need to be selected to apply auto-formatting to a cell range? 2 3 4 618. The arguments for ‘SUMIF’ function can only be entered manually. True False19. 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? lla bre Umb ell20. It is not possible to create a link between two different spreadsheets in Calc. True FalseBe sure to click Submit Quiz to see your results! Name Email Time is Up!