Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

2. The data section called Transaction Growth shows how many clothing sets were sold each month. Felicia entered a formula into the range o6:010 to

image text in transcribed

image text in transcribed

2. The data section called Transaction Growth shows how many clothing sets were sold each month. Felicia entered a formula into the range o6:010 to calculate the highest amount of each set sold over the course of the year. She notices that all of the values in the range are 2,146, even though more clothing sets than this were sold in some months. Edit the formula in cell 06 so that it uses relative references instead of absolute references for the range B6:M6, and then copy the formula from cell 6 to fill the range 07:010 without formatting. File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Comm Define Name Trace Precedents Show Formulas Calculate Now ame Use in Formula Manager Trace DependentsError Checking Insert AutoSum Recently Financial Logical Text Date & Lookup &Math & Trig . More Functions . Watch Calculation "Calculate Sheet Used- Time-Reference . Create from Selection Remove Arrows Evaluate Formula Window Options Function Library Defined Names Formula Auditing Calculation P6 6 Bizzy Caz 24 387 451 558 1057 1479 9 1909 2146 1793 1142 832 843 809 12742 5349 1539 9785 2146 [High Society 8 Retro Fit 9 Weekend Wanderer 348 10 Total Orders 237 214 214 1107 516 628 2146 1003 1269 1073 1699 1849 1759 1897 2872 3733 3209 3329 2639 2731 3066 29415 32 Average Monthly 12 Fulfillment

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_2

Step: 3

blur-text-image_3

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

Visual Basic6 Database Programming

Authors: John W. Fronckowiak, David J. Helda

1st Edition

0764532545, 978-0764532542

More Books

Students explore these related Databases questions

Question

9. Describe the characteristics of power.

Answered: 3 weeks ago