answersLogoWhite

0


Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: How macros are created and used in spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why do you use macros?

Macros are used to automate repetative tasks.


Why you use macros?

Macros are used to automate repetative tasks.


What types of macros are available in Flowcode?

Component Macros are built in functions used to control components such as an LCD display, EEPROM, switches, serial data, etc. Macros are user created functions that help make the program more modular. As far as I can tell, there are only those 2 types.


How many Auto Keys macros can be created in a database?

4


What should be created when a useful spreadsheet is developed?

Document how to use the spreadsheet.


Why is it useful to create a macro on spreadsheet?

Macros come in handy when dealing with tasks such as a simple booking system for a stadium. For example, you may want to clear one section of the stadium or whatever you can press the macro and it automatically does it for you, so you don't ave to do it manually. You can also assign macros to other tasks in Excel so you don't get frustrated doing tasks manually.


What is the difference between macros in Microsoft Word and Microsoft Excel?

Not much, except that the macros would be written to perform different tasks, because Word (word processor) and Excel (spreadsheet) have different functions. Both are written by the user to perform a specific task, but since each application handles most tasks differently, the macros would need to be designed for the tasks relevant to the specific application.


What are the functions and purpose of a spreadsheet software?

Spreadsheet software is a specific type of software categorized by rows of cells with the abilities to hold numbers, text or calculations. This software is specifically used for the organization, analysis and presentation of numerical data. The data has the ability to be displayed as charts and graphs as well as pivot tables. Spreadsheets can be as simple or as complex as needed. Most spreadsheet programs also come with the ability to execute macros, scripts of command to execute more complicate math.


Which is spreadsheet package lotus Excel or quattro pro?

All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.


What are macros used for?

Macros can be used for a number of things. They can be used to create documents and other essential functions in a document easily. Macros are used for management and evaluation of spreadsheets.


Is it true that Macro can be used to automate almost any task you perform in Excel?

Yes it is. Macros are used to automate tasks. If you know how to create them, you can do many different kinds to do a wide range of tasks.


Which document is most efficiently created in spreadsheet software?

A balance sheet is very efficiently created in spreadsheet software. However, spreadsheet software has countless uses that make it very effective to use for a number of different projects.