1. Write a formula that would return a TRUE result if the sum of the first five numbers in a column of data are negative (for example, if you wanted to quickly know if the column had more expenditures than income). 2. Provide an example of a common business-related task or problem (payroll, inventory management, budgeting, profit-loss statements, etc.) that benefits from the use of cross-sheet referencing.

3. Provide an example of formula (with proper syntax) that would check whether cell B5 has a negative number and return a value of “negative” if it was and “not negative” the value was zero or higher.

Write a function processpeople() that takes the name of a file as a parameter. each line of the file corresponds to information about a person. in particular a line contains either a name (in the form lastname,firstname with no spaces in it) or a name (lastname,firstname) and a year. the function will process the file, creating a person object for each line in the file. the function will print information about each line as it processes it, as well as appending the new person object into a list. make sure to use person methods to display information rather than recreating the work you did for the first problem. once the entire file has been processed, the function returns the list of person objects created from the file. if the file is empty, the function should return an empty list. if the input file cannot be opened, the function should print a message to that effect and then return an empty list. the following shows what would be displayed for two example files which have been provided in the link. the file none.txt does not exist. note that your function must work on an arbitrary file that consists of valid lines. you cannot assume anything about the file except that it contains lines that have the format described above.

2.)how does a graphical user interface (gui) on a touchscreen interface differ from a gui on a desktop or laptop? a.)a finger or stylus is used instead of a pointer. b.) a magic wand is used instead of a pointer. c.)users speak commands instead of using a pointer. d.)users visualize commands instead of using a pointer.

Awell-diversified portfolio needs about 20-25 stocks from different categories is this true or false?