Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Did I adress the question correctly? 5. What is the quantity of the books that you can purchase if the pencils cost changes to $1.25?
Did I adress the question correctly?
5. What is the quantity of the books that you can purchase if the pencils cost changes to $1.25? a. Take a screen shot of the screen with the Goal Seek dialog box visible Click cancel to exit the Goal Seek dialog b. c. Paste the screen shot in worksheet Q4 9 0 1 2 3 4 5 6 7 8 9 20 1 2 3 4 5 6 27 28 19 30 1 2 3 4 35 36 7 A B Goal Seeker Example D Item Pens Pencils 20 $ Books 2.08333333 $ Quantity Price Amout Due 10 $ 0.30 $ 3.00 0.50 $ 0.60 $ 10.00 1.25 Total $ 14.25 E F G H 1 J Goal Seek Status Goal Seeking with Cell D7 found a solution. Target value: 1.25 Current value: $1.25 K OK ? L X Step Pause Cancel M N 0 P Q R S T U V W X Y Z AA AB ACStep 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