Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

119 fx A B Formatting as Table Styles Format v Filter Select D E F G H J K 1 Date 2 June 1,

image text in transcribedimage text in transcribedimage text in transcribed

119 fx A B Formatting as Table Styles Format v Filter Select D E F G H J K 1 Date 2 June 1, 2021 3 June 2, 2021 4 June 3, 2021 Product ID Product Name 4980 Rudolf DSL Modem 3665 ChromJet Inkjet Printer 4980 Rudolf DSL Modem Units Sold Sales Price Total Sales Error Table 3 $ 1 $ 142.53 $ 427.59 774.95 $ 774.95 Error # Error location (cell address, e.g., B2) Value before fixing the error Value after fixing the error 1 1 $ 142.50 $ 142.50 2 5 June 4, 2021 7709 Bell DVD Drive 12 $ 167.39 $ 2,008.68 3 6 June 5, 2021 3665 ChromoJet Inkjet Printe $ 774.95 $ 774.95 4 7 June 6, 2021 7708 Bell DVD Drive 3 $ 8 June 7, 2021 6773 Millennium PC P3 2$ 9 June 8, 2021 6773 Millennium PC P3 1 $ 2,257.00 165.40 $ 496.20 2,440.00 $ 4,880.00 $2,257.00 5 6 7 10 June 9, 2021 4877 Data Flash Modem 56K 2 $ 117.02 $ 234.04 8 11 June 10, 2021 4980 Rudolf DSL Modem -1 $ 125.70 $ (125.70) 9 12 June 11, 2021 13 June 12, 2021 14 June 13, 2021 15 June 14, 2021 16 June 15, 2020 6773 Millennium PC P3 3665 ChromJet Inkjet Printer 4877 DataFlash Modem 56K 9248 Bluelsland Laser Printe 4980 Rudolf DSL Modem 2 $ 2,503.42 $ 5,008,84 10 2 $ 760.05 $1,520.10. 2 $ 108.02 $ 216.04 1 $ 1,598.31 $1,598.31 3 $ 157.45 $ 472.35 17 June 16, 2021 18 June 17, 2021 3665 ChromoJet Inkjet Printe 6777 Millennium PC P3 4 $ 774.95 $ 3,099.80 4 $ 2,400.67 $9,602.68 19 June 18, 2021 20 June 19, 2021 21 June 20, 2021 22 June 21, 2021 23 June 22, 2021 24 June 23, 2021 25 June 24, 2021 26 June 25, 2021 4877 Data Flash Modem 56K 6773 Millennium PC P3 3665 ChromoJet Inkjet Printe 4877 Data Flash Modem 56K 4877 Blue Island Laser Print 4980 Rudolf DSL Modem 3665 ChromoJet Inkjet Printe 6777 Millennium PC P3 5 $ 119.00 $ 595.00 7 $ 2,130.95 51 $ 813.00 $ 5 $ 1,599.40 $14,916.65 $41,463.00 100.32 $ 401.28 $7,997.00 8 $ 168.10 $ 1,344.80 10 $ 813.95 $8,139.50 3 $ 2,400.67 $ 7,202.01 27 June 26, 2021 4877 DataFlash Modem 56K 1 $ 116.28 $ 116.28 28 June 27, 2020 6773 Millennium PC P3 6 $ 2,120.10 $12,720.60 29 June 28, 2021 3665 ChromoJet Inkjet Printe 2 $ 30 June 29, 2021 7708 Bell DVD Drive 9 $ 31 June 30, 2021 6773 Millennium PC P3 25 $ 813.00 $ 1,626.00 165.78 $1,492.02 2,135.00 $53,375.00 32 33 34

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

Financial and Managerial Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

13th edition

1285866304, 978-1285866307

More Books

Students also viewed these Accounting questions

Question

=+a) Compute the EV for each alternative decision.

Answered: 1 week ago