6 3.6 Chapter Assessment
The following are sample questions to test whether you know, understand, and are able to apply your learning from this chapter.
3. Based on Figure 2.3 and the Budget Detail sheet, what is the Monthly Spend amount for Entertainment if the Annual Spend is $2,200?
4. Based on Figure 2.6 and the Budget Detail sheet, which of the following is the best formula to calculate the Percent Change for Clothes?
5. Based on Figure 2.6 and the Budget Detail sheet, what is the Percent Change for Taxes if the Annual Spend is $4,450?
6. Based on Figure 2.6 and the Budget Detail sheet, which function will return the Average Spend?
7. Based on Figure 2.6 and the Budget Detail sheet, what is the range reference to return the Mininum Annual Spend?
8. Based on Figure 2.6 and the Budget Detail sheet, what is the best formula to return the average Average Annual Spend?
9. What percentage of the LY Spend Total was the Clothes category?
10. Based on the Budget Details sheet, what is the best formula to return the percentage of the LY Spend Total for the Insurance category?
ATTRIBUTION
Media Attributions
- Ch2 Data File