Computer Science, asked by Arjun1687, 7 hours ago

List two advantages of representing data in a spreadsheet software as a compared to a word processing software ?

Answers

Answered by AJTamil09

Answer:

Editing

When you build a spreadsheet, you enter data into a worksheet. Each data item is stored within a single cell. Cells can also contain formulas, either written by yourself or chosen from a predefined set designed for common tasks. For example, you could have a cell in a spreadsheet that performs a calculation using the values from other cells. If you then update the values in these other cells, the result in the formula cell updates as well. For this reason, spreadsheets offer a way to carry out continual analyses and calculations on your data sets automatically.

Formulas

The ability to enter mathematical formulas is key to the usefulness of spreadsheets. The following example formula carries out a calculation on a numerical data item:

=B9*2

This cell will multiply the value in the cell B9 by two. Formulas can express a variety of processes on sets of data. Common processes include looking up values within a specified range, testing whether values meet certain conditions, carrying out arithmetic operations, counting and transforming data items.

Preset Functions

Formulas are among the most useful aspects of a spreadsheet, but one of the reasons for their success is that you do not need to enter every formula manually. Spreadsheet programs provide a range of preset functions that encapsulate common formulas, allowing users to apply functions without having to type them in manually. Preset functions are accessible via buttons in spreadsheet program user interfaces. Common functions include sorting and filtering data as well as carrying out calculations such as sums and percentages.

Explanation:

Hey friend hope it helps you..