SPREADSHEET

A spreadsheet is an interactive computer application for organization, analysis and storage of data in
tabular form. Spreadsheets are developed as computerized simulations of paper accounting
worksheets. The program operates on data entered in cells of a table. Each cell may contain either
numeric or text data, or the results of formulas that automatically calculate and display a value
based on the contents of other cells. A spreadsheet or worksheet may also refer to one such
electronic document.

Źródło: http://kingsoft-spreadsheets-professional.en.softonic.com/

Spreadsheet users may adjust any stored value and observe the effects on calculated values. This
makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated
without manual recalculation. Modern spreadsheet software can have multiple interacting sheets,
and can display data either as text and numerals, or in graphical form.

USES OF SPREADSHEET
Spreadsheet software is very versatile and can be used for both very simple and very complex tasks.
Lists, such as vocabulary, parts for a project or grocery shopping, can be easily composed in a
spreadsheet. Adding or deleting items from a list like this is also simple, so the lists can be used
many times.
The management of more complex data, such as earnings, expenses, budgets and other accounting,
is also made easier with a spreadsheet. Spreadsheet programs include features that can calculate
complicated math, including everything from basic addition and subtraction to percentages, taxes
and multi-step problems. This makes spreadsheets essential for businesses, self-employed
individuals and anyone who needs to keep an account of expenses and income.
Spreadsheet programs also include software that creates graphs and charts from the data provided
within the table. This is good for presentations, such as business meetings and research projects, and
offers a fresh view of the data. These graphs and charts are customizable and can be specific or
general depending on the settings and options chosen.

SPREADSHEET FUNCTIONS
Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables,
nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature,
let alone use Excel’s functions to create powerful formulas.

If that’s you, here are 15 handy Excel functions that will get you well on your way to spreadsheet
mastery.
=SUM() (SUMA)
The first function anyone should know tells Excel to carry out basic arithmetic. Let’s say you
wanted the numbers in cell A2 and cell B2 to be added together in cell B3. All you’d do is enter
=SUM into B3, click the =SUM entry in the pop-up that appears, Control + Click in cell A2 and B2
to highlight both, then hit Enter. In an instant you’d see sum of the two cells appear.

You can use this function, and most of the functions listed here, to encompass as many cells as you
require—just select all the ones you need included.

=AVERAGE (ŚREDNI)
Average does exactly what it says and works similarly to SUM. If you have a worksheet containing
your monthly earnings over the past year in columns A2 through A13, type =AVERAGE(A2:A13)
into A14 to get the average.

Again, you can also use your mouse cursor to click-and-drag highlight a range of cells, or use
Control + Click to handpick individual cells.

=MIN()
If you need to find the smallest number in a range of cells, MIN can help you do that. Using
=MIN(B3:B39) will give you the smallest number contained in those cells.

=MAX()
Max is the counterpart to MIN and does the opposite showing you the largest number contained in a
range of cells.
=TRIM() (USUŃ.ZBĘDNE.ODSTĘPY)
If you copy text from another program into Excel you can often end up with excess whitespace that
turns your spreadsheet into a visual horror. TRIM can help you clean it up.

TRIM can only deal with text from a single cell. So start by cleaning up the text in cell B1 by
typing =TRIM(B1) into cell C1, for example, and then repeat the function for any other cells you
need tidied up.

If you’re looking to clean up line breaks, try CLEAN instead of TRIM.

=COUNT() (ILE.LICZB)
If you need to know how many cells in a given range contain numbers, don’t bother counting by
hand—just use the COUNT function. If you have a mix of numbers and text in cells A1-A20, for
example, type into cell A21 =COUNT(A1:20) and you’ll have the answer in no time.

=COUNTA() (ILE.NIEPUSTYCH)
Similar to the above example, you can use =COUNTA() to count the number of cells in a given
range that contain characters such as numbers, text, or symbols.

=LEN() (DŁ)
If you want to count the number of characters in a single cell, including white spaces, check out
LEN. Want to know how many characters are in cell A1? Just type =LEN(A1) into a different cell
and you’ll find out.

=CONCATENATE() (ZŁĄCZ.TEKSTY)
This takes data from two cells and turns it into one. Check out our previous look at Excel functions
to see how this can be useful.

=DAYS() (DNI)
Want to know the number of days between two dates in a spreadsheet? If you had for example,
September 5, 2015 in cell A4 and December 27, 2015 in A5 just use =DAYS(A5, A4) to get the
answer. (Reversing the order of cells would give you a positive number).

=NETWORKDAYS() (DNI.ROBOCZE)
Knowing the number of days is great, but if you need to know how many work days that range
encompasses, turn to NETWORKDAYS (that’s ‘net work days’) instead. This function uses the
same format as DAYS, but you need to use an ascending cell order to get a non-negative number.
So =NETWORKDAYS(A4, A5) will give you 80 and not -80.

=SQRT() (PIERWIASTEK)
Need to know the square root of 1764? Type =SQRT(1764) into a cell, hit Enter, and you’ll find the
answer to life, the universe, and everything—including the example formula.

=NOW() (TERAZ)
Want to see the current date and time whenever you open a particular worksheet? Type =NOW()
into the cell where you want the date and you’re done. If you want to see a future date from right
now, you can use something like =NOW()+32. The now function does not take any arguments so
don’t put anything in between the brackets.

=ROUND() (ZAOKR)
As its name suggests, this function lets you round off numbers. ROUND requires two arguments: a
number or cell, and the number of digits to round to. If you have the number 231.852645 in A1, for
example, =ROUND(A1, 0) gives you 232, =ROUND(A1, 1) gives you 232.9, and =ROUND(A1,
-1) returns 230.

=ROUNDUP(), =ROUNDDOWN() (ZAOKR.DÓŁ, ZAOKR.GÓRA)

Źródła:
https://en.wikipedia.org/wiki/Spreadsheet
https://www.reference.com/technology/different-uses-spreadsheets-aa75fd29bfcaa3ed#
http://www.excel-szkolenia.com/kurs-excel-podstawy.php?lekcja=7
Opracowała: Małgorzata Popko