Answer :
On the Orchestra Composition worksheet, added sort and filter buttons to B2:C25, centered data labels in the chart. On the Schedule worksheet, used functions for cell counts and copied formatting.
To add sort and filter buttons to range B2:C25 on the Orchestra Composition worksheet, follow these steps:
1. Select range B2:C25.
2. Go to the "Data" tab on the Excel ribbon.
3. Click on "Filter" in the "Sort & Filter" group.
This will add sort and filter buttons to the top row of the selected range.
To add center data labels to the chart on the Orchestra Composition worksheet, follow these steps:
1. Click on the chart to select it.
2. Go to the "Chart Tools" tab on the Excel ribbon.
3. Click on "Format" in the "Chart Tools" group.
4. In the "Current Selection" group, click on "Chart Elements" dropdown.
5. Select "Data Labels" and then "Center".
This will center the data labels in the chart.
To show the number of non-blank cells in the Location column (column C) in cell C28 on the Schedule worksheet, you can use the COUNTA function. Here's how:
1. Click on cell C28.
2. Enter the formula: =COUNTA(C2:C25)
3. Press Enter.
This will count the number of non-blank cells in the Location column.
To show the number of blank cells in the Location column (column C) in cell C29 on the Schedule worksheet, you can subtract the count of non-blank cells from the total count of cells. Here's how:
1. Click on cell C29.
2. Enter the formula: =COUNTA(C2:C25)-COUNTA(C2:C25)
3. Press Enter.
This will count the number of blank cells in the Location column.
To copy the formatting from cell B28 to cell B29 without changing the contents of either cell, follow these steps:
1. Click on cell B28 to select it.
2. Press Ctrl+C to copy the cell.
3. Click on cell B29 to select it.
4. Right-click on cell B29 and select "Paste Special".
5. In the "Paste Special" dialog box, choose "Formats".
6. Click OK.
This will copy the formatting from cell B28 to cell B29.
The Correct Question is:
On the Orchestra Composition worksheet, add a feature to B2:C25 that gives the top row sort and filter buttons that affect the rest of the data. On the Orchestra Composition worksheet, add Center data labels to the chart. On the Schedule worksheet, use a function in C28 to show the number of cells in the Location column that are not blank. On the Schedule worksheet, use a function in C29 to show the number of blank cells in the Location column. On the Schedule worksheet, copy the formatting from B28 onto B29 without changing the contents of either cell.
