answersLogoWhite

0


Best Answer

Spreadsheets are very versatile and it is possible to do many things with them in relation to manipulating data. Spreadsheets are designed for numerical analysis and manipulation. As a result of this they have hundreds of specialised functions for doing almost any kind of manipulation you need. This is mainly for numbers, but other kinds of data, such as dates, time, text and logical values can also be manipulated.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How can spreadsheets be used to manipulate complex data?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What can you do with a spreadsheet?

Spreadsheets are primarily used to manipulate numbers.


How a spreadsheet could be used in the workplace?

Spreadsheets are used for very simple adding, subtracting, and multiplying and for more complex what-if analysis. In spreadsheets it is easier to rearrange data and print it in a desirable layout.


What types of spreadsheets are used in accounting?

Accountants use spreadsheets to collect and analyze data. The types of spreadsheets that are used in accounting include Microsoft Excel, Sage and Google Docs.


How do you produce more complex spreadsheets for a wide variety of uses More complex spreadsheets will have structure that is familiar or often used?

This question is not clear. You can make a spreadsheet as complex as your skills allow. The best spreadsheets intended for people to use, appear simple and keep all the complexity hidden from the average user.


How can spreadsheets be used in educational settings?

Spreadsheets are widely used to save data from experiments and turn that data into tables and graphs. They are mostly used in the science and financial/budgeting classes, though I'm positive other uses exist


What is database software used for?

Database softwares are used for store, manipulate, and view a collection of data


What can be a data source for a mail merge?

Databases and spreadsheets make good data sources for mail merge.


What is Excel in a computer usage?

Microsoft Excel is a spreadsheet application. You use it to perform simple computations and statistical analysis of data sequences and tables of data, the results of which can be used to produce more complex computations or to produce charts and graphs of the data. User-defined scripts can be used to provide a more controlled environment for entering and processing the data, however the data sets tend to be small and easily-managed. There are physical limits imposed upon how much data can be stored in any one spreadsheet and it doesn't take long for the amount of data to greatly affect processing speed. As a result, spreadsheets are often used to model database systems as part of the database design process. Databases provide similar functionality to spreadsheets but without any of the constraints and can therefore scale far more easily, however they are inherently more complex to design.


What type of software is mainly used to manipulate text and data?

Word processing


What is the SQL data base material used for?

The SQL data base is programming language used to manipulate and retrieve data. Included in the language are elements such as data insert, query, update and delete.


What do people use spreadsheets for?

spreadsheets are used by accountants and people who are mathematician


What function a spreadsheet have to help organize data?

Spreadsheets have many functions to help organise data. Organising data is one of the purposes of a spreadsheet, particulary if it is a lot of numerical data. If it is things like names, address etc., a database can be better. Spreadsheets can do things like sort data and extract data. They can lay data out in a tabular format using the rows and columns in the spreadsheet. There are some specific database functions that can be used in a spreadsheet that are used for organising data.