Using Excel, could you help and provide insight on how to do the following:

0. Create a new excel sheet and name it POS. You may use excel functions like unique( ), lookup( ), vlookup( ), sum( ), countif( ), if( ), round( ) etc. You may get as creative as you want but your excel sheet must at least have the following columns:

   • - Column to scan the barcode for all the products which are sold.

   • - Columns to indicate the name, quantity sold, sales price for all the products sold.

   • - Columns to indicate the total sales cost, tax amount and total amount.

   • - Columns to indicate card and cash payments along with remaining balance. [Sale cannot

     be completed if the remaining balance is greater than 0.]

   • **The excel sheet should update automatically as new entries are given.**

AutoSave DFF ASF90 store_blank.slax - Read-Only Home Draw Page Layout Formulas Data Review Viera Developer Tell me Share Comments O Insert X Cut LL Copy Formal Calibri (ody) - 11 A A == 25 Wrap Text General Nam lad Gol Neutral ,, Aureum FUL Cle Paste A 33 Merpes Center Calcu Check Cell Conditional Formal Farang wala | Ergoory ... | Insert Delete Format sort & Find Sak IN Analyze Cu. H12 H K MNC P R T U 2 A A 10 AF A Lande Card 500 Rukavice Total de 2500 Groot 200 w PRINT 11 A 2 04 3361 KI SS MM GAR D Slike Codice Weedles 25 20 15 18 101 S 180 so an 5 12 10 6 20 2 1 95 150 2 10 1 15 16 13 INVENTORY + Ready 17 FM - P 00% AutoSave DFF ASF90 store_blank.slax - Read-Only Home Draw Page Layout Formulas Data Review Viera Developer Tell me Share Comments O Insert X Cut LL Copy Formal Calibri (ody) - 11 A A == 25 Wrap Text General Nam lad Gol Neutral ,, Aureum FUL Cle Paste A 33 Merpes Center Calcu Check Cell Conditional Formal Farang wala | Ergoory ... | Insert Delete Format sort & Find Sak IN Analyze Cu. H12 H K MNC P R T U 2 A A 10 AF A Lande Card 500 Rukavice Total de 2500 Groot 200 w PRINT 11 A 2 04 3361 KI SS MM GAR D Slike Codice Weedles 25 20 15 18 101 S 180 so an 5 12 10 6 20 2 1 95 150 2 10 1 15 16 13 INVENTORY + Ready 17 FM - P 00%