143k views
3 votes
Use a function to make K4 show the average number of Pecan Pies sold throughout the week.

This question is Reguarding Microsoft Excel and i have used the average function but it gets labeled as incorrect

Use a function to make K4 show the average number of Pecan Pies sold throughout the-example-1
User Rusly
by
9.0k points

1 Answer

4 votes

Final answer:

To calculate the average number of Pecan Pies sold in a week in Excel, use the AVERAGE function on the range of cells that contain the daily sales data. If it's marked incorrect, check the cell range, eliminate empty or text cells, ensure correct format, and review assignment criteria.

Step-by-step explanation:

To calculate the average number of Pecan Pies sold throughout the week in Microsoft Excel, you'll want to use the AVERAGE function. This function calculates the mean of the numbers provided. For simplicity, let's say the number of Pecan Pies sold from Monday to Sunday are in cells A1 through A7. You would enter the following formula into cell K4: =AVERAGE(A1:A7)

Press Enter after typing this formula, and Excel will display the average in cell K4. However, if you've already tried this and it's been marked as incorrect, there may be a few reasons why:

  • Ensure that there are no mistakes in the range selected; it should include all days you want to calculate the average for.
  • Check for any empty cells or text entries in the range, as this can cause errors in calculation.
  • Verify that you are not including the title of the column in your range.
  • Make sure the cells actually contain numbers and have not been formatted incorrectly, making them appear as text.

Once you've double-checked these points, try entering the formula again. If you continue to encounter issues, there may be specific instructions or formatting requirements you need to follow based on your assignment's criteria, so be sure to review these closely.

User Javier Conde
by
7.8k points