Here's how to create a chart or graph from your data in Excel (question 1):

1. Select your data:
- Highlight the range of cells that contain the data you want to visualize in the chart.
- This includes the labels for your categories (usually in the first row or column) and the data points themselves.

2. Insert the chart:
- Go to the "Insert" tab on the Excel ribbon.
- In the "Charts" group, you'll see a variety of chart options. Excel may even recommend a chart type based on your data selection.

3. Choose your chart type:
- Consider the type of data you have and the message you want to convey when selecting a chart type.
- For comparing categories, Column Charts or Bar Charts are good choices.
- Line Charts work well for showing trends over time.
- Pie Charts are useful for representing proportions of a whole.
- Experiment with different options by hovering your mouse over each chart type to see a live preview.

4. Customize your chart (Optional):
- Once you've chosen a chart type, Excel will automatically create it based on your data.
- You can customize the chart further by clicking on different chart elements.
- This allows you to change the formatting, add data labels, edit titles, and more using the options available on the Chart Tools ribbon that appears when you click on the chart.

Here's how to use conditional formatting to highlight specific data (question 10):

Conditional formatting is a powerful tool that lets you apply formatting (like color changes, font styles, etc.) to cells based on certain conditions. This can help you quickly identify important trends or exceptions within your data.

1. Select the cells you want to format:
- Choose the range of cells where you want to apply conditional formatting rules.

2. Go to Conditional Formatting:
- Navigate to the "Home" tab on the Excel ribbon.
- In the "Styles" group, click the dropdown arrow under "Conditional Formatting."

3. Choose a formatting rule:
- Excel offers various formatting options based on different conditions. Here are some common examples:
- Highlight Cells Rules: Lets you highlight cells based on their values (e.g., greater than, less than, equal to a specific number).
- Data Bars: Applies color bars to cells where the length represents the data value.
- Color Scales: Uses color gradients to indicate variations in data values.

4. Define your condition:
- Once you choose a formatting rule, a window will appear where you can set the specific condition for applying the formatting.
- For example, if you select "Highlight Cells Rules > Greater Than," you'll need to specify the threshold value to highlight cells with values exceeding that number.

5. Apply formatting (Optional):
- Many conditional formatting rules allow you to customize the formatting applied when the condition is met.
- You can choose font colors, background fills, and other formatting options.

6. Click OK:
- Once you've defined your condition and formatting preferences, click "OK" to apply the conditional formatting rule to your selected cells.

By using conditional formatting effectively, you can make your spreadsheet more visually appealing and draw attention to important data points.