Please do it by excel **13.3 Computing Ideal Gas Volume**Create a user-written function that will compute the volume of an ideal gas when the absolute temperature, the absolute pressure, the number of moles, and an ideal gas constant are passed into the function as arguments. Use your function to complete Table 13.3P.**Table 13.3P Ideal Gas Volume**| Temperature | Pressure | Moles | Gas Constant | Volume ||-------------|----------|-------|-----------------------|--------|| 273 K | 1 atm | 1 gmol| 0.08206 L·atm/(gmol·K)| || 500 K | 1 atm | 1 gmol| 0.08206 L·atm/(gmol·K)| || 273 K | 10 atm | 1 gmol| 0.08206 L·atm/(gmol·K)| || 273 K | 1 atm | 10 gmol| 0.08206 L·atm/(gmol·K)| || 500 K | 1 atm | 10 gmol| 0.08206 L·atm/(gmol·K)| || 500 °R | 1 atm | 1 lbmol| 0.7302 ft³·atm/(lbmol·°R)| |*Note:* Complete the table by calculating the volume for each row using the ideal gas law \( PV = nRT \), where:- \( P \) is absolute pressure- \( V \) is the volume- \( n \) is the number of moles- \( R \) is the gas constant- \( T \) is absolute temperatureEnsure to convert units appropriately where necessary (e.g., for °R and lbmol). **Educational Content on Ideal Gas Computation**### TableThe table provides data for calculating the volume of an ideal gas under different conditions:| Temperature | Pressure | Moles | Gas Constant ||-------------|----------|-------|---------------|| 273 K | 1 atm | 10 gmol | 0.08206 L atm / (gmol K) || 500 K | 1 atm | 10 gmol | 0.08206 L atm / (gmol K) || 500 °R | 1 atm | 1 lbmol | 0.7302 ft³ atm / (lbmol °R) |### InstructionsCreate a macro (either by recording or by programming) that will compute the volume of an ideal gas when given the absolute temperature, the absolute pressure, the number of moles, and an ideal gas constant. Use your macro to complete Table 13.3P.**Note:** Determine the units of volume for each row of the table.### Section 13.4: Computing Gas Heat CapacityThis section introduces standard equations for calculating the heat capacity (specific heat) of a gas at a specified temperature. One common form of a heat capacity equation is a simple third-order polynomial in \(T\). Equation Reference: \( (13.6) \)--- This content is designed to guide students through the process of macro creation and understanding the practical application of the ideal gas law in calculating volume, as well as providing a basic understanding of gas heat capacity equations.

The macro function in excel automates the calculations. This can be run as per your requirement. This macro records the mouse clicks and keyboard commands by which it completes its tasks. Here, this macro function is used for calculating the volumes.We will prepare an excel sheet for given data insert all the important formulas to macro and run the sheet we are getting the desired results. We will calculate volume from the Ideal gas equation PV=nRTV=nRTP Pressure, temperature number of moles and gas constant and prepare an excel sheet The macro will calculate the volumes Steps in Excel Go to Developer Tab and click Record Macro Record macro window will open Give a name to record a macro in the macro name tab The record will start and do the volume calculations by giving formula in excel and here I gave example for the first cell and similarly make formula for the remaining cells After calculation, click Stop recording Now we will test the macro by running it First, delete the values in volume cells Click on "Macros" and select the name we have given at the starting. Click on "Run" Again the volume cells have the same answers and the results are the same. Final answers We calculated volumes with help of macro function in excel