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 3 4 6 2. It is not necessary to enable ‘Auto Calculate’ to apply conditional formatting. True False 3. The spreadsheet to which we need to move or copy a sheet should be simultaneously open. True False 4. 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. 5. Which of the following is not a day and time function? Today Tomorrow Month Year 6. 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. 7. The arguments for ‘SUMIF’ function can only be entered manually. True False 8. The arguments ‘COUNTIF’ function takes are: ‘criteria’ and ‘sum_range’ ‘range’ and ‘criteria’ ‘range’, ‘criteria’ and ‘sum_range’ ‘range’ and ‘sum_range’ 9. It is not possible to change the chart type of the chart which has been created for a defined data series. True False 10. 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. 11. If the data labels are modified, is it possible to reflect the changes in pivot table? Yes No 12. 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 above 13. 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 & c 14. 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. 15. It is not possible to create a link between two different spreadsheets in Calc. True False 16. 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. 17. In LibreOffice Calc, we can choose between displaying the result of a formula or the formula itself in a cell. True False 18. In LibreOffice Calc, while working with charts, we can use custom images by importing them into the charts from our local machine. True False 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? lla bre Umb ell 20. In LibreOffice Calc, ‘Trace Precedent’ gives us the cells on which the value of the current selected cell depends. True False Be sure to click Submit Quiz to see your results! Name Email Time is Up! Time's up
