Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Laurel works at a local office store. Since the holiday season is coming up, she would like to apply a discount to some of the

Laurel works at a local office store. Since the holiday season is coming up, she would like to apply a discount to some of the items in the store. She has entered the following formula into cell E2. However, when she tries to calculate the discounted price and use the fill handle, she gets some strange values. How can she fix the problem?

image text in transcribedAbsoluteReferenceReverse.PNG Cell E2 needs to be an absolute reference within the formula The formula should be switched to: (E2-$C$2) a. She needs to remove the absolute reference in the formula She must use the SUBTRACT function

Laurel works at a local office store. Since the holiday season is coming up, she would like to apply a discount to some of the items in the store. She has entered the following formula into cell E2. However, when she tries to calculate the discounted price and use the fill handle, she gets some strange values. How can she fix the problem? Cell E2 needs to be an absolute reference within the formula The formula should be switched to: (E2-\$C\$2) a. She needs to remove the absolute reference in the formula She must use the SUBTRACT function

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

Recommended Textbook for

Mathematics Of Finance

Authors: Robert Brown, Steve Kopp, Petr Zima

8th Edition

0070876460, 978-0070876460

More Books

Students also viewed these Finance questions

Question

5. Explain how to install a performance management program.

Answered: 1 week ago