Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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?

image text in transcribedDid I adress the question correctly?

image text in transcribed

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 AC

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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 Finance questions