How do I format a spreadsheet with bold headers, borders, adjusted column widths, and centered numerical data, and add a merged title?

Here are the steps to complete the spreadsheet tasks:

• Step 1: Open the spreadsheet file named "Production Record" from your student's folder.

• Step 2: Format the worksheet:

  • To bold all column headers: Select the row containing the column headers (e.g., A1:H1 if your headers are in the first row), then click the "Bold" button (B) in the Font group on the Home tab.
  • To apply borders to the entire table: Select the entire range of cells that constitute your table. On the Home tab, in the Font group, click the "Borders" dropdown arrow and choose "All Borders".
  • To adjust column widths appropriately: Select all columns in your table. Double-click the boundary between any two column headers (e.g., between A and B). Excel will auto-fit the column widths to the widest content.
  • To centre-align all numerical values: Select all cells containing numerical data. On the Home tab, in the Alignment group, click the "Centre" alignment button.

• Step 3: Insert a new row above the table and type the title: "WEEKLY MACHINE PRODUCTION REPORT".

  • Right-click on the row header for the first row (e.g., row 1), then select "Insert". A new blank row will appear.
  • Type "WEEKLY MACHINE PRODUCTION REPORT" into cell A1.

• Step 4: Using the Merge and Centre function, adjust the title so that it spans the first eight columns of the worksheet.

  • Select the cells from A1 to H1 (assuming your table starts in column A and has 8 columns).
  • On the Home tab, in the Alignment group, click the "Merge & Centre" button.

• Step 5: In cell G3, enter a formula to calculate the total weekly production of machine M1. Apply the formula to calculate totals for M2, M3, and M4.

  • Assuming M1's daily production values are in cells B3 through F3, the formula in G3 would be: $$=\text{SUM(B3:F3)}$$
  • To apply this to M2, M3, and M4, click on cell G3, then drag the fill handle (the small square at the bottom-right corner of the cell) downwards to the corresponding rows for M2, M3, and M4.

• Step 6: In cell H3, enter a formula to calculate the weekly average production of M1. Copy the formula down for the remaining machines.

  • Assuming M1's daily production values are in cells B3 through F3, the formula in H3 would be: $$=\text{AVERAGE(B3:F3)}$$
  • To copy this for M2, M3, and M4, drag the fill handle of cell H3 downwards.

• Step 7: In cell B7, enter a formula to calculate the total daily production of all machines for Monday. Copy the formula across to calculate totals for Tuesday to Friday.

  • Assuming Monday's production values for all machines are in cells B3 through B6, the formula in B7 would be: $$=\text{SUM(B3:B6)}$$
  • To copy this for Tuesday to Friday, drag the fill handle of cell B7 horizontally to the right to the corresponding columns for Tuesday to Friday (e.g., to F7).

• Step 8: In cell I3, enter a conditional formula such that:

  • Display "Target met" if total weekly production > 600.

  • Otherwise display "Below target".

  • Then copy the formula down to the other machines.

  • The formula in I3 (assuming total weekly production for M1 is in G3) would be:

    $$=\text{IF(G3 > 600, "Target met", "Below target")}$$

  • Copy this formula down by dragging the fill handle of cell I3 downwards.

  • Apply conditional formatting:

    • To apply Green fill for "Target met": Select the range of cells where you entered the formula (e.g., I3:I6). On the Home tab, in the Styles group, click "Conditional Formatting" -> "Highlight Cells Rules" -> "Text that Contains...". Type "Target met" and choose "Green Fill with Dark Green Text" (or a custom green fill).
    • To apply Red fill for "Below target": With the same range selected, click "Conditional Formatting" -> "Highlight Cells Rules" -> "Text that Contains...". Type "Below target" and choose "Light Red Fill with Dark Red Text" (or a custom red fill).

• Step 9: Print the formatted worksheet. (Go to File -> Print and select your printer).

• Step 10: Create a suitable chart that clearly compares the weekly production of the four machines. Ensure the chart has an appropriate title and labelled axes.

  • Select the machine names (e.g., A3:A6) and their corresponding total weekly production values (e.g., G3:G6).
  • Go to the "Insert" tab, in the "Charts" group, select a suitable chart type, such as a "Clustered Column" or "Bar" chart.
  • Once the chart is created, click on the chart title and type an appropriate title, e.g., "Weekly Production Comparison of Machines".
  • Click on the chart elements (the "+" sign next to the chart) and ensure "Axis Titles" are checked. Edit the axis titles to "Machine" for the horizontal axis and "Total Weekly Production" for the vertical axis.

• Step 11: Print the worksheet including the chart. (Go to File -> Print. Ensure the print settings include the chart).

• Step 12: Save the work using your student ID. (Go to File -> Save As, navigate to your folder, and enter your student ID as the filename).