Connie needs to use the data consolidation tool in Excel 2016. Where can she find this capability? Data tab and Data Tools group Data tab and External Data group Formula tab and Calculation group Review tab and Changes group

Afile named data.txt contains an unknown number of lines, each consisting of a single integer. write some code that creates two files, dataplus.txt and dataminus.txt, and copies all the lines of data1.txt that have positive integers to dataplus.txt, and all the lines of data1.txt that have negative integers to dataminus.txt. zeros are not copied anywhere.