A list of the unique journal names. In one table: list the journals by rank with columns for journal, journal rank, journal title and main author together with a count of the publications in each journal by each author. Filter out the journals that have no ranking (marked N/A or not applicable). Draw a line graph of total publications by year. Produce a table of total publications by year by F-T and P-T faculty categories (years should be listed on the horizontal axis.) Depict the same data in a vertical bar graph. Important: The results of each exercise should be contained in ONE spreadsheet consisting of a number of worksheets, each worksheet should have an appropriate title and date at the top and each worksheet tab should be appropriately labeled.