For what we use document page settings. Using parameters to find the optimal f

How
the columns of the table are marked in MS Excel:
letters A, B, C, etc. d

If cell C5 is specified in MS Excel , then it is ...
at the intersection of column C and row 5

What type of data is not allowed in a cell Ms Excel:
drawing

What kind of cell number format is missing in MS Excel:
tape

What is the cell format in MS Excel should be used to write the value 235.35
general

What is the cell format in MS Excel should be used for recording 07/23/57
the date

What is the cell format in MS Excel should be used for recording 13.33%
percentage

IN
cell C1, C2 and C3, respectively, 5, –6, 4. What happens in cell C5,
if you add the formula = SUM (C1: C3)
3

IN
cells B1, B2 are entered numbers 10 and 20. What will appear in cell B3, if you apply
Autocomplete
30

Where the fully relative addressing to cell C4 is indicated:
C 4

Initially, in cells C1, C2, C3 numbers 1,2,3 are entered, and in cell D 1 put the formula reference = C1. What
will turn out in D 2, D 3 if apply Autocomplete based on
cell D 1:
2,3

Excel. Math function -
ROOT

MS Word. What is the Micrasoft object for
Equation?
To create mathematical formulas

How many cells
is contained in the range A1: B3 of the spreadsheet?
9

Excel. Team
changing the cell format -
Format - Cells

Raster graphics editor
created for…
creation
and editing pictures

In spreadsheets, cell name
formed ...
from row and column name

The event that made it possible
the emergence of a personal computer:
invention of the microprocessor

One kilobyte of information is ...
1024 bytes

Command mode control of the MS DOS system
implemented ...
by entering special commands from the keyboard

The category of viruses does NOT include ...
type viruses

In a text editor, the main
parameters when setting
fonts are ...
typeface, size, style

Infection with computer viruses can
happen in the process ...
working with files

Binary encoding one of 256
characters (letters) requires the number
information ...
<variant> 1 byte

To save a text file (document)
in a specific format
need to ask ...
file type

Paint is designed to ...
creating the simplest drawings

Electronic mail (e-mail) allows
transfer ...
<variant>messages and attached
files

Correctly written for Microsoft Excel:

= (D4-J7) / (F4 + D $ 6)

The main characteristic of the monitor is
The number of image dots horizontally and
vertical (resolution)

What we use page parameters for
document?
To set indents from page borders to
text boundaries

Can we enclose some of the text with a frame that
to highlight it?
Yes, for this you need to use
borders and fill. What action can we perform with
table?
Highlight the extra

Paint one cell

How to enable the toolbar
Drawing?
View
- Toolbars - Drawing

How to insert a picture into a text
TR MS Word document?
from
graphic editor

Test: Text Editor

Question number 1: What do we use document page settings for?

1. To insert pagination

2. To arrange hyphenation

3. To set indents from page borders to text borders

4. To align the text

Question number 2: Can we draw a frame around part of the text to highlight it?

Choose one of the answer options:

1. Yes, you need to use borders and fill for that.

2. And for this you need to use the page parameters

3. This can be done using the Fields item in the Page Settings.

4. No, you can only frame the whole page

Question number 3: Attention, there are several possible answers to this question!
What points can we implement when printing a document?

1. Specify the number of pages

2. Specify printing multiple pages on one

3. Specify printing 5 pages on one

4.print only individual pages

5. Select to print multiple copies

Question number 4: A text editor is a program for ...

Choose one of the answer options:

1. processing of graphic information

2.processing video information

3. processing of text information

4.working with musical recordings

Question number 5: How to delete the character to the left of the cursor ...

Choose one of the answer options:

1. Click Delete

2. Press BS

3. Press Alt

4. Press Ctrl + Shift

Question number 6: Specify how to save the edited document under a different name.

3. Choose location and file name

Question number 7: What action can we perform with the table?

Please select several answer options:

1. Merging cells

2. Change the number of rows and columns

3. Close one cell

4. Insert a picture instead of a border

5.Change the look of table borders

Question number 8: The cursor is

Choose one of the answer options:

1.device for inputting text information

2.key on the keyboard

3.the smallest display item on the screen

4.mark on the monitor screen indicating the position at which keyboard input will be displayed

Question number 9: How to enable the Drawing toolbar?

Choose one of the answer options:

1. View - Toolbars - Drawing

2. Edit - Paste - Toolbars - Draw

3. File - Open - Draw

Question number 10: How can you insert a picture into a TP MS Word text document?
(Attention to this question, there are several possible answers.)

Please select several answer options:

1.from the graphics editor

2.from file

3.from the collection of ready-made pictures

4.from the File menu

5.from the printer

Question number 11: How to print a character in a text editor that is not on the keyboard?

Choose one of the answer options:

1. Use the insertion of a symbol

2. Use drawing for this

3. Paste from special file

Question number 12: Specify the sequence of actions to be performed when inserting a formula.

Indicate the order of the answer options:

1. Select the menu item Insert

2. Click Object

3. Select MicrosoftEquation

4. Write a formula

5. Left-click in a free area of ​​the screen

Answers

"5" for 11-12 correct answers

"4" for 9-10 correct answers

"3" for 6-8 correct answers

"2" if there are 5 or less correct answers

Test 1.4.2. "Spreadsheets"

Option 1

1) Cell B1 contains the formula = 2 * $ A1... How does the formula look after cell B1 is copied to cell C2?

1) = 2 * $ B1 2) = 2 * $ A2 3) = 3 * $ A2 4) = 3 * $ B2Н

2) Given a fragment of a spreadsheet:

You entered the formula in cell D2 = A2 * B1 + C1... As a result, the value will appear in cell D2:

1) 6 2) 14 3) 16 4) 24

3) Cell A1 of the spreadsheet contains the formula = D1- $ D2... How will the formula look after cell A1 is copied to cell B1?

1) = E1- $ E2 2) = E1- $ D2 3) = E2- $ D2 4) = D1- $ E2

4) In the spreadsheet, the value of the formula = AVERAGE (A6: C6) equals ( -2 ). What is the value of the formula = SUM (A6: D6) if cell D6 is 5?

1) 1 2) -1 3) -3 4) 7

5) The figure shows a fragment of a spreadsheet. Determine what the value calculated by the following formula will equal = SUM (B1: C4) + F2 * E4 – A3

After moving the contents of cell C70 to cell C71, the value in cell D71 will change in absolute value to:

1) 2,2 2) 2,0 3) 1,05 4) 0,8

7) Given a fragment of a spreadsheet:

After performing the calculations, a chart was built using the values ​​of the range of cells A2: D2. Indicate the resulting diagram.

8) 100 teachers take part in the teleconference of teachers of physics and mathematics schools. Among them are teachers of mathematics (M), physics (F) and computer science (I). Teachers have different qualifications: each teacher either has no category at all (no category - BK), or has II, I or the highest (VK) qualification category. Chart 1 shows the number of teachers with different skill levels, while Chart 2 shows the distribution of teachers by subject.

There are 4 statements:

B) All computer science teachers can be of the highest category.

D) All mathematics teachers can have II category.

Which of these statements follows from the analysis of both presented diagrams? "

1) A 2) B 3) C 4) D

9) The diagram shows the number of test participants in different regions of Russia:

Which of the diagrams correctly reflects the ratio of the total number of test participants by region?

1)

2)

3)

4)

Practical part

Task number 1

Create a table and format it like this.

A function is simply a block of code that has a name and input parameters to process that can be executed when we need it. They might seem like little use, but trust me, when you understand and learn how to use functions, you can save tons of time and write code that is much more readable!

Although the topic of functions is often perceived as difficult for beginner programmers, you need to know them anyway. It might take a long time, but don't give up, because functions will help you a lot in your programming career.

Create your first php function

When you create a function, you must first give it a name, for example, myCompanyName. It is best to use descriptive names that make sense to avoid confusion. The same applies to.

The syntax for creating a function is pretty obvious and logical. First, you must tell PHP that you want to create a function. This can be done by entering the function keyword and your function name and a few other things (which we'll talk about a little later).

This is what the myCompanyName function declaration looks like:

Note: The function name can start with "_", but not with a number!
This is just the skeleton of our function, and inside it we can put any code we want. When the function is called, it will be executed. See the "()" in the curly braces in the above example? These brackets define where our function code should be. The opening curly brace "(" tells PHP that the function code is starting, and the closing curly brace ")" tells PHP that our function is over!

Let's add something simple to it, for example.

That's it, pretty simple, right? Now let's learn how to call our function.

Php ready function call

Now that you've finished coding the simplest function, it's time to try it out. Below is a simple script. Let's do this: declare our function and use it.

!
"; myCompanyName (); echo" Nice to see you!
";

While this was a simple example, it is important to understand that carelessness can lead to an error. When you create a function, follow these simple guidelines.

• Always start your functions with the function keyword.
• Remember that your function code must be between "(" and ")".
• When you call a function, make sure you spell the name correctly.

Functions with parameters

Another useful feature is that you can call functions with parameters, that is, pass additional information inside its code. Our first function, myCompanyName, isn't very useful, because all it can do is print the same line.

However, if we were using parameters, then we could add some extra features to our function! The parameter appears in parentheses "()" and looks like a regular PHP variable. Let's create a new function that creates a custom greeting based on the person's name, which we pass as a parameter.

"; } ?>

Now, when we call the sayHello function, the parameter (name) must be indicated in brackets, since the function is declared with a parameter and cannot be ignored.
If we want to specify several parameters, then we simply list them when declaring a function, separated by commas, and that's it, nothing else is required.

Returning value by php function

In addition to the fact that you have the ability to pass information to a function, it can also return a value itself. But remember, a function can only return one value, although it can be anything: integer, real, boolean, whatever you want!

How does it return a value? The best way to understand it is with an example. Let's declare a function with parameters, and then assign the result to some variable, like this:

"; $ myNumber = mySum (3, 4); // Save the result of calling the mySum function into the $ myNumber variable echo" After calling the function, myNumber = ". $ myNumber."
"; ?>

To assign a value to a function, a return statement is added to it, see it? The result of adding two numbers is stored in the $ total variable, and using return $ total, this value is passed to the function itself. We then simply assign it to the $ myNumber variable after calling the mySum function with the two parameters 3 and 4 (these are the numbers to be added).

Practice, figure it out and you will succeed!