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