Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following worksheet, where some of the rows have been hidden. The tax table indicates the tax rates on adjusted gross income for a
Consider the following worksheet, where some of the rows have been hidden. The tax table indicates the tax rates on adjusted gross income for a fictional country. In this country, the tax rate depends not only on the family's adjusted gross income, but also on the number of children in the family. For example, if a family's adjusted gross income is at least $ but less than $ and the family has one child, they pay a federal tax of of their entire adjusted gross income. To calculate the federal tax for each family, you could do which of the following?
a Enter the formula CIFBVLOOKUPC$F$:$I$IFB or VLOOKUPC$F$:$I$VLOOKUPC$F$:$I$ in cell D and copy it down.
b Enter the formula CVLOOKUPC$F$:$I$IFBIFB in cell D and copy it down.
c Enter the formula CIFBVLOOKUPC$F$:$I$IFBVLOOKUPC$F$:$I$VLOOKUPC$F$:$I$ in cell D and copy it down.
d None of these choices are correct.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started