I would love some help on how to do this problem! (iii) In the...

90.2K

Verified Solution

Question

Accounting

imageimage

I would love some help on how to do this problem!

(iii) In the third column, copy and paste the values from column 2 into column 3. Paste these as values so they remain static. (Hint: They will not match column 2 when you do anything new in the spreadsheet, and that is OK). Label this column Value2. 2 pts B2 X fx =RANDBETWEEN(200,860) A B D E F 1 (Value2) 2 3 (ID) 000 001 4 0021 003 004 005 0061 5 6 7 8 9 10 11 12 13 0071 0081 14 (Value1) 700 568 227! 518 596 390 686! 3831 7681 463 714 6291 3487 683 580 809! 5241 2751 486 507! 3341 6321 770 724! 756! 3111 326 15 009 010! 0111 012 013 014! 0151 0161 017 018 019! 020 16 17 18 19 20 21 22 23 24 0211 022 023! 0241 025 026 807 027 028! 25 26 27 28 29 30 31 32 33 34 35 36 0291 030 031 695 7281 6011 615 825 827! 5471 032! 033! 0341

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students