Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer on an excel spreadsheet with formula and explanations, thank you! Noah Valls Tax Advisor Income Filing Status Tax Amount Instructions: Enter an income
please answer on an excel spreadsheet with formula and explanations, thank you!
Noah Valls Tax Advisor Income Filing Status Tax Amount Instructions: Enter an income amount in B4 Enter a filing status in CA Calculate the correct tax amount using the INDEX and MATCH functions and the Tax Table worksheet Use data validation as appropriate 626 28.100 3.758 3.296 627 28.150 13.765 3.304 628 28.200 3.773 3.311 629 28.250 3.780 3.319 630 28.300 3.788 3.326 631 28.350 3.795 3.334 632 28.400 3.803 3.341 633 28.450 3.810 3.349 634 28.500 3.818 3.356 635 28.550 3.825 3.364 636 28.600 3.833 3.371 637 28.650 13.840 3.379 638 26.700 3.848 3.386 639 26.750 3.855 3.394 640 26.800 3.863 3.401 641 26.850 3.870 3.409 642 26.900 3.878 3.416 643 28.950 3.885 3.424 644 29.000 3.893 3.431 545 29.050 3.900 3.4.39 546 29.100 3.908 3.446 647 29.150 3.915 3.454 648 29,200 3.923 3.461 649 29.250 3.930 3.469 650 29.300 3.938 3.476 651 29.350 3.945 3.484 652 29.400 3.953 3.491 553 29.450 3.960 3.499 654 29.500 3.968 3.506 655 29.550 3.975 3.514 656 29.600 3.983 3.521 657 29.650 3.990 3.529 658 29.700 3.996 3.536 659 29.750 4.005 3.544 660 29.800 4.013 3.551 661 29.850 4.020 3.559 662 29.900 4.028 3.566 663 29.950 4.035 3.574 664 30.000 4.043 3.581 665 30.050 4.050 3.59 666 30.100_4.058 3.596 667 30.150 4.065 3.604 568 30.200 4.073 3.611 669 30.250 4.080 3.619 70 30.300 4.088 3.626 671 30.350 4.095 3.634 672 30.400 4.103 3.541 673 30.450 4.110 3.649 3.758 3.765 3773 3.780 3.788 3.795 3.803 3.810 3.818 3.825 3.823 3.840 3.848 3.855 3.863 3.870 3.878 3.885 3.893 "3.900 3.908 3.915 3.923 3.930 3.938 3.945 3.953 3.960 3.968 3.975 3.983 3.990 3.996 4.005 4.013 4.020 4.028 4.035 4.043 4.050 4.058 4.065 4.073 4.080 4.088 4.095 4.103 4.110 3.561 3.569 3.576 3.564 3.591 3.599 3.606 3.614 3.621 3.629 3.636 3.644 3.651 3.69 3.66 3.674 3.681 3.68 3.696 3.704 3.711 3.719 3.726 3.734 3.741 3.749 3.756 3.764 3.771 3.779 3.786 3.794 3.801 3.809 3.816 3.824 3.831 3.839 3.846 3.854 3.861 3.869 3.876 3.884 3.891 3.899 3.906 3.914 Noah Valls Tax Advisor Income Filing Status Tax Amount Instructions: Enter an income amount in B4 Enter a filing status in CA Calculate the correct tax amount using the INDEX and MATCH functions and the Tax Table worksheet Use data validation as appropriate 626 28.100 3.758 3.296 627 28.150 13.765 3.304 628 28.200 3.773 3.311 629 28.250 3.780 3.319 630 28.300 3.788 3.326 631 28.350 3.795 3.334 632 28.400 3.803 3.341 633 28.450 3.810 3.349 634 28.500 3.818 3.356 635 28.550 3.825 3.364 636 28.600 3.833 3.371 637 28.650 13.840 3.379 638 26.700 3.848 3.386 639 26.750 3.855 3.394 640 26.800 3.863 3.401 641 26.850 3.870 3.409 642 26.900 3.878 3.416 643 28.950 3.885 3.424 644 29.000 3.893 3.431 545 29.050 3.900 3.4.39 546 29.100 3.908 3.446 647 29.150 3.915 3.454 648 29,200 3.923 3.461 649 29.250 3.930 3.469 650 29.300 3.938 3.476 651 29.350 3.945 3.484 652 29.400 3.953 3.491 553 29.450 3.960 3.499 654 29.500 3.968 3.506 655 29.550 3.975 3.514 656 29.600 3.983 3.521 657 29.650 3.990 3.529 658 29.700 3.996 3.536 659 29.750 4.005 3.544 660 29.800 4.013 3.551 661 29.850 4.020 3.559 662 29.900 4.028 3.566 663 29.950 4.035 3.574 664 30.000 4.043 3.581 665 30.050 4.050 3.59 666 30.100_4.058 3.596 667 30.150 4.065 3.604 568 30.200 4.073 3.611 669 30.250 4.080 3.619 70 30.300 4.088 3.626 671 30.350 4.095 3.634 672 30.400 4.103 3.541 673 30.450 4.110 3.649 3.758 3.765 3773 3.780 3.788 3.795 3.803 3.810 3.818 3.825 3.823 3.840 3.848 3.855 3.863 3.870 3.878 3.885 3.893 "3.900 3.908 3.915 3.923 3.930 3.938 3.945 3.953 3.960 3.968 3.975 3.983 3.990 3.996 4.005 4.013 4.020 4.028 4.035 4.043 4.050 4.058 4.065 4.073 4.080 4.088 4.095 4.103 4.110 3.561 3.569 3.576 3.564 3.591 3.599 3.606 3.614 3.621 3.629 3.636 3.644 3.651 3.69 3.66 3.674 3.681 3.68 3.696 3.704 3.711 3.719 3.726 3.734 3.741 3.749 3.756 3.764 3.771 3.779 3.786 3.794 3.801 3.809 3.816 3.824 3.831 3.839 3.846 3.854 3.861 3.869 3.876 3.884 3.891 3.899 3.906 3.914 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