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.