Question

Q6. Write the steps to record Macro in open office calc.​

Answer 1

Answer:

The following steps create a macro that performs paste special with multiply.

Open a new spreadsheet.

Enter numbers into a sheet.

Select cell A3, which contains the number 3, and copy the value to the clipboard.

Select the range A1:C3.

Use Tools > Macros > Record Macro to start the macro recorder

Answer 2

Here are the steps to record a macro in OpenOffice Calc:

• Open OpenOffice Calc and the worksheet you want to record a macro in.
• Go to the "Tools" menu and select "Macros" > "Record Macro".
• In the "Record Macro" dialog box, give the macro a name and choose where to save it. You can save it to your personal macro library or to the current document.
• Click "OK" to start recording the macro.
• Perform the actions you want to include in the macro. For example, you could enter some data, format cells, or sort data.
• Go to the "Tools" menu and select "Macros" > "Stop Recording".
• The macro is now recorded and can be run by going to the "Tools" menu and selecting "Macros" > "Run Macro".
• If you want to make changes to the recorded macro, you can go to the "Tools" menu, select "Macros" > "Organize Macros" > "OpenOffice.org Basic", find the macro you recorded, and edit it.

#SPJ3