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. The arguments ‘COUNTIF’ function takes are:‘criteria’ and ‘sum_range’‘range’ and ‘criteria’‘range’, ‘criteria’ and ‘sum_range’‘range’ and ‘sum_range’2. Which of the following is not a necessary condition for using pivot table\data pilot?Data should be in the form of databaseOnly single cell should be selected from the list.List should not be empty.More than one cell should be selected from the list.3. What is the minimum number of rows and columns that need to be selected to apply auto-formatting to a cell range?23464. It is not possible to change the chart type of the chart which has been created for a defined data series.TrueFalse5. In LibreOffice Calc, while working with charts, we can use custom images by importing them into the charts from our local machine.TrueFalse6. 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?llabreUmbell7. While using the Scenario tool in Calc, it is advisable to:a) Use default namesb) Change the default namec) Both a & bd) None of the above8. The spreadsheet to which we need to move or copy a sheet should be simultaneously open.TrueFalse9. It is not possible to create a link between two different spreadsheets in Calc.TrueFalse10. Which of the following is not a day and time function?TodayTomorrowMonthYear11. The arguments for ‘SUMIF’ function can only be entered manually.TrueFalse12. In LibreOffice Calc, we can choose between displaying the result of a formula or the formula itself in a cell.TrueFalse13. 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.14. In LibreOffice Calc, ‘Trace Precedent’ gives us the cells on which the value of the current selected cell depends.TrueFalse15. 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. What is the function of’ ‘TRANSPOSE’ paste special option?a) Data from selected cell is used for paste optionb) Formatting of the selected cell is pasted.c) The rows of the selected range become columns and the columns become rows.d) a, b & c17. 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.18. It is not necessary to enable ‘Auto Calculate’ to apply conditional formatting.TrueFalse19. If the data labels are modified, is it possible to reflect the changes in pivot table?YesNo20. 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.Be sure to click Submit Quiz to see your results! Name Email Time is Up!