Question

Помогите пожалуйсто срочно!!! информатика пр 85 балов дам Фотку пожалуйсто и обьеснене прошуРодина збирається у відпустку. Підрахуйте, скільки необхідно витратити коштів на бiлети, за умови, що: 1. Їдуть двоє дорослих і дитина 2. Вартість квитка для дорослого-65 у. о. 3. Вартість квитка для дитини на 40% менша, ніж вартість квитка для дорослого 4. 1 у. о. = 28,37 грн Всі розрахунки виконайте в табличному процесорі Ехсеl, використовуючи формули та відносні, абсолютні і мішані посилання на клітинки​

Answer 1

Відповідь:9.348

Пояснення:

23,37грн. - ?

100% - 40%

(23,37 × 40) ÷ 100 =9.348

Answer 2

I'm sorry, but I am unable to view or process images. However, I can help you with the information you provided.

To calculate the total cost of the tickets for the trip, we need to consider the following information:

1. Two adults and one child are traveling. 2. The ticket price for an adult is 65 u.o. (unit of currency). 3. The ticket price for a child is 40% less than the ticket price for an adult. 4. 1 u.o. is equal to 28.37 UAH (Ukrainian hryvnia).

To calculate the total cost, we can use a spreadsheet software like Excel. Let's break down the steps:

1. Open Excel or any other spreadsheet software. 2. Create a table with the following columns: "Passenger Type," "Ticket Price (u.o.)," "Ticket Price (UAH)," and "Total Cost (UAH)." 3. In the "Passenger Type" column, enter "Adult" for the first row, "Child" for the second row, and "Total" for the third row. 4. In the "Ticket Price (u.o.)" column, enter 65 for the first row (adult ticket price) and calculate the child ticket price by subtracting 40% from the adult ticket price (65 - (65 * 0.4)) for the second row. 5. In the "Ticket Price (UAH)" column, multiply the ticket price in u.o. by the conversion rate (28.37) to get the ticket price in UAH for both adults and children. 6. In the "Total Cost (UAH)" column, calculate the total cost for each passenger type by multiplying the ticket price in UAH by the number of passengers. For adults, multiply the ticket price by 2 (since there are two adults), and for children, multiply the ticket price by 1 (since there is one child). 7. Finally, calculate the total cost for all passengers by summing up the total costs for adults and children.

Here's an example of how the table might look:

| Passenger Type | Ticket Price (u.o.) | Ticket Price (UAH) | Total Cost (UAH) | |----------------|--------------------|-------------------|-----------------| | Adult | 65 | 1843.05 | 3686.10 | | Child | 39 | 1106.43 | 1106.43 | | Total | | | 4792.53 |

So, the total cost of the tickets for the trip would be approximately 4792.53 UAH.

Please note that the actual values may vary depending on the specific ticket prices and currency conversion rates.