Question

5. 3 Utilizar Excel para confeccionar la siguiente tabla: B 4 HOTELES 5 Ciudad de Vigo 6 Hospedería Hotel 7 Gran Hotel Samil 8 Lisboa 9 Residencia Ensenada 10 C CATEGORÍA (estrellas) PRECIO T + I 5 4 3 2 1 1 I D I t E HAB. DOBLE IVA F TOTAL G INDIVIDUAL I TOTAL ↓ I I El precio por habitación doble es igual a 2500 Pts por cada estrella del hotel. Se aplica un IVA del 16%. El precio de la habitación individual es la mitad que el precio total de la doble. Los resultados se deben expresar en peset

​

Answer 1

to create the given table in Excel, you can follow these steps:

1. Open Microsoft Excel on your computer.

2. In the first row, enter the column headings as shown in the table: "HOTELES", "Ciudad de Vigo", "Hospedería Hotel", "Gran Hotel Samil", "Lisboa", "Residencia Ensenada".

3. In the second row, enter the category (estrellas) values: 5, 4, 3, 2, 1, 1.

4. In the third row, enter the precio T + I values: This part is missing in the question, so you would need to provide the specific values for each hotel.

5. In the fourth row, enter the column headings "HAB. DOBLE", "IVA", "F TOTAL", "G INDIVIDUAL", "I TOTAL".

6. Now, based on the given instructions, calculate the values for each cell in the table. For example, the price for a double room can be calculated by multiplying the number of stars (estrellas) by 2500 Pts.

7. Apply the 16% IVA (VAT) to calculate the IVA value.

8. Calculate the total price for the double room (F TOTAL).

9. Calculate the price for the individual room, which is half the total price of the double room (G INDIVIDUAL).

10. Finally, calculate the total price for the individual room (I TOTAL).

Remember to format the cells appropriately and adjust the formulas based on the specific values provided in the question.

Step-by-step explanation: