Changing the column width and row height.
Inserting and deleting worksheet columns and rows
Delete, add, copy, rename sheet
All these operations and others are performed using the context menu that opens in relation to the active sheet label (Fig. 1)
To change the number of sheets in a newly created book, you must open the dialog box Excel Options and in the appropriate section indicate the required number of sheets:
File - Options - General
When creating new books (number of sheets)
Inserting columns and rows on a sheet is done using the icon of the corresponding functions on the ribbon in the group cells tab home (rice.). To insert columns and rows, you can use context menu. Columns are inserted to the right of the cursor, and rows are inserted above the cursor.
To delete a row/column, select a row/column or several rows/columns and use the corresponding functions on the ribbon (fig.) or in the context menu.
Rows/columns are selected by clicking the left mouse button on the row/column name.
To change the column width and row height:
Cell is the smallest indivisible structural unit for placing data within a worksheet. Cells can contain text, numeric values, formulas, macros. The program automatically recognizes the type of data and determines the list of operations that can be performed with them.
According to their contents, the cells are divided into initial (influencing) and dependent. The cell selected with the pointer is called the active or current cell. To change the height or width of a cell, you need to change the row height and column width respectively. All rows are numbered, columns are marked with letters.
Excel automatically assigns unique addresses to each cell in a worksheet. cell address, which the program assigns to it consists of a column address and a row address. The address of the active cell is displayed on the left side of the formula bar.
Working field excel is a table. The table consists of columns, with headings A, B, C, D, and so on, and numbered rows. Each cell on the sheet has its own name (address), for example, the top left cell has the address A1. This cell is framed. Any cell highlighted with a frame is active, that is, it is in this cell that you can enter data from the keyboard.
The address of the selected cell appears in Name field, located above the heading of column A at the same level with Formula line.
AT excel there is a concept cell interval. A cell range is a rectangular section of a table of multiple cells. The interval is set by specifying the address of the upper left and lower right cells of the rectangular block of cells. The addresses of these two cells, when setting the interval, are separated by a colon, for example - B7: E11.
Argument is a value that is used to calculate the values of functions.
A block is a range of cells bordered only by empty cells or column and row headers.
The clipboard is a part of memory designed to temporarily store a copied or cut information object until it is replaced by the next object.
The return value is the value that is the result of the function evaluation.
Selection is the operation of selecting an object on the monitor screen to perform any action with it.
Selection - the procedure for selecting a cell or cells for subsequent work with them. The selected range cells are displayed with a dark background, the active range cell retains a light background.
Alignment is an operation that allows you to place text at the discretion of the user: left or right, centered or justified.
Alignment - The placement of material within a cell, including line direction, character orientation, horizontal and vertical justification, and line break mode.
Typeface - character design style. For example: Times New Roman or Verdana.
Gradient is a command to gradually change the color of text from character to character.
Border - a rectangular frame that represents a selected cell or range
A range is a compact group of table cells that has a rectangular shape.
The key is the field by which the list is sorted.
Copying - an operation in which the contents of the source area are duplicated in the destination area
The autofill marker is a square in the lower right corner of the selected range border.
The parent row is the calculated row of the table, the formulas in which are compiled “manually” (not copied from anywhere).
The optimal solution is the combination input parameters models for which its output parameter is maximum or minimum.
A filtered list is a list in which rows that do not meet the selection (filtering) condition are hidden (but not deleted!)
Transfer is an operation in which the contents of the active cell or selected cells (source area) are moved to another cell or range (destination area).
Editing is the operation of changing the values of previously entered data.
List sorting - sorting the list entries in ascending or descending order by the value of one or more fields.
Status bar - a place to display information about current state workspace and program, and current prompts.
The formula bar is where formulas are displayed and edited.
The current row is the row in which the active cell is located.
The current column is the column in which the active cell is located.
Filtering is a way to search for data using filters. Filtering differs from sorting in that the filtering process does not reorder the records, but excludes from the set those records that do not meet the specified criteria.
Background - a combination of color and pattern that is used to fill a cell in order to visually enhance it.
A data form is a dialog box in which list fields correspond to input fields, and there are buttons for performing operations with lists.
Formatting is the operation of changing the presentation of data on the screen or in a printed document without changing their values.
A formula is an entry in the content area of a cell that begins with an equal sign and describes the actions that result in the calculation of a value that is placed in the display area of the same cell.
Formula - an expression that serves to perform a mathematical and (or) logical operation. The formula includes: Equal sign, cell addresses, numeric constants, arithmetic operations and functions.
A function is a part of a formula that indicates the need to perform standard calculations. A function consists of a function name followed by a list of arguments enclosed in parentheses.
A template is a file that serves as a template for quickly creating and filling out the same type of file.
Cell - elementary structural element a table used to store data, having an address and two areas: content and display.
A cell is the intersection of a column and a row in a spreadsheet. Each cell has its own address (or name), consisting of a column name and a row number, for example: A1, D3, F5, etc.
Error messages in Excel:
#### – the cell width does not allow displaying the number in the given format.
#DIV/0! - perform division by zero.
#NAME? - Invalid cell name set. It is possible that the Cyrillic alphabet was mistakenly used for typing the names, and not the Latin alphabet.
#NUMBER! - incorrect application of mathematical formulas. For example, extracting square root from a negative number.
#VALUE! - Invalid argument type used. For example: attracting a cell containing text to perform an arithmetic operation.
#EMPTY! - incorrect indication of the intersection of two areas that do not have common cells.
To check an unstressed vowel in the root, you need to choose a related word or form of the same word so that this vowel is stressed.
If the root is followed by a suffix -a-, in roots with alternating e(and) is written and, and in the roots -lie-(-lag-) and -braid-(-cus-) is written a.
Fundamentally mountains(gar- about. Exceptions: scorch, scorch, burn(special and dialect words).
in the roots clone-(clan-), creative-(creature-) in an unstressed position is written about.
Fundamentally zor- written in an unstressed position a. Exception: to mature.
Fundamentally -grew-(-growth-) before st and sch spelled a. Exceptions: branch, sprout, sprout, usurer, Rostov, Rostislav, Rostokino.
Fundamentally -skoch-(-with how-) before h spelled about, before k is written a. Exceptions: jump, jump.
Spelling depends on the meaning about and a in the roots -mok-(-poppy-) and -even-(-equal-):
-mok-- in the meaning of "pass liquid";
-poppy-- in the meaning of "lower into the liquid";
-even-- in the meaning of "smooth", "smooth";
-equal-- in the meaning of "same, identical"
Fundamentally -float- always spelled a: swim, buoyancy. Exceptions: swimmer, swimmer, quicksand.
To check the spelling of roots with unpronounceable consonants ( stn, zdn, lnts, rdts) you need to choose a related word so that this consonant comes before the vowel.
At the root of the word after hissing is written yo, if in related words it alternates with e; if it is formed from a verb or a passive participle of the past tense.
In suffixes and endings after hissing under stress, it is written about.
At the root after c spelled and. Exceptions: gypsy, tiptoe, chick, chick.
In suffixes and endings after c spelled s(except for the words -tion).
In suffixes and endings under stress, it is written about, without stress - e.
b written in the indefinite form of verbs: wash your face, in the shape of imperative mood: put, in the form of 2 l. unit: wash your face.
Dividing b written before root e, yo, yu, i after prefixes into a consonant and in foreign words after the following prefixes into a consonant: ab, hell, diz, in, inter, con, counter, ob, sub, trans, as well as after the initial pan.
After a prefix ending in a hard consonant, at the root of the word, instead of and write s(as we hear, so we write). In the word charge spelled and according to pronunciation.
Note. This rule does not apply to complex abbreviated words, for example: pedagogical institute, sports equipment.
After prefixes inter-, in excess of- preserved and, because after the hissing and back-lingual is not written s.
Saved and also after foreign prefixes and particles ( counter-, dez-, trans-, pan-, sub-, post-, super-).
Console at- used in the meanings:
- "approximation, attachment, incompleteness of action, proximity": sew, open, school.
- bringing the action to the end: hit.
- doing something for someone's benefit hide.
Console pre- used in the meanings:
- "very" (the highest degree of manifestation): unpleasant.
- "re-": block.
In attachments for s-s s written before the voiced With before a voiceless consonant.
Floor- written with a hyphen before root vowels, l and capital letters. In other cases floor- is written fluently.
Console semi- is written fluently.
Difficult words- these are words that are formed by combining two bases in one word.
about, if the first stem ends in a solid consonant.
Roots in compound words are connected with a connecting vowel. e, if the first stem ends in a soft consonant, sibilant and c.
written with a hyphen -
- names of the cardinal directions: northeast, southwest;
- names of complex mechanisms and units of measurement: diesel engine, bed. Exception - workday;
- the names of some plants: Blooming Sally;
- with initial foreign language elements vice-, life-, staff-, ex-.
- formed from two words of the same thematic group (words-synonyms, antonyms that clarify each other): misfortune(synonyms), raincoat tent (cloak and he- tent).
Compound words are spelled -
with a verb and in the first part: daredevil. Exception - Tumbleweed;
with a numeral in the form genitive in the first part of the word: fivefold. But: centipede(because not in the direct meaning of the account). Exceptions: 90 (ninety kilograms), 100 (hundred meters), 1000 (thousand years);
city dweller names: Almaty citizen;
compound abbreviations: duffel bag.
Adjectives are hyphenated:
formed from coordinating phrases: Russian-English dictionary
(dictionary with Russian and English words);
expressing quality with an additional touch: light green;
formed from hyphenated nouns: New York;
Rest compound adjectives are written fluently.
Suffix -chik written in nouns with a person meaning after root consonants e, t, h, s, f if there are no other consonants before them: defector; alimony.
Before suffix -chik final consonant stems k, c, h are replaced t: distribution - distributor.
Before suffix -schik spelled soft sign only after l: roofer.
Suffix -ek is written if, when changing the word e drops out: lock - lock, but: key - key.
Suffix (unstressed) -ets- written in nouns m.r.: well, -its-- in nouns f.r.: gorgeous.
From the stem of the infinitive to -et, -it, -ty, -who past participles are formed with the suffix -enn-.
From the stem of the infinitive to -at, -at formed passive participles past tense with suffix -nn-, wherein verbal suffixes -a- and -I- in the sacrament are preserved.
(Smart person. Tutorial. L.D.Bednarskaya, L.A.Konstantinova, E.P.Schennikova)
