Working in Microsoft Excel
The task 1.1 .Create the "Rest (in quantity and amount) turnover" in MS Excel, based on the tables 1-4.2ndApply data verification (the check of input values).ThreeUse the mathematical function of SUMMESLI in forming final values in the circulatory knowledge.Table 1 - Data for filling in the first three lists of the MS Excel bookSuppliersCustomersContact pointsOECD "Milk Factory"I.P. Shyriyev B.D.Store 1OOO “Milk and Cheese” IP Shketkin A.A.Magazin 2OOO “Pticefabrika” IP Yakovlev N.The store 2
Table 2 - Data for filling the fourth list of the MS Excel bookName PriceEdd.ism.QuantityMilk whole55l1Milk normalized45l2Kefir de-fated32l2Create 5%120kg.1Egg chicken49up.2
Table 3 - Data for filling in the fifth list of the MS Excel Book Name Date No. Additional Supplier Account Point Ed.ism.Col-in Price Price Milk Total 24.04.2021 269 LLC "Milk Factory" Store 1 l 5 55 275 Milk Total 24.04.2021 65 LLC "Milk and Cheese" Store 2 l 6 55 330 Milk Normalized 24.04.2021 147 LLC "Milk Factory" Store 2 l 8 45 360 Milk Normalized 24.04.2021 234 LLC "Milk and Cheese" Store 2 l 8 45 360 Producer 5% 24.04.2021 102 LLC "Milk and Cheese" Store 1 kg 5 120 600 Eggs 24.04.2021 110 LLC "Pty Factory" Store 3 ups 10 49 90
Table 4 - Data for filling in the sixth list of the MS Excel Book Name Date Number of the Buyer Account Point Ed.ism.Col-vo Price Price Milk Total 24.04.2021 78 IP Breadths B.by D.Store 1 l 5 65 325 Milk whole 25.04.2021 79 IP Shketkin A.and A.Store 2 l 6 65 390 Milk normalized 25.04.2021 80 IP Shyriyev V.by D.Shop 2 l 7 52 364 Milk normalized 25.04.2021 81 IP Yakovlev N.by G.Shop 2 l 7 52 364 Tvorog 5% 24.04.2021 82 IP Shiryaev V.by D.Store 1 kg 4 130 520 Eggs 24.04.2021 83 IP Yakovlev N.by G.Shop 3 UPS 5 52 260
Applications 2
-
419 13 0 Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.
-
613 7 1 I know Excel perfectly.
I wrote in a comment on another project about 1C.
If you choose me as an executive in both projects, we can agree.
Price for one hour of work.
-
5332 221 1 1 Hello to you.
Ready to start work today.
I will be happy with cooperation.
-
2138 75 0 Good day ! I am happy to complete your task, ready tomorrow at 9:00 to give the result.
-
130 Good day
The beginner freelancer.
I will work for you at a minimum price and reward.
-
345 22 0 Good day . Interested in the task. I will be happy to cooperate. Turn to
-
1652 43 0 Good day !
I am pleased to fulfill your task, ready to give up your task tonight or tomorrow until 12:00
-
3615 113 7 1 Good day
I have done such a task, there is a solution.
Ready to implement the project.
Current freelance projects in the category Technical Documentation
Translation, editing, and layout of brochures/instructions
223 USD
Looking for a performer for comprehensive work with brochures and instructions. Required services: translation; editing and proofreading; document layout; transfer of color images from the original; preparation of printed and electronic versions. Output file: PDF. Please… Text Translation, Technical Documentation ∙ 2 days 20 hours back ∙ 29 proposals |