Office 2016 - myitlab:grader - Instructions Excel Project Excel Ch 2 Grader Project - Exam Project Description: Assume that you are a political science major and have been asked to analyze some demographic data pertaining to U.S. Presidents. Your worksheet needs to evaluate several criteria, while implementing a variety of cell formats and styles. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step 1 2 3 Points Possible Instructions Download and open the CIS250-Presidential-Data_Start.xlsx file, then save it to your PC. Explore the worksheet to be sure you have a good understanding of the data, but do not alter any of the content unless specifically requested in the following instructions. Rename the worksheet from its default name of Sheet1 to POTUS (President of the United States). Insert a new column at the beginning of the worksheet immediately before the column that has the names of each U.S. President. Enter the text Number as a column heading. Using your mouse and a single menu button, adjust the resulting cell format so that it precisely matches the other column headings. Enter the number 1 in cell A2. Next, create a simple formula in cell A3 that will increment the value in cell A2 by one. Then copy cell A3 down the entire column so that the last cell reflects the total number of U.S. Presidents to date. 2.000 4.000 7.000 Apply All Borders to the data within this worksheet, followed by a Thick Box Border. 4 4.000 Note: Do not alter the column headings. 5 Insert a function in cell H1 to display the current date, then modify the result to display it in a Long Date format. Adjust the column width so that the entire date is visible. 8.000 6 In cell H2, display the current time of day in a custom format of h:mm AM/PM, with no date shown. 6.000 7 In cell H3, enter the date that Donald J. Trump was inaugurated as the 45th President of the United States. Modify the resulting date to display it in a sequential serial number format. 4.000 8 In cell H4, provide a simple formula that will determine the number of days that President Trump has been in office, using cell references only. 4.000 9 Provide a formula in cell B47 that will determine the number of U.S. Presidents using their names as a reference point. 5.000 In cell C47, use a logical expression that will determine whether the result of the preceding step matches the highest value shown in column A. 10 Note that your result should render the text It definitely matches! in cell C47. 8.000 Now align the resulting text so that it is precisely in the middle of the cell and then apply a bold format. Updated: 08/15/2017 1 Current_Instruction.docx Office 2016 - myitlab:grader - Instructions Excel Project Step Instructions Points Possible 11 In cell D47, combine a basic function with the result of a function used in one of the steps above to determine the statistical mean age of all U.S. Presidents. Adjust the display format to the nearest tenth or one significant place after the decimal point. 8.000 12 Provide a formula in cell D48 that will render the age of the second youngest U.S. President as determined by their age at inauguration. 6.000 In cell E47, provide a simple expression that will display a TRUE result if the average age of the President is less than 55 years old. Otherwise display FALSE. 13 14 4.000 Note: Your formula should not use any functions and the result must render a Boolean TRUE or FALSE, not a text string. Provide a formula in cell F47 that uses only a single function to determine the statistical mean salary for all of the U.S. Presidents. Apply the Currency format, adjusting the column width to approximately 11, thus showing the entire result with two significant digits after the decimal point. 9.000 15 In cell G47, use a function to round the result of the preceding step to the nearest penny. Adjust the cell format to show the result in U.S. currency. 6.000 16 Provide a formula in cell F48 that will render the fourth highest salary of all the Presidents. 6.000 In cell G48, provide a logical expression that compares the resulting values in the previous two steps to determine whether or not they are equal. The answer may surprise you! 17 9.000 Note: Your result should show the text Identical or Different in cell G48. Align the result so that it is precisely in the middle of the cell and italicize the resulting text. 18 Save and close the workbook, then submit the file for grading as directed. 0.000 Total Points Updated: 08/15/2017 2 100.000 Current_Instruction.docx U.S. President George Washington John Adams Thomas Jefferson James Madison James Monroe John Quincy Adams Andrew Jackson Martin Van Buren William Henry Harrison John Tyler James K. Polk Zachary Taylor Millard Fillmore Franklin Pierce James Buchanan Abraham Lincoln Andrew Johnson Ulysses S. Grant Rutherford B. Hayes James A. Garfield Chester A. Arthur Grover Cleveland Benjamin Harrison Grover Cleveland William McKinley Theodore Roosevelt William Howard Taf Woodrow Wilson Warren G. Harding Calvin Coolidge Herbert Hoover Franklin Roosevelt Harry S. Truman Dwight D. Eisenhower John F. Kennedy Lyndon B. Johnson Richard M. Nixon Gerald Ford Jimmy Carter Ronald Reagan George H. W. Bush Bill Clinton George W. Bush Barrack H. Obama Donald J. Trump Religious Affliiation Episcopalian Unitarian None Episcopalian Episcopalian Unitarian Presbyterian Dutch Reformed Episcopalian Episcopalian Presbyterian Episcopalian Unitarian Episcopalian Presbyterian None None Methodist None Disciples of Christ Episcopalian Presbyterian Presbyterian Presbyterian Methodist Dutch Reformed Unitarian Presbyterian Baptist Congregationalist Society of Friends (Quaker Episcopalian Baptist Presbyterian Roman Catholic Disciples of Christ Society of Friends (Quaker Episcopalian Baptist Disciples of Christ Episcopalian Baptist Methodist United Church of Christ Presbyterian Age Political Party 57 Federalist 61 Federalist 57 Democratic-Republican 57 Democratic-Republican 58 Democratic-Republican 57 Democratic-Republican 61 Democrat 54 Democrat 68 Whig 51 Whig 49 Democrat 64 Whig 50 Whig 48 Democrat 65 Democrat 52 Republican 56 Democrat 46 Republican 54 Republican 49 Republican 50 Republican 47 Democrat 55 Republican 55 Democrat 54 Republican 42 Republican 51 Republican 56 Democrat 55 Republican 51 Republican 54 Republican 51 Democrat 60 Democrat 62 Republican 43 Democrat 55 Democrat 56 Republican 61 Republican 52 Democrat 69 Republican 64 Republican 46 Democrat 54 Republican 47 Democrat 70 Republican Salary 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 25000 50000 50000 50000 50000 50000 50000 50000 50000 75000 75000 75000 75000 75000 75000 75000 100000 100000 100000 200000 200000 200000 200000 200000 200000 400000 400000 400000