Question

Excel 1.В ячейке A4 записать число х, в ячейку B число y (см. табл. вариантов). Используя логические функции проверить, принадлежит ли оно отрезку [4,9]. Если принадлежит, то в ячейке В5 должен выводится текст: «Принадлежит». Если не принадлежит, то в ячейке В5 должен быть текст: «Не принадлежит». 2.Вычислите значение (у-х) в ячейке А7. Если оно отрицательное, в ячейке В7 вычислите x2, если положительное –y2. 3.Если значения х и у оба положительны, в ячейке С5 вычислите их сумму, если оба отрицательны, в ячейке С5 вычислите модуль их разности, если одно из них отрицательно, в ячейке С5 вычислите сумму их модулей. 4.Если сумма х и у больше 45 или их разность меньше 12, в ячейке D3 вычислите их произведение, в противном случае, в ячейке D3 вычислите сумму их квадратов. 5.Торговый агент получает процент от суммы совершённой сделки. Если объем сделки до 3000, то 5%; если объём до 10000, то 2%; если выше 10000, то 1,5%. Введите в ячейку А10 текст «Объем сделки», в ячейку А11 – «Размер вознаграждения». В ячейку В10 введите объём сделки, а в В11 – формулу, вычисляющую размер вознаграждения. 6.Покажите на 3-х примерах как работают функции даты и времени (можно использовать любые функции данной категории). 7.Покажите на 3-х примерах как работают текстовые функции (можно использовать любые функции данной категории). 8.Заполните любыми числами блок К4:L12. Посчитайте среднее значение этого диапазона ячеек, используя соответствующую статистическую функцию.

Answer 1

Ответ:

ответ ответ таков как оков жопов

Answer 2

Task 1: Checking if a number belongs to the interval [4,9]

To check if a number belongs to the interval [4,9], you can use logical functions in Excel. Here's how you can do it:

1. In cell A4, enter the number "x". 2. In cell B4, enter the number "y". 3. In cell B5, enter the following formula: `=IF(AND(B4>=4, B4<=9), "Принадлежит", "Не принадлежит")`.

The formula uses the `IF` function along with the `AND` function to check if the number in cell B4 is between 4 and 9. If it is, the formula will display "Принадлежит" (which means "Belongs") in cell B5. If it is not, the formula will display "Не принадлежит" (which means "Does not belong") in cell B5.

Task 2: Calculating the value of (y-x) in cell A7

To calculate the value of (y-x) in cell A7 and perform additional calculations based on its sign, you can use the following steps:

1. In cell A7, enter the formula: `=B4-A4`. 2. In cell B7, enter the following formula: `=IF(A7<0, A4^2, -B4^2)`.

The formula in cell A7 calculates the difference between the values in cells B4 and A4. The formula in cell B7 uses the `IF` function to check if the value in cell A7 is negative. If it is, it calculates the square of the value in cell A4. If it is positive, it calculates the square of the negative value in cell B4.

Task 3: Performing calculations based on the signs of x and y

To perform calculations based on the signs of x and y and display the result in cell C5, you can use the following steps:

1. In cell C5, enter the following formula: `=IF(AND(A4>0, B4>0), A4+B4, IF(AND(A4<0, B4<0), ABS(A4-B4), ABS(A4)+ABS(B4)))`.

The formula uses the `IF` function along with the `AND` function to check the signs of the values in cells A4 and B4. If both values are positive, it calculates their sum. If both values are negative, it calculates the absolute difference between them. If one of the values is negative, it calculates the sum of their absolute values.

Task 4: Performing calculations based on the sum and difference of x and y

To perform calculations based on the sum and difference of x and y and display the result in cell D3, you can use the following steps:

1. In cell D3, enter the following formula: `=IF(OR(SUM(A4,B4)>45, ABS(A4-B4)<12), A4*B4, A4^2+B4^2)`.

The formula uses the `IF` function along with the `OR` function to check if the sum of the values in cells A4 and B4 is greater than 45 or if the absolute difference between them is less than 12. If either condition is true, it calculates their product. If neither condition is true, it calculates the sum of their squares.

Task 5: Calculating the size of a commission based on the transaction volume

To calculate the size of a commission based on the transaction volume and display the result in cell B11, you can use the following steps:

1. In cell A10, enter the text "Объем сделки". 2. In cell A11, enter the text "Размер вознаграждения". 3. In cell B10, enter the transaction volume. 4. In cell B11, enter the following formula: `=IF(B10<=3000, B10*0.05, IF(B10<=10000, B10*0.02, B10*0.015))`.

The formula uses the `IF` function to check the transaction volume in cell B10. If it is less than or equal to 3000, it calculates 5% of the transaction volume. If it is less than or equal to 10000, it calculates 2% of the transaction volume. If it is greater than 10000, it calculates 1.5% of the transaction volume.

Task 6: Examples of date and time functions

Here are three examples of how date and time functions can be used in Excel:

1. To display the current date, you can use the `TODAY()` function. For example, entering `=TODAY()` in a cell will display the current date. 2. To calculate the number of days between two dates, you can use the `DAYS()` function. For example, entering `=DAYS(A1, A2)` in a cell will calculate the number of days between the dates in cells A1 and A2. 3. To add a specific number of days to a date, you can use the `DATE()` function. For example, entering `=DATE(2023, 12, 31) + 7` in a cell will add 7 days to December 31, 2023.

Task 7: Examples of text functions

Here are three examples of how text functions can be used in Excel:

1. To concatenate two or more text strings, you can use the `CONCATENATE()` function or the `&` operator. For example, entering `=CONCATENATE("Hello", " ", "World")` or `"Hello" & " " & "World"` in a cell will display "Hello World". 2. To extract a specific number of characters from a text string, you can use the `LEFT()`, `RIGHT()`, or `MID()` functions. For example, entering `=LEFT("Hello World", 5)` in a cell will display "Hello". 3. To convert text to uppercase or lowercase, you can use the `UPPER()` or `LOWER()` functions. For example, entering `=UPPER("hello")` in a cell will display "HELLO".

Task 8: Calculating the average value of a range of cells

To calculate the average value of a range of cells, you can use the `AVERAGE()` function. Here's how you can do it:

1. Fill the range of cells K4:L12 with any numbers. 2. In a cell of your choice, enter the formula `=AVERAGE(K4:L12)`.

The formula will calculate the average value of the numbers in the range K4:L12 and display the result in the cell where the formula is entered.

Please note that the search results provided by You.com did not provide specific information related to the tasks. The instructions provided above are based on general knowledge of Excel functions and formulas.