Answered step by step
Verified Expert Solution
Link Copied!

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 $50,000 but less than $100,000, and the family has one child, they pay a federal tax of 17% 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 =C4*IF(B4=0,VLOOKUP(C4,$F$4:$I$8,2),IF(B4=1 or 2,VLOOKUP(C4,$F$4:$I$8,3),VLOOKUP(C4,$F$4:$I$8,4))) in cell D4 and copy it down.
b. Enter the formula =C4*VLOOKUP(C4,$F$4:$I$8,IF(B4=0,2,IF(B4<=2,3,4))) in cell D4 and copy it down.
c. Enter the formula =C4*IF(B4=0,VLOOKUP(C4,$F$4:$I$8,1),IF(B4<=2,VLOOKUP(C4,$F$4:$I$8,2),VLOOKUP(C4,$F$4:$I$8,3))) in cell D4 and copy it down.
d. None of these choices are correct.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Be able to perform a feasibility analysis.

Answered: 1 week ago

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago

Question

Identify and control your anxieties

Answered: 1 week ago

Question

Understanding and Addressing Anxiety

Answered: 1 week ago