To analyze the data and perform the required tasks in Excel, you can follow these step-by-
step commands:
Step 1: Open Excel and load the file containing the data.
Step 2: Rename the sheets if desired. For example, you can rename "Sheet1" to "Electricity
Data" and "Sheet2" to "Natural Gas Data."
Step 3: Ensure consistent formatting:
- Select the range of cells containing the data (excluding headers).
- Right-click and choose "Format Cells."
- In the "Format Cells" dialog box, adjust formatting options like font, alignment, and
number format to ensure consistency.
- Click "OK" to apply the formatting.
Step 4: Calculate values using conversion factors:
- Locate the column headings indicating the conversion factors for Net CV.
- In a new column, use Excel formulas to multiply the corresponding energy consumption
values by the conversion factors.
- Repeat this process for all necessary columns.
Step 5: Identify exceptional or potentially incorrect values:
- Examine the monthly totals and consider any values that seem unusually high or low.
- Apply conditional formatting to highlight these values:
- Select the range of cells containing the monthly total values.
- Go to the "Home" tab, click on "Conditional Formatting," and choose "Highlight Cells
Rules" -> "Greater Than" or "Less Than" based on the criteria.
- Enter the threshold value to identify exceptional or potentially incorrect values.
- Choose a formatting style to highlight the cells.
Step 6: Save the file with the changes.
By following these steps, you can ensure consistent formatting, calculate values using
conversion factors, and identify exceptional or potentially incorrect values in the Excel data.
