Number line worksheets year 1: Addition with Number Lines Worksheets -printable

You can enter in worksheet cells
two types of data: constants and formulas.
Constants are values ​​that are not
change until they change
intentionally. Constants can be
the following types: numeric, text
(inscriptions), date and time of day, as well as
two special types — logical
values ​​and error values.

A number in Excel can only consist of
the following characters: numbers from 0 to 9, +, -,
(,), /, $, %, (.), E, ​​e. Comma in number
interpreted as delimiter
decimal places. Delimiter character
can be changed in app Language
and Windows Control Panel Standards.

There are following input rules
numbers:

1. If the number entry starts with a sign
«+» or «-«, the pixel omits the «+» and saves
«-«, interpreting the entered value
as a negative number.

2. Numeric values ​​enclosed in
parentheses are interpreted as
negative. For example, (5) is interpreted,
like -5.

3. The character E or e is used when entering
numbers in the potential representation.
For example, 1E6 is interpreted as 1,000
000 (one multiplied by ten in
sixth grade).

4. When entering large numbers, it is allowed
insert a robel to separate hundreds
from thousands, thousands from millions, etc. With
such an input, numbers appear in the cells
spaces, and in the formula bar without spaces.

5. If you start entering a number with a sign
currency, the cell will be applied
money format.

6. If you finish entering a number with a % sign, then
percentage will be applied to the cell
format.

7. Before entering a rational fraction,
to prevent Excel from interpreting it as a date,
enter 0 and a space, for example 3/4
enter 0 3/4. Numbers can be entered in
various formats. Excel has a set
standard number formats
may be changed if desired. Also
you can create your own custom
formats.

Normally, numbers are entered in
general number format. According
with it, the numbers in the cell are reflected in
habitual form. If the number length is not
exceeds the width of the cell, then it
displayed in the same way
is entered, if it exceeds, then the number will be
expressed in exponential form.
If the value of the number exceeds the allowable
according to the format value, then the cell displays
overflow sign — ####. Change,
standard format can be on the tab
View of the command Cells of the Format menu.

Entering text is similar to entering numbers
values. Text is arbitrary
character sequence, not
perceived as a number, date, time
days or formula. When entering a long
text that cannot be completely
displayed in a single cell, Excel is capable of
output it, overlapping neighboring cells.
But the text will still be
stored in only one cell. At
entering text into a cell that is overlaid
the contents of another cell, overlapping
the text is cut off. In the formula bar when
activate cell with long text
displays all stored in it
text. Long text in a cell
see by expanding the column with a double
by clicking on the column border in its
header. Column width is customizable
by the maximum width of the values ​​in this
column. Make it easier to read long
text values ​​can also wrap
text. This mode allows you to enter
long text values ​​with wrapping
on the following lines without overlapping
text to other cells. At the same time, Excel
increases the line height, which
contains a cell with additional
lines. To set this mode,
enable the checkbox Transfer to
words on the Command Alignment tab
Cells of the Format menu.

Sometimes you need to enter a signed number
«+» in front of it. With a simple set of «plus
number» Excel accepts the input value
as a numeric, and the «+» sign will be omitted. To
force Excel to handle special
characters, as with ordinary ones, you need to enter
numeric text. Numeric text can
consist of text and numbers or only
from numbers. If the value entered in
cell will consist of text and
numbers, it will be interpreted
like text. In order to create
text value consisting of the whole
from numeric characters, you should start
enter with an apostrophe or enter first
equals sign and then value,
enclosed in quotation marks. Equal sign
with quotation marks or an apostrophe appear in
line of formulas, but are not displayed in the cell.
While the numerical values
right-aligned by default
edge, numeric text, like normal,
aligned to the left.

Excel interprets date and time of day
like numbers. Basic unit of measurement
times in Excel are days. They
seem consistent
decimal values ​​from 1 to 65380.
Base date represented in decimal
number 1 is Sunday, January 1st
1900 Maximum decimal value
dates ; 65380 represents December 31, 2078
of the year. When you enter a date, Excel saves it
as a decimal value, which
equal to the number of days between the given
and base date. The time of day is
decimal that represents
part of the day between their start (12:00 at night)
and given time. For example, 12:00 noon
represented by a value of 0.5.

External representation in worker cells
sheet depends on the size assigned
cell. In date and time formats
the following delimiters are used:
«.», «/», «-» — for the date; «> — for
time.

When entering a date between 1920 and 2010. Can
indicate only the last two digits
of the year. When entering a date outside this range
the year must be written in full.

To enter the current time in a cell
or into a formula, should simultaneously
press the Ctrl, Shift and «:» keys. For input
current date into a cell or formula
keys must be pressed simultaneously.
Ctrl and «;».

There is no difference when entering date and time
between lowercase and uppercase letters.
When using 12 hour format
after entering the time, separated by a space,
enter AP (A) — to enter the time until
noon and PM (P) — to enter the time
afternoon. For example, 3:00 PM means
15:00. The date and time can be entered in one
cell. Then they should be divided
space.

Data such as date and time of day can
participate in calculations (addition,
subtraction), as well as being part of
formulas in the form of text (then they must be
enclosed in double quotes).

How to work with Excel

The second most important application that is part of the office suite is Microsoft Excel, a program for performing calculations and managing so-called spreadsheets. In turn, the spreadsheet is the main tool used for processing and analyzing digital information by means of computer technology. While spreadsheets are primarily related to numerical or financial transactions, they can also be used for a variety of data analysis tasks, giving the user a great deal of power, as the formulas available range from simple addition and subtraction to financial and statistical calculations.

A feature of Excel is that the program allows you to perform complex calculations that can use data located in different areas of the spreadsheet and linked by a certain relationship. To perform such calculations in Excel, it is possible to enter various formulas in the table cells. The program performs calculations and displays the result in a cell with a formula. An Excel application document is called a workbook, or simply an Excel workbook, which is a very convenient organizational tool. Such a workbook consists of sheets (an Excel worksheet can contain up to 65,536 rows and 256 columns), which are usually large tables of cells with numbers and textual information. You can say that Excel tables are like databases. Agree. There are some similarities. However, a database table is designed to store information, while an Excel table is mainly used to perform mathematical and statistical calculations. We figured it out a bit, now let’s move on.

In order to start working, we need to open a book. This is done as follows: we launch the Excel application using the Start > Programs > Microsoft Excel command. A new workbook with three sheets will immediately open in the Excel window. The basis of the worksheet is a grid of rows and columns. A cell is formed by the intersection of a row and a column. The cell(s) selected with the mouse is called the active cell. A line in a worksheet is identified by a name (number) that appears on the left side of the worksheet. A column in a worksheet is also identified by a name (in Latin letters) that appears at the top of the worksheet. The cell — the main element of the table — has its own unique address, consisting of a column and row number, for example, E4, and contains one element of information, whether it is a numeric value, text or formula. Just like in Word, every workbook created by Excel is based on some model called a template. By default, Excel bases a new workbook on a template named Book 1. The template saves information about cell and worksheet formatting used by toolbars. They may be pre-created and may contain form elements for reports, including invoices, promissory notes, financial statements, etc., accepted in a particular organization. By clicking the New button on the standard toolbar, you can create a new, blank, workbook based on the default template. We do it like this:

1. Give the program the New command from the File menu.
2. Select the required tab to define the category of the template for the workbook being created.
3. After that, the program will prompt you to choose one of the templates or wizards on which the new workbook will be based.

Excel allows you to enter three types of data into cells: numbers, text, formulas. Text can be used for table headings, explanations, or notes on a worksheet. If Excel does not recognize the data type as numeric or as a formula, then the data is treated as text. Numbers are used to represent numerical information and can be entered in various formats: general, monetary, financial, percentage, etc.