28 Questions
How can you select a field to insert in the document?
Click and hold down on the name of the field you want
What does it mean when the mouse has a + attached to it?
The field is being dragged into the document
How can you select a field for copying or cutting?
Click on the right side of the field, hold down Shift, and press the left keyboard key once
What should the fields display with to help differentiate them from typed text?
A gray background
How do the fields respond to formatting?
The same way that normal text does
What is the next step after creating the mail merge document?
Printing the letter to a printer or 'printing' to a Writer file
What should you do if you accidentally click 'Yes' when opening the output from merged labels?
Close it without saving, and reopen it, clicking 'No' this time
What should you do after viewing the merged document and proofing it?
Make any changes you want and save it
What should you do to print the merged document?
Print it like a normal document
What should be listed at the top of the document before the date?
Your address
What format should the date be in on the document?
Month, date, year
How many families should you include in the data source for mailing the letters?
At least five families
How can you summarize data from several sources in a spreadsheet?
By linking cells from various worksheets and other spreadsheets.
What is the default name of the first sheet in a new spreadsheet and how is it managed?
Sheet1, managed using tabs at the bottom of the spreadsheet.
What are the different ways to insert a new sheet in a spreadsheet?
Select Insert > Sheet from the menu bar, or Right-click on the tab and select Insert Sheet, or Click in an empty space at the end of the line of sheet tabs.
How can you create a new sheet in a spreadsheet?
By using one of the methods to insert a new sheet as mentioned earlier.
What is the purpose of having multiple sheets in a spreadsheet?
To keep information organized and work with different sets of data.
What advantage do multiple sheets provide when working with data in a spreadsheet?
They allow you to create formulas that span different sources and make calculations using a combination of local and linked information.
What is the purpose of storing a stub with the desired name in the Standard library when dealing with large macros or many macros?
The stub macro loads the library containing the implementation and then calls the implementation.
How can you change the name of a macro from NumberFive to NumberFive_Implementation?
Change the name in the Basic IDE by editing the macro code.
What should you do to create a new module in the Standard library of the CalcTestMacros document?
Select the Standard library and click New to create a new module with a meaningful name.
What does the new macro in the Standard library do?
It loads the AuthorsCalcMacros library if not already loaded, and then calls the implementation function.
What is a macro in the context of spreadsheets?
A macro is a saved sequence of commands or keystrokes that are stored for later use.
How can macros be useful in spreadsheet tasks?
Macros are especially useful to repeat a task the same way over and over again.
What is the purpose of the macro recorder in OpenOffice.org?
The macro recorder in OpenOffice.org helps in creating and understanding general macro capabilities.
Describe the steps to create a macro that performs 'paste special with multiply' in OpenOffice.org.
- Open a new spreadsheet. 2. Enter numbers into a sheet. 3. Select cell A3 and copy the value. 4. Select the range A1:C3. 5. Record the macro by using Tools > Macros > Record Macro. 6. Use Edit > Paste Special with operation set to Multiply. 7. Click Stop Recording when done.
What action should be taken after setting the operation to Multiply in the Paste Special dialog?
Click OK to multiply the selected cells by the specified value.
What happens when you click 'Stop Recording' in the macro recorder dialog?
Clicking 'Stop Recording' finalizes the macro creation process and opens the OpenOffice.org Basic Macros dialog.
Learn how to insert field names in a document by clicking and holding on the field name, dragging it to the desired location in the document, and releasing the mouse. This process allows you to insert dynamic fields in documents.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
