Archive for October 2016

This quiz is designed to test your knowledge of the contents of the Advanced 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…

To run a macro, click on ‘Tools’ from the main menu bar. From the resulting drop-down menu, click on ‘Macros’, and from the sub-menu which gets displayed, click on ‘Run Macro’. This will open the ‘Macro Selector’ dialog box. In this dialog box, in the ‘Library’ field, we have the list of all the libraries.…

Record a simple macro like: change page setup, insert a table with a repeating heading row, insert fields in document header, footer. A macro is a saved sequence of commands or keystrokes that are stored for later use. The LibreOffice macro language is very flexible, allowing automation of both simple and complex tasks. Macros are…

Create, modify, insert, and delete automatic text entries. Automatic text entry means that a particular word will get automatically inserted into the document when only a pre-defined shortcut for that word is typed. This means that we can define shortcuts for some lengthy and often used words and then can write those words into the…